JSON will not parse
Invalid JSON, trailing commas, or a single primitive value cannot become useful table rows.
Open the source in a plain-text or spreadsheet view, fix the malformed row or bracket, then rerun the conversion before downloading CSV.
Use this tool
Prepare the input and run the tool
Paste a JSON object or array. Result: Copy or download CSV.
Paste a JSON object or array. Nested arrays and objects are kept as JSON strings inside CSV cells.
Ready.
JSON to CSV output preview appears here.
Data handling: Files and pasted data are processed in this browser session.
Tool guide
How to use JSON to CSV
Use this when API data needs to be opened in a spreadsheet. Arrays and nested objects stay inside CSV cells as JSON text.
What this tool does
Paste JSON and download a CSV with object keys turned into column headers.
- Input
- Paste a JSON object or array
- Output
- Copy or download CSV
Tool advantages
- Runs in this page; the file or pasted data is not sent to a new app.
- Keeps the preview, report, and download in the same screen.
- Leaves you with an output you can copy, download, or check before using.
Step-by-step usage guide
- 1Paste valid JSON.
- 2Review the CSV headers.
- 3Copy or download the CSV.
Common errors and fixes
CSV structure looks wrong
Nested objects and arrays stay inside cells as JSON text, so flatten fields first if the spreadsheet needs separate columns.
Check the header row, repeated records, and nested fields in the preview. Rename unclear columns before using the converted file downstream.
CSV download is not accepted by another app
Some spreadsheet apps may auto-format IDs, dates, or long numbers after opening the CSV.
Download again after checking the preview, then test the file in the destination app with a small sample before converting the full export.
When to use JSON to CSV
- You are checking files before an upload, import, share, or delivery.
- You want to confirm the result before sending it to another system.
- You need a copied result, downloaded file, or report that can be reviewed outside the page.
FAQ
What JSON shape works best?
Use an array of objects with consistent keys, such as API export rows.
Will nested objects be flattened?
Nested arrays and objects are kept as JSON strings so each row stays valid in a spreadsheet.