JSON to CSV
Paste a JSON array of objects to convert it into CSV. Columns are taken from the union of all keys, fields with commas or quotes are escaped, and you can download the result - all locally.
Loading…
About the JSON to CSV converter
This tool turns a JSON array of objects into comma-separated values you can open in a spreadsheet. It builds the header row from the union of every key found across all objects, so even rows with missing fields line up under the right columns. Values containing a comma, double quote, or line break are wrapped in quotes and escaped, producing CSV that imports cleanly into Excel, Google Sheets, or a database loader.
How to use it
- Paste a JSON array of objects, like
[{"name":"Ada"},{"name":"Linus"}]. - The CSV output is generated automatically.
- Review the header row and rows in the preview.
- Download the CSV or copy it into your spreadsheet.
A frequent use case is exporting an API result into a sheet for reporting. Note that nested objects and arrays are not flattened into separate columns - keep your input one level deep, or pre-process nested values into strings first. Conversion happens entirely in your browser, so your data is never uploaded.
Frequently asked questions
How are CSV columns chosen?
The converter collects every key that appears in any object and uses the union as the header row. Objects missing a key simply leave that cell empty, so all rows stay aligned.
How are commas and quotes inside values handled?
Any field containing a comma, double quote, or line break is wrapped in double quotes, and embedded quotes are doubled, following standard CSV escaping rules so the file parses correctly.
Does it handle nested objects or arrays?
Not automatically. CSV is a flat format, so keep your input to a single level of keys. Flatten or stringify nested values before converting if you need them in columns.
Is my JSON uploaded during conversion?
No. The entire JSON to CSV conversion runs in your browser, so your data stays on your device.