JSON to CSV
Convert a list of JSON objects to CSV to open in Excel or Google Sheets, with nested objects flattened, a choice of separator and file download.
How to usePaste the JSON (a list of objects).
Available in: 
JSON to CSV: what it is for
Paste JSON with a list of objects, or an object that contains a list. The tool collects all keys as columns, flattens nested objects with names like address.city, escapes commas and quotes and generates the CSV with the chosen separator, ready to download.
The data isn't sent to any server: the conversion happens in your browser.
How to use
- Paste the JSON.
- Choose the separator.
- Copy or download the .csv file.
When to use it
- Opening API responses in Excel.
- Exporting data to spreadsheets.
- Preparing imports into other systems.
Frequently asked questions
What happens to nested objects?
They become columns with the path separated by dots, like address.city. Arrays inside objects are written as JSON in the cell.
Which separator should I use for Excel?
Excel in English usually expects commas. Excel set to many European languages expects semicolons. Use commas for Google Sheets and most systems.
Is it really free?
Yes, 100% free. No sign-up, no subscription and no usage limits. All Tools123 tools are free and run right in your browser.