From JSON to a table
Many APIs and exports return data as JSON: an array of objects, one per record. To analyze it in a spreadsheet you need a table, and that's what this tool produces: one row per object and one column per key.
If objects contain other objects, they're flattened with a dot: {"address": {"city": "London"}} becomes the column “address.city”. Arrays are written as JSON inside the cell. If each object has different keys, a column is created for every key that appears, and missing cells are left empty.
You can choose the delimiter. Excel in English expects commas, while Excel in Spanish, French, German, Italian or Portuguese expects semicolons. The “Excel compatible” option adds a UTF-8 marker so accented characters display correctly when you open the file.
How to convert JSON to CSV
- Paste the JSON or open a .json file. Ideally it's an array of objects: [{...}, {...}].
- Pick the delimiter: comma, semicolon, tab or pipe.
- Leave “Flatten nested objects” on if your data has objects inside objects.
- Click “Convert to CSV” and download the .csv file to open it in Excel.
When to use it
- Opening a JSON export from an online store, a CRM or a database in Excel.
- Moving an API response into Google Sheets to build charts.
- Handing data to someone who doesn't work with JSON.
- Importing records into a tool that only accepts CSV.
Frequently Asked Questions
What JSON structure do I need?
An array of objects works best. It also works with a single object (one row), an array of values (one “value” column) and API responses like {"data": [...], "total": 10}: the array of objects inside is used.
What happens to nested objects?
With “Flatten nested objects” on, each nested value gets its own column named with its dot-separated path (address.city). If you turn it off, the whole object is written as JSON in a single cell.
Why does Excel show everything in one column?
Because the delimiter doesn't match the one your Excel expects. Excel set to English uses commas, while in many European locales (Spanish, French, German, Italian, Portuguese) it uses semicolons. Change the delimiter and convert again.
Is my data sent to a server?
No. Everything is processed in your browser with JavaScript. The text you paste and the files you open never leave your device, so you can safely work with internal or customer data.
Can I convert several files at once?
Yes, with ToolStudio Pro: open several JSON files, they're converted with the same options and you download all the CSVs in one ZIP. The free try covers one document.
Is it free?
Yes. You can try the tool for free on one document (pasted or a single file) and change the options as often as you like; attempts that end in an error don't use up your free try. For unlimited use and processing several files at once, ToolStudio Pro costs €1.99 a month and includes every tool.
