JSON to CSV Converter
convert
output
About the JSON to CSV converter
This tool turns a JSON array of objects into a CSV table that spreads open in sheets, SQL importers, and reporting tools. Each object becomes a row, and the union of every object's keys becomes the header line, so rows with different shapes still end up in one coherent table. Everything runs in your browser — the payload never leaves the page.
How nested data is handled
CSV is flat, so nested objects are flattened into dotted columns:{"meta":{"team":"Platform"}} becomes ameta.team column. Arrays (and empty objects) can't be flattened safely, so they fall through as compact JSON in the cell — useful when you need the original data preserved byte-for-byte. Cells are only quoted when the value contains a comma, quote, or newline, so the output stays readable.
Edge cases and limitations
A single object converts to a one-row table; the root must be an object or an array of objects, so an array of primitives is rejected. Sparse rows leave empty cells rather than collapsing the table, and there is no size cap other than your browser's memory. If your pipeline needs true JSON-to-JSON flattening instead, the JSON formattercan reshape documents for you.
Related tools
Inspect or reformat your source with the JSON formatter, or compare two versions of a document with the JSON difftool before you ship the table downstream.
FAQ
Can I round-trip back to JSON?
Not losslessly — nested columns flatten and empty cells lose their null distinction. Use CSV as a one-way export into spreadsheets.
Is there a file size limit?
No hard limit — only what your browser can hold in memory.