Turning an API response into a CSV for a stakeholder who only opens spreadsheets. Exporting a pile of records from a JSON dump into something you can pivot/filter in Sheets. Generating fixture rows for database imports that take CSV.

Header inference uses the union of all object keys. A row missing a key becomes an empty cell; the column doesn't disappear. Nested objects/arrays are stringified. If you need a flattened CSV (one column per nested key), pre-flatten the JSON before feeding it in. Excel + delimiters. European locales default to semicolons; switch the delimiter so the file opens with columns instead of one giant line. RFC 4180 escaping is applied either way. UTF-8 BOM. Excel on macOS sometimes garbles non-ASCII without a BOM. This tool does NOT prepend one — paste the output through a BOM-adding step if you see mojibake.

JSON to CSV

Convert JSON arrays of objects to CSV. Auto-detects fields, supports custom delimiters, escapes properly for Excel and Google Sheets.

Delimiter

Output

JSON input (array of objects, or array of arrays)

CSV output

Enter input above to see the result.

What is this for?

The reverse trip: feed in a JSON array and get out a CSV ready for Excel, Google Sheets, or any data tool that prefers tabular formats. Headers are auto-detected from object keys; nested values get JSON-stringified into single cells so nothing silently disappears.

When to use it

Turning an API response into a CSV for a stakeholder who only opens spreadsheets.
Exporting a pile of records from a JSON dump into something you can pivot/filter in Sheets.
Generating fixture rows for database imports that take CSV.

Common gotchas

Header inference uses the union of all object keys. A row missing a key becomes an empty cell; the column doesn't disappear.
Nested objects/arrays are stringified. If you need a flattened CSV (one column per nested key), pre-flatten the JSON before feeding it in.
Excel + delimiters. European locales default to semicolons; switch the delimiter so the file opens with columns instead of one giant line. RFC 4180 escaping is applied either way.
UTF-8 BOM. Excel on macOS sometimes garbles non-ASCII without a BOM. This tool does NOT prepend one — paste the output through a BOM-adding step if you see mojibake.