About JSON to CSV
The JSON to CSV converter flattens a JSON array into spreadsheet-ready CSV. Column headers are detected automatically across all objects — even when some objects are missing keys — and values containing commas, quotes or line breaks are quoted correctly so the file opens cleanly in Excel and Google Sheets.
It accepts both an array of objects (keys become the header row) and an array of arrays (rows as-is), and you can choose comma, semicolon or tab as the delimiter. Nested objects are serialized as JSON strings so no data is silently lost.
How to Use the JSON to CSV
- Paste a JSON array, e.g. [{"name": "Ada", "age": 36}].
- Choose a delimiter if you need semicolons or tabs.
- Copy the CSV and paste it into your spreadsheet, or save it as a .csv file.
Features
- Automatic column detection across all objects
- Proper quoting for commas, quotes and newlines in values
- Array-of-objects and array-of-arrays input
- Comma, semicolon and tab output
Frequently Asked Questions
What happens to nested objects?
They're embedded as JSON strings in the cell, so no data is lost. For fully flat output, flatten the structure before converting.
How do I open the result in Excel?
Copy the output into a file saved as .csv and open it, or paste directly into a sheet and use the text-to-columns feature. Use the semicolon delimiter if your locale expects it.
Is the JSON to CSV converter free?
Yes, the JSON to CSV converter is completely free with no usage limits. No signup, no account and no installation required.
Is my data safe?
Yes. All processing happens locally in your browser using JavaScript — nothing you type is uploaded or stored on our servers.
Related Tools
CSV to JSON
Convert CSV data to JSON online with header detection, custom delimiters and quoted-field support. Fast, free and private.
JSON Formatter
Format, validate and beautify JSON online. Free JSON formatter with indentation options and key sorting — runs entirely in your browser.
Word Counter
Count words, characters, sentences and paragraphs in real time. Free online word counter for essays, tweets and SEO content.