JSON to CSV
Convert a JSON array of objects into CSV that opens cleanly in Excel or Google Sheets. It flattens structured data into rows and columns for reporting and analysis.
From nested data to a flat grid
JSON is hierarchical and CSV is a flat grid, so converting means flattening. An array of objects maps neatly: each object becomes a row, and the object keys become the column headers. The challenge is nested objects and arrays, which have no natural place in a single cell and must be flattened, joined, or dropped.
This conversion is what gets API data into a spreadsheet, where non-technical colleagues can sort, filter, and chart it.
Getting a clean spreadsheet
Plan for the parts that do not map cleanly.
- Flatten or stringify nested objects before converting, or decide which fields to keep.
- Make sure objects share the same keys so columns line up.
- Open the result in a spreadsheet to confirm commas inside values were quoted correctly.
Explore more free tools
Keep your workflow moving with other Utility Hub tools that pair well with JSON to CSV. Jump straight into another task without leaving the site.
FAQs
How does nested JSON become CSV?▼
CSV is flat, so nested objects and arrays must be flattened, joined into a single cell, or omitted. Simple arrays of flat objects convert cleanly; deeply nested data needs flattening first.
Where do the column headers come from?▼
From the keys of the objects. For consistent columns, the objects should share the same set of keys; missing keys leave empty cells.
Is my data uploaded?▼
No. Conversion runs in your browser, so the data stays local.
What happens to values that contain commas?▼
They are wrapped in quotes so they stay in one cell rather than splitting into extra columns. This is standard CSV escaping.
Will it open correctly in Excel?▼
Yes, CSV opens in Excel and Google Sheets. If you see odd characters, the file may need UTF-8 handling, which most modern spreadsheets manage automatically.
What if my objects have different keys?▼
The CSV will include all keys as columns, leaving blanks where an object lacks a key. Normalizing the data first gives the cleanest table.
How are nested arrays handled?▼
An array inside a field cannot fit a single cell naturally. It is typically joined into a delimited string or flattened, depending on the tool, so check the output.
Can I convert CSV back to JSON?▼
Yes, with the CSV to JSON tool. Note the round trip may not perfectly restore nested structure, since CSV cannot represent it.
Does the key order set the column order?▼
Generally the first object's keys define the column order. If order matters, ensure your objects list keys consistently.
More tools from Conversion
Continue with related utilities when this task is part of a bigger workflow.