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 a CSV

Converti array JSON di oggetti in CSV. Rilevamento campi, separatori personalizzati, escape compatibile con Excel e Google Sheets.

Delimiter

Output

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

CSV output

Inserisci un input sopra per vedere il risultato.

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.