Paste JSON from an API response, database export or log file and get a CSV you can open in Excel, Google Sheets or Numbers. Every key found in any object becomes a column, so records with missing fields still line up correctly. Nested objects are flattened into dotted column names such as address.city, and arrays are written as JSON text inside one cell.
Values containing commas, quotes or line breaks are quoted and escaped according to the CSV standard, and the downloaded file includes a UTF-8 byte-order mark so Excel shows accented and non-Latin characters properly. The conversion happens entirely in your browser.
How to use the JSON to CSV tool
- Paste a JSON array into the input, or open a .json file.
- Pick a delimiter: comma for most tools, semicolon for European Excel.
- Choose whether to include a header row and flatten nested objects.
- Check the table preview, then Copy or Download .csv.
Why use ToolOrca JSON to CSV
- Collects every key as a column
- Flattens nested objects (a.b.c)
- Correct CSV quoting and escaping
- Comma, semicolon, tab or pipe delimiter
- Excel-friendly UTF-8 download
- Also accepts {"data": [...]} wrappers
What JSON shapes can be converted?
The best input is an array of flat or nested objects: [{"id":1,"name":"A"}, …]. An array of arrays is written row by row without a header. If you paste an object that contains an array — a common API shape like {"results": [ … ]} — the first array is used. A single object becomes one row.
CSV is a flat format, so deeply nested data with arrays of objects cannot be represented perfectly. In that case arrays are kept as JSON strings in their cell, so no information is lost and you can still parse them later.
Frequently asked questions
How do I open the CSV in Excel with the right characters?
Use Download .csv: the file starts with a UTF-8 marker that tells Excel the encoding. If your Excel expects semicolons, choose the semicolon delimiter before downloading.
What happens to nested objects?
With Flatten nested objects on, {"user":{"name":"Ann"}} becomes a column called user.name. With it off, the whole object is written as JSON text in one cell.
Why do some cells contain JSON like [1,2]?
Arrays cannot be split into a fixed number of columns, so they are stored as JSON text in a single cell.
Is my data uploaded?
No. Parsing and conversion run in your browser. Nothing is sent to a server.