JSON to CSV
Flatten nested JSON into a tidy CSV that opens straight in Excel.
How it works
- 01Paste JSON or drop a .json file. Arrays, single objects and JSON Lines all work.
- 02Pick a delimiter and how arrays are written. Nested objects become columns like address.city.
- 03Copy the CSV or download it. Tick "add BOM for Excel" if accents or emoji look garbled in Excel.
Questions
›What happens to nested objects?
They are flattened into dot-named columns, so {"address": {"city": "Paris"}} becomes a column called address.city. Untick "flatten nested objects" to keep each nested object as JSON text in a single cell.
›What if my objects have different keys?
Every key from every object becomes a column, in the order the keys first appear. A row without a key simply gets an empty cell there.
›Which JSON shapes work?
An array of objects is the usual input. A single object becomes one row, an object of objects becomes one row per key, and if your records sit inside a wrapper like {"data": [...]}, the largest array of records is used. JSON Lines, with one object per line, works too.
›Why do accents look wrong when I open the CSV in Excel?
Excel can open CSV files in an older encoding unless the file starts with a byte order mark (BOM). Tick "add BOM for Excel" and characters like é, ü and emoji show up correctly.
›Are my files uploaded anywhere?
No. Your files are processed on your own device by your browser. They never touch our servers, so there are no upload waits, no size caps from us, and nothing to delete afterwards.