JSON to CSV
Convert JSON array to CSV.
Loading…
About JSON to CSV
An API response is easy to read and awkward to open in a spreadsheet. Paste a JSON array of objects and the tool builds a header row from every key it meets, in the order first seen, then writes one line per object, leaving a blank cell where an object lacks a key. Values with commas, quotes or line breaks are quoted. Nested objects and arrays are not split into extra columns; each one is written as JSON text inside its cell.
Features
- Header row built from every key across all objects
- Blank cells where an object is missing a key
- Fields with commas, quotes or line breaks are quoted
- Nested objects and arrays kept as JSON text in a single cell
- Numbers keep their exact written form, such as 1.10 or very long integers
- Text starting with =, +, - or @ gets an apostrophe in front so spreadsheets do not run it as a formula
Limitations
- The top level must be a non-empty array of objects. A single object, an array of plain values or an empty array is rejected with a message that says why.
- Nested data is not flattened into dotted column names, so a cell may hold JSON text that you parse again later.
- Fields are always separated by commas, and JSON nested more than 1,000 levels deep is refused.
- Download saves the text as output.txt and needs a free account; Copy Output does not.
How it works
- Paste a JSON array of objects into the JSON Array panel.
- Select Convert to CSV.
- Read the result in the CSV Output panel, with the header row first.
- Use Copy Output to put the CSV on your clipboard, or Download to save it as a file.
- Press Clear All to start again with new JSON.
Example input
[
{"name": "Auro", "role": "admin"},
{"name": "Nova", "role": "editor"}
]Frequently asked questions
- They stay in one cell as compact JSON text, with the quotes doubled so the CSV remains valid. If you need separate columns for inner fields, flatten the JSON before converting it.
- Strings that begin with =, +, - or @ get an apostrophe in front so a spreadsheet shows them as text instead of running them as a formula. It applies to strings only, so a text value of -5 gains one while the number -5 does not.
- The header lists every key in the order it first appears, and any object without that key gets an empty cell. A null value is also written as an empty cell, so the two cannot be told apart in the CSV.
- Not directly, because the tool expects an array at the top level. Wrap the object in square brackets to get a header row and one data row.
- No. The conversion runs in the page with your browser's JavaScript, and the page's usage events never include what you paste.