JSON to CSV
About this tool
To drop an API list into a spreadsheet, convert an object array to CSV. Nested keys become columns — spot-check headers after conversion.
Features
- Turns an object array into rows
- Flattens nested keys with dots
- Output you can paste into Excel
How to use
- Paste a JSON array of objects.
- Convert to CSV.
- Copy or download and open in a spreadsheet.
When to use it
- An API user list should become a sheet
- Nested address.city needs its own column
- Ops wants a filterable CSV
Examples
- [{"name":"A","age":1}] headers are name,age.
- A nested city field becomes a column such as address.city.
FAQ
What if the JSON is not an array?
A list is required. Wrap a single object in an array first.
How are nested objects flattened?
Column names follow key paths. Deep trees are better flattened in your domain first.
Back to JSON Tools Hub