Paste your JSON in the box below — or open a .json file. The CSV appears underneath at once.
About converting JSON to CSV
JSON is how apps and APIs send data. CSV is how spreadsheets, databases and import tools take it in. When you export orders, contacts or logs from a web service, you often get JSON — but your boss, your shop software or your mailing tool wants a CSV.
This converter turns a JSON array into CSV rows: each object becomes one row, each key becomes one column. Paste the JSON or open a .json file, and the CSV appears below as you type.
Everything runs in your browser. Your data is never uploaded.
Features
- Live output — the CSV changes as you type or paste
- Nested objects flattened — {"address": {"city": "London"}} becomes a column address.city
- Every key becomes a column — even keys that only some objects have
- Finds the list — when your rows sit inside an object like {"data": [...]}, that list is used
- Open or drop a .json file — the CSV is named after it
- Delimiter — comma, semicolon, tab or pipe
- Correct quoting — commas, quotes and line breaks inside values are kept safe
How nested JSON becomes columns
A CSV is flat: one row, one value per column. JSON can nest. With Flatten nested objects on (the default), the converter walks into each object and joins the keys with a dot. Here is what happens to each kind of value:
| JSON value | CSV cell |
|---|---|
"name": "Ada" | column name = Ada |
"address": {"city": "London", "zip": "W1J 7NT"} | columns address.city = London and address.zip = W1J 7NT |
"tags": ["math", "code"] | column tags = math, code |
"items": [{"id": 1}, {"id": 2}] | column items = the list as JSON text |
"paid": true | true |
"note": null | an empty cell |
With Flatten off, a nested object stays in one cell as JSON text, so nothing is lost — you never get "[object Object]".
The example in the box turns into this CSV:
| id | name | address.city | address.zip | tags |
|---|---|---|---|---|
| 1 | Ada Lovelace | London | W1J 7NT | math, code |
| 2 | José Álvarez | Madrid | 28013 | design |
When the rows sit inside an object
Many APIs wrap their list: {"status": "ok", "count": 2, "data": [ … ]}. The converter looks inside, finds the longest list of objects, and uses it. The line under the box tells you which one it used, for example *Used the list in "data"*. A single object with no list inside becomes one row.
Comma or semicolon?
Comma is the standard. But Excel in many European countries expects a semicolon, because there the comma is the decimal mark. If your CSV opens in Excel with everything in column A, choose Semicolon and download again. To skip that problem, make a real Excel file with JSON to Excel.
Frequently asked questions
How do I convert a JSON file to CSV?
Click "Open a .json file" (or drop the file on the box). The CSV appears at once. Press Download to save it — the file gets the same name as your JSON.
How are nested objects handled?
Each nested key becomes its own column, joined with a dot: customer.address.city. Untick "Flatten nested objects" to keep each nested object as JSON text in one cell instead.
What if my objects have different keys?
Every key found in any object becomes a column. Rows that do not have that key get an empty cell.
Can I turn the CSV back into JSON?
Yes — switch to CSV → JSON at the top, or use the CSV to JSON page.
Is there a size limit?
No upload limit, because nothing is uploaded. Very large files (tens of MB) can make the page slow while it converts.
Is my data safe?
Yes. The conversion runs inside your browser. Nothing is sent to a server.
Related tools
- JSON to Excel — the same data as a real .xlsx workbook
- CSV to JSON — the other direction
- JSON Formatter — check and tidy your JSON first
- Merge CSV Files — join this CSV with others
- CSV to Excel — open the CSV in Excel without losing leading zeros
How to use it
- Paste your JSON into the box — or click Open a .json file
- Keep Flatten nested objects on to get one column per nested key
- Choose the delimiter — comma for most programs, semicolon for Excel in many European countries
- Check the CSV in the output box
- Press Copy, or Download to save a .csv file
