JSON to CSV Converter is a free tool that turns a JSON array into a CSV file you can open in Excel, Google Sheets or Numbers. Nested objects are flattened into columns, every key becomes a column, and values that could run as spreadsheet formulas are neutralised. The conversion runs in your browser.
How to convert JSON to CSV
- Paste a JSON array of objects, or an API response that contains one.
- The CSV appears on the right, with the number of rows and columns.
- Download
data.csvand open it in your spreadsheet app.
How the data is arranged
- Each object becomes a row, and every key found in any object becomes a column.
- Nested objects become dotted column names:
address.city,address.zip. - Arrays are written as JSON text in a single cell, e.g.
["vip","beta"]. - If the JSON is an object with an array inside, such as
dataoritemsfrom an API, that array is used.
Opening the file in Excel
The CSV uses commas by default. If Excel puts everything in one column, your region probably uses semicolons: choose Semicolon as the separator and download again. Characters such as é and emoji are saved as UTF-8; if they look wrong, use Excel’s Data → From Text/CSV import and pick UTF-8.
Formula injection protection
A cell that starts with =, +, - or @ can be run as a formula when the file is opened, which attackers use to hide malicious commands in exported data. Such values are prefixed with an apostrophe, so spreadsheets show them as plain text.
If the JSON won’t convert, the JSON Validator shows exactly where it is broken. To turn a spreadsheet export back into JSON, use CSV to JSON.
Frequently asked questions
How are nested objects handled?
They are flattened into columns with dotted names: {"address":{"city":"Paris"}} becomes a column called address.city. Arrays are written as JSON text in a single cell.
My JSON is an object, not an array.
If the object contains an array, such as {"data":[…]} from an API, that array is used. Otherwise the object becomes a single row.
What is formula injection protection?
Values starting with =, +, - or @ could run as formulas when the CSV is opened in Excel. They are prefixed with an apostrophe so they are shown as text.
What if objects have different keys?
Every key found in any object becomes a column; objects without that key get an empty cell.
Last updated