JSON → CSV

Convert a JSON array into CSV

Flatten an array of JSON objects into a CSV table you can open in a spreadsheet. Column headers are collected from across every object, so records with differing fields still line up correctly, and values needing quotes or escaping are handled properly.

How to use it

1. Paste a JSON array of objects, in the form [{"id":1,"name":"a"}].
2. Conversion runs automatically, gathering the full set of keys for the header row.
3. Review the CSV output.
4. Copy it, or paste it straight into a spreadsheet.

Frequently asked questions

It says my JSON must be an array of objects.

CSV is inherently a flat table, so the input has to be a top-level array of objects. If your data is wrapped in something like {"results": [...]}, extract that inner array first.

What happens to nested objects and arrays?

They are serialised as JSON text inside the cell, since CSV has no way to express nesting. Flatten your structure beforehand if you need those values in separate columns.

Do all objects need identical keys?

No. Headers are collected across every object in the array, and any record missing a key gets an empty cell for that column.

Are commas and quotes inside values handled?

Yes. Values containing commas, quotes or line breaks are wrapped in double quotes, with internal quotes doubled, following the standard CSV convention.