Data tools

Fourteen tools for the formats business data actually arrives in — and the four or five ways each of them quietly corrupts itself.

Exports are parsed on your device

The section where uploading matters most

A PDF you upload is one document. A CSV export is every customer you have — names, email addresses, phone numbers, order histories, sometimes salaries.

Converting one is a string operation. Your browser finishes it in milliseconds. There has never been a technical reason to send that file anywhere; the converters that do it were built as web applications, and the upload came with the architecture, not with the job.

Everything here parses in the tab. So it also works with the network unplugged, which is the easiest way to satisfy yourself, or a compliance officer, that the data stayed put.

Which tool do you need?

Between formats

CSV to JSON and back again handle the awkward parts — quoted delimiters one way, nested objects the other. CSV to Excel builds a real .xlsx, which sidesteps every encoding and delimiter problem CSV has. Excel to CSV reads a workbook without needing Excel installed.

JSON

The formatter tells you the line and column of a syntax error rather than a character offset. The minifier strips whitespace safely, by parsing rather than pattern matching. YAML and JSON convert both ways, with the indentation errors reported by line.

Fixing what arrived broken

The CSV cleaner trims the invisible whitespace that makes identical rows compare as different, and reports rows with the wrong column count. The encoding repair recovers the é and أ damage that CSV exports produce.

Reshaping

Merge combines files by column name, so a differently ordered export still lines up. Split breaks a large file into import-sized parts without cutting a record in half.

Documentation

Markdown to HTML and HTML to Markdown convert both ways — and doing both in sequence is the fastest way to strip a page back to clean markup. Table to Markdown turns a spreadsheet selection into a README table.