JSON to CSV Converter
Turn JSON from an API or export into a CSV that opens straight in Excel or Google Sheets. Nested objects are flattened automatically, and your data never leaves your browser.
Converted on your device. Your data never leaves your browser.
How to convert JSON to CSV
- 1
Paste your JSON into the input box, drop a .json file onto it, or press Open file.
- 2
Pick a delimiter. Comma works for most tools; choose semicolon for Excel in many European locales.
- 3
Copy the CSV or press Download .csv and open it in Excel, Numbers or Google Sheets.
Why use this JSON to CSV converter
Flattens nested JSON
Nested objects become dotted columns like address.city, and arrays are kept as JSON text in a single cell.
Every key becomes a column
Objects with different fields are merged into one set of columns, so nothing is dropped.
Excel-ready
Downloads include a UTF-8 byte-order mark, so accents and non-Latin characters display correctly in Excel.
Private and instant
Conversion happens as you type, entirely in your browser. Nothing is uploaded.
Popular uses for the JSON to CSV converter
Open API responses in Excel
Turn JSON into rows and columns you can sort and filter.
Share data with non-developers
CSV opens in any spreadsheet app.
Import into CRMs and email tools
Most import screens accept CSV.
Flatten nested data
Nested objects become dotted columns automatically.
Also known as: JSON to CSV converter, JSON to Excel, JSON to spreadsheet and flatten JSON.
People also search for
- convert json to csv for excel
- json to csv online free no upload
- nested json to csv
- api response json to spreadsheet
- json array to csv converter
- open json file in excel
A fast browser file utility for data
Convert CSV, JSON and YAML, or encode images as Base64, with a free online file converter that needs no install. It's a client-side file converter, so private data, exports and API keys stay on your device instead of being sent to a server.
Frequently asked questions
What JSON structures are supported?
An array of objects (the most common API format), an array of arrays, an array of plain values, or a single object. Each object becomes one CSV row.
How are nested objects and arrays handled?
Nested objects are flattened into dotted column names, so {"address": {"city": "Paris"}} becomes an address.city column. Arrays are written as JSON text in one cell so they can be parsed back later.
How do I open the CSV in Excel?
Download the file and double-click it, or use Data → From Text/CSV in Excel. If all your data lands in one column, your Excel locale probably expects semicolons, so switch the delimiter to Semicolon and download again.
Is my JSON validated?
Yes. If the JSON is invalid, you'll see the parser's error message so you can find and fix the problem.
Are my files uploaded to a server?
No. Conversion runs entirely in your browser via client-side JavaScript, on your own device. Your files never touch a remote server and nothing is stored, so it's a secure, private, no-upload tool for personal photos and confidential data, and it keeps working on slow connections.