ToolsBench

JSON to CSV

Flatten a JSON array of objects into a spreadsheet.

Input
Output

About JSON to CSV

Converts a JSON array of objects into CSV you can open in Excel, Google Sheets or Numbers. Each object becomes a row and each key becomes a column header — handy for turning an API export or a database dump into something a spreadsheet (or a colleague) can work with.

How to use JSON to CSV

1
Paste a JSON array
The input should be an array of objects, e.g. [{"name":"Ada"},{"name":"Linus"}]. Click Sample to see the expected shape.
2
Review the CSV
Column headers are taken from the object keys. Values containing commas or quotes are escaped automatically.
3
Download data.csv
Save the file and open it directly in any spreadsheet app.

Frequently asked questions

Is my data uploaded anywhere?
No. Everything you paste is processed by JavaScript running in your browser tab. Nothing is sent to a server, logged or stored — close the tab and it's gone.
My objects have different keys — what happens?
The union of all keys becomes the header row; objects missing a key simply get an empty cell in that column.
Does it handle nested objects?
Nested values are serialized as JSON strings inside the cell. For deeply nested data, flatten it first with the JSON Formatter.