JSON to CSV
Turn JSON arrays into CSV or TSV instantly.
100% private — runs in your browser, nothing is uploaded.
How to use the JSON to CSV
- 1Paste your JSON
Add a JSON array of objects to the input box.
- 2Choose options
Pick a delimiter (comma, semicolon or tab) and whether to include a header row.
- 3Review the CSV
The converted table appears instantly with a row count.
- 4Copy or download
Copy the CSV to your clipboard or download a .csv / .tsv file.
Examples
| Input | Output |
|---|---|
[{"a":1,"b":2},{"a":3,"b":4}] | a,b
1,2
3,4 |
[{"name":"Sam, Jr."}] | name
"Sam, Jr." |
Free online JSON to CSV converter
This JSON to CSV converter turns a JSON array of objects into a comma-separated (or tab/semicolon-separated) table you can open in Excel, Google Sheets or any database import tool. Each object becomes a row and each property becomes a column — no scripting required.
Nested JSON, flattened automatically
Real-world API responses are rarely flat. When an object contains another object, this tool flattens it into dotted column names — address.city, address.zip — so the structure survives the trip to a spreadsheet. Arrays and other complex values are serialised as compact JSON so nothing is silently dropped.
Spreadsheet-safe by default
Values containing commas, quotes or line breaks are escaped following the standard CSV rules, so a name like “Sam, Jr.” lands in a single cell instead of splitting across two. Pick the Tab delimiter for a TSV that pastes straight into Excel.
Everything happens in your browser, so your data stays private and the tool works offline.
Frequently Asked Questions
How do I convert JSON to CSV?
Paste a JSON array of objects into the box. Each object becomes a row and each key becomes a column, converted to CSV automatically. Choose a delimiter and download or copy the result.
What JSON shape does it expect?
An array of objects works best — for example [{"name":"Ada"},{"name":"Alan"}]. A single object is treated as one row. Objects don't all need the same keys; the columns are the union of every key found.
How are nested objects handled?
Nested objects are flattened using dotted keys, so {"user":{"id":1}} becomes a column named user.id. Arrays and other complex values are written as compact JSON inside the cell.
Can I get a TSV file for Excel?
Yes. Pick the Tab delimiter to produce a TSV, which pastes cleanly into Excel and Google Sheets. Semicolon is also available for locales where that is the spreadsheet default.
How are commas and quotes inside values handled?
Any value containing the delimiter, a double quote or a line break is wrapped in double quotes, and inner quotes are doubled — the standard CSV escaping rule that spreadsheets expect.
Is my data uploaded anywhere?
No. The conversion runs entirely in your browser, so your JSON never leaves your device and the tool works offline.