JSON to CSV Converter
Convert a JSON array into CSV, flattening nested objects into dotted columns and quoting values correctly.
Turn a JSON array into a spreadsheet, flattening nested objects into their own columns.
Table
Rows
2
Columns
4
| id | name | address.city | tags |
|---|---|---|---|
| 1 | Ada | London | admin; dev |
| 2 | Grace | New York | ops |
id,name,address.city,tags
1,Ada,London,admin; dev
2,Grace,New York,opsAbout the json to csv converter
Getting JSON into a spreadsheet is easy until the data has any depth. A nested address object has to become columns, and an array of tags has to become something a single cell can hold. Handled badly, you get one column of raw JSON that nobody can filter on.
This flattens nested objects into dotted column names, joins arrays of simple values into one cell, and quotes anything containing a comma, a quote or a newline, which is what the CSV format actually requires.
How to use it
- 1Paste a JSON array.
- 2Pick the delimiter your spreadsheet expects.
- 3Leave flattening on unless you want raw nested values.
- 4Check the table preview, then copy the CSV.
Questions
What happens to nested objects?
They become dotted columns, so address.city is its own column. That is what makes the result filterable and sortable in a spreadsheet.
What happens to arrays?
An array of simple values is joined into one cell with semicolons. An array of objects is expanded into indexed columns, which can get wide.
Which delimiter should I use?
Comma is standard. Use semicolon if your spreadsheet is set to a locale where the comma is the decimal separator, which is common across Europe.
Is my data uploaded?
No. Conversion happens entirely in your browser.