JSON to CSV — Free, Private

What is the JSON to CSV Converter?

JSON is the language of APIs, but spreadsheets speak CSV. Whenever you need to open API data in Excel or Google Sheets — or hand a dataset to someone who lives in spreadsheets — you need a JSON to CSV converter. This free tool takes a JSON array of objects and turns it into clean, properly quoted CSV you can download and open anywhere.

Paste your JSON and press Convert. Nested objects are automatically flattened with dot notation, so {"address": {"city": "London"}} becomes a tidy address.city column instead of breaking the table. Arrays are joined with semicolons into a single readable cell, every field is quoted to CSV standards, and the first row carries your column headers.

The converter handles real-world messiness gracefully. Objects with different keys across rows are merged into one consistent column set, with blanks where a row lacks a field. Quotes inside your data are escaped correctly, a BOM is added on download so Excel opens the file with the right encoding, and clear error messages tell you exactly what is wrong if your JSON will not parse.

Your data never leaves the page. Conversion runs entirely in your browser with no uploads, which matters when the JSON contains customer records, internal IDs or anything else you would not paste into a random server. No signup, no row limits to worry about for normal use, and the file is yours the moment you download it.

Once your CSV is downloaded, a few spreadsheet tricks unlock its full value. In Excel, use Data > From Text/CSV on re-import to control column types explicitly — this stops Excel from mangling IDs with leading zeros or turning long numbers into scientific notation. In Google Sheets, IMPORTDATA can pull a hosted CSV straight into a live sheet, handy for dashboards that refresh. If your flattened data has many dot-notation columns, consider splitting them with Text to Columns or restructuring with a pivot table to summarise by category. For recurring conversions, save the workflow: bookmark this tool and keep a template spreadsheet with your preferred formatting, so each new export is a two-minute job rather than a fresh project. And when a dataset grows beyond comfortable spreadsheet size — hundreds of thousands of rows — that is the signal to move analysis into a database or a Python notebook instead of forcing Excel to cope. With clean CSV in hand, your data is ready for spreadsheets, reports and sharing in minutes.

How to use it

1. Paste your JSON — Paste a JSON array of objects — e.g. [{"name":"Ava"},{"name":"Ben"}]. A single object works too.
2. Press Convert to CSV — The tool validates the JSON, flattens nested objects with dot notation, and builds the CSV with quoted fields.
3. Review the preview — Check the output: the first row is your headers, nested fields appear as parent.child columns, arrays are joined with "; ".
4. Copy or download — Copy the CSV to your clipboard or download it as a .csv file that opens directly in Excel and Google Sheets.
5. Fix errors if any — If the JSON is invalid or a row is not an object, the error message tells you exactly what to fix.

Common use cases

• Opening API responses in Excel or Google Sheets
• Preparing data exports for colleagues who work in spreadsheets
• Converting config-like JSON into tabular form for analysis
• Migrating records between systems that only accept CSV imports
• Quickly inspecting nested JSON as a flat, readable table

Tips

• Validate your JSON first with a formatter if the converter reports a parse error.
• Deeply nested structures flatten best when they are consistent across rows.
• Remember arrays become one cell joined with "; " — split them in your spreadsheet if needed.
• Open the downloaded file in a spreadsheet app rather than a text editor to see the real table.
• For CSV back to JSON, use the companion CSV to JSON converter.

Frequently asked questions

Related tools