JSON to CSV Converter
Turn a JSON array into a clean CSV that opens correctly in Excel and Google Sheets. Nested objects become columns like address.city, and every key is kept.
Runs in your browser — your code is never uploaded. Tip: drop a file on the input box, or press Ctrl + Enter.
How to Convert JSON to CSV
From API data to a spreadsheet in three steps.
Paste or Upload JSON
Paste a JSON array (or a single object), or upload a .json file.
Check the Options
Pick the separator, keep the header row, and flatten nested objects into their own columns.
Download CSV
Download data.csv and open it in Excel, Google Sheets or Numbers.
Nested data
Flattened to columns
Separator
Comma, ; or |
Any language
UTF-8 + Excel BOM
Privacy
Runs in your browser
Works on
Phone & computer
Price
100% free
How JSON Becomes CSV
Each object becomes a row and each key becomes a column.
| JSON | CSV |
|---|---|
[{"id":1,"name":"Asha"}] | id,name1,Asha |
{"address":{"city":"Pune"}} | Column address.city = Pune |
{"tags":["a","b"]} | ["a","b"] kept in one cell |
| Different keys in each object | All keys become columns; missing values are left empty |
| Text with commas or quotes | Wrapped in quotes and escaped, so Excel reads it correctly |
{"data":[…]} | The list inside is used automatically |
What Can You Use It For?
Popular ways people use JSON to CSV Converter.
Open API Data in Excel
Analyse JSON exports in a spreadsheet.
Database Imports
Prepare JSON records for MySQL or PostgreSQL CSV import.
Reports
Share data with people who do not read JSON.
Store Exports
Convert Shopify, WooCommerce or CRM exports to CSV.
Tips for the Best Result
- Keep Excel-friendly (UTF-8 BOM) on so names in Hindi, Arabic, Chinese and other languages show correctly in Excel.
- Many European Excel versions expect a semicolon separator — choose it if all data lands in one column.
- Want a real .xlsx file? Convert the CSV with CSV to Excel.
- Invalid JSON? Find the error with the JSON Validator first.
Frequently Asked Questions
Quick answers about JSON to CSV Converter.
Paste your JSON or upload a .json file. The CSV appears instantly — click Download to save it as data.csv.
With Flatten nested objects on, {"address":{"city":"Pune"}} becomes a column called address.city. Arrays are kept as JSON text in one cell.
Every key found in any object becomes a column. Rows without that key get an empty cell.
Excel needs a BOM to read UTF-8. Keep Excel-friendly (UTF-8 BOM) ticked and download the file again.
Yes. A single object becomes one row. If the object holds one list (like {"data":[...]}), that list is used.
Yes — use our CSV to JSON converter.
No. Everything runs in your web browser, so your code and data never leave your device.
Yes — 100% free, with no sign-up and no limits.
Related Free Tools
Ready to Use JSON to CSV Converter?
Scroll up and get your result in seconds. 100% free, no sign-up needed.
Start Now