JSON to CSV Converter
Paste a JSON array and get a spreadsheet-ready table: preview the rows, download a CSV that opens cleanly in Excel, or copy the data straight into Sheets.
From JSON to a spreadsheet in one paste
APIs, log exports, and AI answers all speak JSON, but the people you report to live in Excel. This converter reads a JSON array of objects, works out the full set of columns across every record, and lays the data out as rows you can actually use.
Nested data is handled properly
Real-world JSON nests objects inside objects. With flattening on, a field like stock: { warehouse: 320 } becomes its own stock.warehouse column instead of an unreadable blob. Arrays of plain values are joined with semicolons, and records with different fields still line up, with blanks where a field is missing.
Input shapes that work
- An array of objects, the common API response shape.
- A single object, converted as one row.
- A wrapper object whose data lives in one array field, detected automatically.
- An array of arrays, treated as ready-made rows.
The CSV download starts with a byte order mark so Excel opens accented and non-Latin characters correctly. Parsing runs in your browser, which matters when the JSON contains customer data.
Frequently asked questions
My JSON will not parse. What is usually wrong?
The most common causes are trailing commas, single quotes instead of double quotes, and unquoted keys. If the JSON came from an AI chat, make sure you copied only the code block, without surrounding prose.
How are nested objects converted?
With flattening on, nested fields become dot-notation columns such as address.city. With it off, nested structures are kept as compact JSON strings in a single cell.
What if records have different fields?
The converter takes the union of all fields across records as the column set. Records that lack a field simply get an empty cell.
Can I get the data into Excel without a file?
Yes. Copy for Excel / Sheets puts tab-separated values on your clipboard. Click a cell in the spreadsheet and paste, and each value lands in its own cell.
Is my JSON uploaded?
No. Parsing and conversion run in your browser and the data never leaves your device.
More tools
AI Text Cleaner
Remove em dashes, curly quotes, Markdown symbols, and hidden characters from ChatGPT and other AI text.
Invisible Character Remover
Detect and delete zero-width spaces, non-breaking spaces, and other hidden Unicode characters.
Markdown to Word Converter
Turn ChatGPT Markdown into a formatted Word document, or copy it straight into Word and Google Docs.
Markdown Table to Excel
Extract Markdown tables and export them as CSV, or copy them straight into Excel and Google Sheets.