JSON to CSV Converter
Turn a JSON array into CSV for Excel or Sheets, flattening nested fields.
How to use JSON to CSV Converter
- Paste a JSON array (or an object containing one).
- Choose the delimiter your spreadsheet expects.
- Download the .csv file and open it in Excel or Google Sheets.
How it works
Each object becomes a row and every key that appears in any object becomes a column, so rows with missing fields get empty cells. Nested objects are flattened into dot-notation columns such as address.city; arrays of simple values are joined with "; ", and arrays of objects are kept as JSON text in one cell.
Values containing the delimiter, quotes or line breaks are quoted per RFC 4180, so the file opens correctly in spreadsheet apps.
Example
[{"name":"Ada","address":{"city":"London"}}] becomes the columns name, address.city with one row: Ada, London.
Frequently asked questions
My JSON is an object, not an array. Will it work?
Yes. If the object contains an array (for example {"items": [...]}), that array is converted. Otherwise the object becomes a single row.
Why does Excel put everything in one column?
Some regional Excel settings expect semicolons. Choose "Semicolon" as the delimiter and download again.
Can I convert back?
Use the CSV to JSON converter. Flattened columns stay flat; they are not rebuilt into nested objects.
Is anything uploaded?
No, conversion runs entirely in your browser.
Limitations
- Deeply nested arrays of objects are stored as JSON text in a single cell.
- Columns appear in the order keys are first seen.
Last reviewed November 9, 2026. How we build and test tools.