What does this tool do?
JSON to CSV converts an array of JSON objects into a CSV table you can open in any spreadsheet. It is handy for anyone exporting data to Excel, Google Sheets, or a database, letting you pick the delimiter and decide whether values are wrapped in quotes.
How to use it
- Paste or type your data into the left field.
- The result is generated instantly on the right.
- Use the Copy button to grab the output.
How columns are determined
The tool scans every object in your array and builds a unique list of all keys it finds. That means no field is dropped even when rows have different shapes; missing values are written as empty cells. This makes it reliable for inconsistent or flexible API responses where not every record carries the same properties. Column order follows the order in which each key first appears across the array.
Delimiter and quoting options
You can choose comma, semicolon, tab, or pipe as the separator. Semicolon is especially useful because many European Excel installations expect it. With quoting on, every value is wrapped in double quotes; with it off, only values containing the delimiter or a line break are quoted. Inner double quotes are escaped by doubling them, following the RFC 4180 convention so the file opens cleanly.
Frequently asked questions
What input does it expect?
A JSON array of objects, for example [{"name":"Alice"},{"name":"Bob"}]. A single object or an empty array will not produce a valid table and shows an error.
How are nested objects handled?
Nested objects and arrays are written into the cell as their raw JSON text. If you need a flat table, flatten your data before converting.
Which delimiter should I use for Excel?
Comma works in most cases, but if Excel splits everything into one column, switch to semicolon, which matches the list separator used in many regional Excel settings.
Is JSON to CSV free?
Yes. JSON to CSV and all 300+ tools on MagmaNex are completely free with no signup or account required.
Is my data safe?
Yes. Everything runs locally in your browser. The data you enter is never sent to a server, stored, or shared.
Does it work on mobile?
Yes. JSON to CSV works on phones, tablets and desktops — no app download needed.
🔒 Privacy: everything runs in your browser, your data is never sent to a server.