Skip to content
SUMILORASUMILORA

JSON to CSV

Developer tools

Paste a JSON array of objects. Nested values become dotted columns.

Runs in your browser

Nothing is uploaded. The work happens on your own device, so your file or text never reaches us.

About this tool

How nesting is flattened

CSV is flat and JSON is not, so something has to give.

Nested objects become dotted columns: {"user": {"name": "A"}} becomes a column user.name. Arrays of simple values are joined with semicolons into one cell. Arrays of objects become indexed columns, items[0].price.

Keys missing from some objects still get a column, left empty where absent, so the output is rectangular — which is the only thing a spreadsheet can open.

Questions

What happens to nested arrays?

Arrays of simple values are joined with semicolons in one cell. Arrays of objects are expanded into indexed columns like items[0].name.

Will Excel open the result?

Yes. Fields containing commas, quotes or newlines are quoted correctly, and line endings are CRLF, which is what Excel expects.

Related tools