JSON to CSV Converter
Convert a JSON list of objects to CSV that opens in Excel or Google Sheets. Nested objects become columns such as address.city, and nothing is uploaded.
0 characters · 2,000,000 remaining
0 characters
Paste CSV or JSON above and the result appears here, converted in your browser.
On this device
No signup. Your input is never uploaded.
How to use the JSON to CSV Converter
Paste a JSON list of objects, or load the example.
Choose the separator and whether to include a header row.
Copy the CSV, or download it to open in a spreadsheet.
An example
A list of two people
You enter
[{"name":"Ada","age":36,"city":"London"},{"name":"Linus","age":28,"city":"Helsinki"}]You get
name,age,city Ada,36,London Linus,28,Helsinki
How the JSON to CSV Converter works
Each object in the list becomes a row, and the keys become columns, in the order they first appear. Values with commas, quotes, or line breaks are quoted by the standard CSV rules, so the file opens correctly in a spreadsheet.
Limits to know about
- Up to 2 million characters of input are accepted.
- Lists inside objects are written into a single cell as JSON text, because CSV has no way to nest.
- Every item in the list has to be the same kind: all objects, all lists, or all plain values.
Questions about the JSON to CSV Converter
Paste a JSON list of objects. Each object becomes a row, and the keys become the column names in the first row. The CSV appears as you type, ready to copy or download.
With Flatten nested objects on, an object inside an object becomes a column named with dots, such as address.city. Lists are written into one cell as JSON text, because CSV has no way to nest.
Every key becomes a column, in the order it first appears, and a row that lacks a key gets an empty cell. Nothing is dropped.
A cell that starts with =, +, -, or @ can run as a formula when the file is opened in a spreadsheet. Protect from formulas puts a quote mark in front of such text so it shows as text. Turn it on for data from outside sources.
Last updated