JSON to CSV
Turn a JSON list of records into CSV, with nested objects flattened into columns
How to use it
- Paste your JSON into the box, or press Open file.
- Choose how nested objects and lists are written.
- Copy the CSV, or download it as a file.
Questions
What JSON shapes work?
A list of objects (the usual API response), a list of lists, a list of plain values, one object (it becomes one row), and JSON Lines with one object per line. If the JSON is an object that holds a single list, such as {"data": [...]}, that list is used.
How are nested objects written?
With Turn nested objects into columns on, {"address": {"city": "London"}} becomes a column named address.city. With it off, the nested object is written as JSON text in one cell.
Do large numbers lose digits?
No. Numbers are copied as written, so an ID such as 12345678901234567890 comes out whole, and 1.10 stays 1.10.
What if the records have different keys?
The columns are the keys of all records, in the order they first appear. A record without a key gets an empty cell.
Is my data uploaded anywhere?
No. The conversion runs in your browser. Your text is not sent to a server.
Is my text sent to a server?
No. Everything happens in your browser. Your text is not uploaded or stored.
Is it free?
Yes, you can use it for free. A subscription removes limits and unlocks premium tools.