JSON to CSV Converter
Convert a JSON array of objects into clean CSV with headers and proper quoting.
How to use
- Paste a JSON array of objects.
- CSV with a header row is generated instantly.
- Copy the CSV into a spreadsheet.
How the JSON to CSV Converter works
Flattens a JSON array of objects into CSV for spreadsheets, reporting tools and anything that will not take JSON.
The union of keys across the objects becomes the header row, and each object becomes a row with values placed under the matching columns. Missing keys leave empty cells.
Worked example
[{"name":"Ada","age":36}] becomes a name,age header followed by Ada,36.
Things worth knowing
- CSV is flat. Nested objects and arrays have no natural representation and must be flattened or serialized first.
- Values containing commas, quotes or newlines need quoting and escaping to stay valid.
- Everything is processed in the browser — no upload.
Frequently asked questions
What if objects have different keys?
The converter collects every key across all objects so no column is missed.
Are commas in values handled?
Yes — values with commas, quotes or newlines are wrapped in quotes correctly.
What happens to nested JSON?
It cannot be represented directly. Flatten nested fields into dotted column names before converting.
Why does Excel mangle my CSV?
Excel aggressively auto-converts things that look like dates or numbers. Import via Data → From Text rather than double-clicking the file.