JSON to CSV
Turn a JSON array of objects into spreadsheet-ready CSV.
Convert JSON data into CSV that opens cleanly in Excel or Google Sheets. Paste an array of JSON objects and get a CSV where the object keys become column headers, so data from an API, an app or a database export becomes a spreadsheet you can sort, filter and share with people who do not work with JSON. It is the perfect companion to our CSV to JSON tool, and together they cover both directions of the same everyday task: moving data between a system that speaks JSON and a person who works in a spreadsheet. A manual conversion means copying columns one by one and risking a misaligned row, while this keeps every value under the right header. The conversion runs in your browser, so your data stays private and is never uploaded.
Getting API data into a spreadsheet
This conversion nearly always exists for the same reason: someone technical has data as JSON, and someone else needs to open it in Excel or Google Sheets. Analysts filter and pivot in spreadsheets, finance teams reconcile in them, and clients expect them. Converting is faster than building a report, and the result goes straight into the free online tool the other person already knows.
The problem with nesting
JSON can nest objects and arrays to any depth. CSV cannot; it is a flat grid. So converting means flattening, which either turns a nested path into a compound column name or drops the structure entirely. If your JSON contains an array of items inside each record, there is no clean single-table representation of it, and the honest answer is that some data will not survive the trip.
Practical notes
- The conversion works best on a flat array of objects with consistent keys.
- Records missing a key produce empty cells rather than shifted columns.
- Values containing commas or quotes are quoted and escaped, which is correct even though it looks odd in a text editor.
- Check the encoding when opening in Excel, since UTF-8 without a byte order mark can display accented characters wrongly.
How to use JSON to CSV
- 1
Paste a JSON array of objects.
- 2
Click convert.
- 3
Copy the CSV output.
Frequently asked questions
An array of objects, where each object becomes a row and its keys become columns.