JSON to CSV
Turn JSON data into a CSV file you can open in Excel or Google Sheets.
or drop them here · up to 50 MB per file, free
Bigger files? Pro converts files up to 500 MBOver the free limits: you can unlock the download from €1.99.
Working on it…
Your file is ready
Free · No sign-up · No watermark · Your files never leave your device
JSON to CSV in 3 steps
- Select your JSON file, or drop it on the box.
- Click Convert to CSV.
- Download the CSV and open it in your spreadsheet.
From nested JSON to flat columns
Spreadsheets need flat rows and columns, while JSON is often nested. The converter flattens nested objects into dotted column names: an address object with a city becomes an "address.city" column. Lists inside a record are kept as text in a single cell so no data is lost.
An array of objects becomes one row per object, and every key that appears in any object gets a column. A single object becomes a single row.
Frequently asked questions
How do I convert JSON to CSV?
Select your JSON file and click Convert to CSV. Each object in the array becomes a row and each key becomes a column. Download the CSV and open it in Excel, Numbers or Google Sheets.
What happens to nested JSON objects?
They are flattened into columns with dotted names, such as "address.city" or "user.email". Lists are written as JSON text inside one cell, so every value from the original file is still there.
Why does my JSON show an error?
The file has to be valid JSON. A missing comma, a trailing comma or an unclosed bracket stops it from being read. The error message tells you what went wrong, and JSON Formatter can help you find it.
Is my data uploaded anywhere?
No. The file is read and converted in your browser, on your own device. Nothing is sent to a server, which makes the tool safe for API exports with personal or business data.