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

Convierte arrays JSON de objetos en CSV. Detecta campos, soporta separadores personalizados, escapado para Excel y Google Sheets.

Delimiter

Output

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

CSV output

Introduce un valor arriba para ver el resultado.

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.