What does this tool do?
This free JSON to CSV converter flattens a JSON array of objects into a CSV table you can open in Excel, Google Sheets, or any spreadsheet — and converts CSV back to JSON with the reverse toggle. It runs entirely in your browser, so nothing you paste is uploaded.
What JSON shape does it expect?
The cleanest input is an array of objects, where each object is one row:
[
{ "name": "Ann", "age": 30, "city": "Paris" },
{ "name": "Bob", "age": 25, "city": "Berlin" }
]
The converter collects the union of all keys across the objects to build the header row, so objects that are missing a field simply get an empty cell. A single object (not in an array) is treated as a one-row table.
How quoting works
CSV values that contain a comma, double quote, or newline are automatically wrapped in double quotes, and any inner quotes are doubled — the standard RFC 4180 escaping. Nested objects or arrays inside a cell are written as compact JSON so no data is lost.
How to use it
- Paste JSON on the left; the CSV appears live on the right.
- Copy the CSV or Download a
.csvfile ready for your spreadsheet. - Switch the toggle to CSV → JSON to go the other way; the JSON indent control formats that output.
- Invalid JSON shows a clear error message.
Common uses
- Export an API's JSON response into a spreadsheet for analysis or sharing.
- Hand a non-technical colleague a CSV instead of raw JSON.
- Bulk-load data into a tool that only accepts CSV.
FAQ
What JSON shape does the converter expect?
An array of objects, like [{"name":"Ann","age":30}]. Each object becomes a row and the keys become column headers.
How are commas and quotes handled?
Any value containing a comma, quote, or newline is wrapped in double quotes and inner quotes are doubled, following standard CSV (RFC 4180) rules.
What about nested objects?
Nested objects and arrays are serialized as compact JSON inside the cell so nothing is dropped.
Is my data uploaded?
No. Everything runs in your browser; nothing you paste leaves your device.