JSON to CSV Converter

Plenty of tools export JSON when you actually need a spreadsheet. This converter takes a JSON array of objects and turns it into properly escaped CSV, using the union of every key it finds as the column headers.

How the column headers are chosen

The tool scans every object in your array and builds one combined list of column headers, in the order each key first appears. If one record has a field others don't, that column still gets created and left blank for the rows missing it.

This matters for irregular data, like an export where only some records have an optional "notes" field. Rather than dropping that column, every row gets it, just empty where there's nothing to put.

Escaping done the way spreadsheets expect

Any value containing a comma, a quote or a line break gets wrapped in double quotes, with internal quotes doubled, which is the standard CSV escaping rule that Excel, Google Sheets and most import tools expect.

Nested objects and arrays inside a field are converted to their JSON string form rather than dropped, so you don't silently lose data buried a level deep.

Pasting a single object instead of an array

If you paste a single JSON object rather than an array, the tool wraps it in an array automatically and produces a one-row CSV, so you don't have to manually add the square brackets first.

Need to go the other way, from CSV back to JSON? Use the companion CSV to JSON Converter.