JSON to CSV converter
Paste a JSON array of objects and get a CSV table you can open in Excel, Numbers or Google Sheets. Download the result as a .csv file or copy it.
How it works
-
Paste your code
Paste the code in the left box or open a file. No code to hand? Click Example.
-
Instant result
The result appears as you type. If there is an error, you see the line and character.
-
Copy or download
Copy the result with one click or save it as a file for your editor or project.
How does JSON become a table?
Every object becomes a row and every key a column. Nested objects are flattened with a dot, so address.postcode gets its own column. Arrays inside an object are written as JSON text in one cell. If an object lacks a key, that cell stays empty.
Comma or semicolon?
Google Sheets and English versions of Excel expect a comma, which is the default here. Many European versions of Excel expect a semicolon, because the comma is their decimal separator; with that option 41.5 is written as 41,5. Cells that contain the separator, quotes or line breaks are quoted properly.
Going the other way? Use CSV to JSON.
Frequently asked questions
Is the JSON to CSV free?
Yes. The JSON to CSV is completely free, with no account, sign-up or usage limit.
Is my code stored?
No. Your code is processed in your browser and is not sent to a server or stored.
Does it work on my phone?
Yes. The tool works in any modern browser on a phone, tablet or computer.