JSON to CSV Converter
Turn a JSON array of flat objects into CSV with a header row, ready to open in Excel or Google Sheets.
CSV
In short
What is the JSON to CSV Converter?
The JSON to CSV converter takes an array of flat objects and produces comma-separated text with a header row built from the keys. Cells containing commas, quotes or line breaks are quoted correctly. It is useful for opening API results in a spreadsheet or preparing data for import.
How to use it
- Paste a JSON array of objects, for example a list of records.
- Pick the delimiter: comma, semicolon or tab.
- Copy the CSV or download it as a file.
Questions
JSON to CSV Converter — FAQ
What JSON shape does it expect?
An array of objects such as [{"a":1},{"a":2}]. A single object is treated as one row.
What happens to nested objects?
Nested objects and arrays are written into the cell as JSON text, so no data is lost, but they are not split into columns.
Why use a semicolon delimiter?
Some spreadsheet settings, including many European and Indian locale defaults, expect semicolons rather than commas.
More Developer & Web tools
URL Encoder & DecoderHTML Entity Encoder & DecoderUUID GeneratorPassword GeneratorRandom Number GeneratorHEX to RGB Colour ConverterColour Contrast CheckerUnix Timestamp Converter
Go further