About this tool
CSV is a flat table format, so nested JSON is flattened: {"address":{"city":"Jaipur"}} becomes a column named address.city. Values containing commas, quotes or line breaks are quoted following standard CSV rules.
How JSON is converted to CSV
CSV is a flat table, so each object in your array becomes a row and each key becomes a column. Nested objects are flattened using dots, so address.city becomes its own column.
[{"id":1,"address":{"city":"Jaipur"}}]
id,address.city
1,JaipurOpen the CSV in Excel or Google Sheets
Download the result and open it in Excel with Data, then From Text/CSV, or import it in Google Sheets with File, then Import. Excel may reformat very long numbers or drop leading zeros, so import those columns as text if it matters.
Things to know
Arrays inside a row are kept as JSON text in a single cell. If objects have different keys, the CSV includes every key and leaves missing values empty. Values with commas, quotes or line breaks are quoted automatically.
How to use it
- Paste a JSON array of objects, such as a list of users or orders.
- Columns are built from every key found in the data.
- Copy the CSV or download it and open it in a spreadsheet.
Frequently asked questions
How are nested objects handled?
They are flattened with dots. Arrays inside a row are kept as a JSON string in a single cell.
What if objects have different keys?
The CSV includes every key found. Rows missing a key get an empty cell.
Does it handle commas and quotes?
Yes, they are escaped automatically.