JSON to CSV Converter
Convert a JSON array of objects to CSV in your browser. Flattens nested objects with dot notation. Escapes per RFC 4180. Copy or download the file.
CSV output appears here...What is the JSON to CSV Converter?
A JSON to CSV converter takes an array of JSON objects and outputs a CSV table where each object becomes a row and the union of keys across all objects becomes the header. It's how you take API output and feed it to Excel, Google Sheets, or any analyst's preferred tool.
How to use the JSON to CSV Converter
- 1
Paste your JSON
Drop a JSON array of objects (e.g. [{"name":"John","age":30}, ...]) into the input pane. The structure should be flat or shallowly nested.
- 2
Click Convert
Object keys become column headers. Nested objects flatten via dot notation, so {"address":{"city":"NYC"}} becomes a column named "address.city".
- 3
Spot-check the output
Values containing commas, double quotes, or line breaks get properly escaped per RFC 4180, so opening the file in Excel just works.
- 4
Copy or download
Copy CSV puts the text on your clipboard. Download CSV saves it as data.csv, ready to open in any spreadsheet.
Frequently Asked Questions
What JSON format is expected?
An array of objects with consistent keys: [{"name":"John","age":30}, {"name":"Jane","age":25}]. Each object becomes a row, and the union of all keys across the array becomes the header. Single objects, primitives, or deeply mixed shapes won't convert cleanly.
How are nested objects handled?
Flattened with dot notation. {"user":{"address":{"city":"NYC"}}} becomes a column called "user.address.city". Arrays inside objects get serialized as JSON strings in the cell, so they survive the round-trip but aren't tabular.
Is the output valid CSV?
Yes, per RFC 4180. Fields containing commas, double quotes, or line breaks get wrapped in quotes with internal quotes doubled. The result opens cleanly in Excel, Numbers, Google Sheets, and any standards-compliant CSV parser.