About the JSON to CSV Converter
JSON is how most APIs and apps send data, but spreadsheets and databases want rows and columns. This converter turns a JSON array of objects into CSV that opens in Excel, Google Sheets or any import tool. Each object becomes a row, and the field names become the header row. Nested objects can be flattened into dotted column names such as address.city, arrays inside a field are kept as JSON text, and values with commas, quotes or line breaks are quoted correctly. You can choose a comma, semicolon, tab or pipe as the separator and download the result as a .csv file.
Updated October 2026
How to use the JSON to CSV Converter
- 1Paste your JSON into the left box.
- 2Choose the separator your spreadsheet expects.
- 3Decide whether to include a header row and to flatten nested objects.
- 4Check the CSV preview and the row and column counts.
- 5Copy the CSV or download it as data.csv.
Preparing your JSON
The tool needs valid JSON: double quotes around keys and strings, no trailing commas and no comments. If you get an error, the message points to the problem. A common source of trouble is copying a JavaScript object with single quotes, which is not valid JSON. The JSON Formatter on this site can validate and tidy your data before you convert it.
For very large files, note that everything happens in your browser, so the practical limit is your device's memory. A phone may struggle with tens of megabytes of JSON, whereas a laptop handles it comfortably. If the conversion is slow, split the data into smaller arrays first. Check the result against a few rows of the original, especially dates, long numbers and values with leading zeros, which spreadsheets sometimes reformat when opening a CSV.
Choosing options
- Use a comma for most tools and Google Sheets.
- Use a semicolon where decimal commas are common, for example in many European locales.
- Use a tab for pasting directly into a spreadsheet.
- Keep the header row on unless you are appending to an existing file.
- Turn flattening off when you want nested data kept intact in one cell.
Other data tools
The CSV to JSON converter goes the other way, the Data Format Converter handles JSON, XML and other formats and the CSV Tools clean and edit CSV files. For checking structure, try the JSON Formatter and the Diff Checker. The Excel to PDF tool is useful once your data is in a sheet.
Features
- Arrays of objects, single objects and arrays of arrays
- Nested objects flattened to dotted columns
- Correct quoting of commas, quotes and line breaks
- Comma, semicolon, tab or pipe separator
- Header row on or off
- Copy and download
Frequently asked questions
How do I convert JSON to CSV?
Paste a JSON array of objects, such as [{"name":"A"},{"name":"B"}]. The tool collects every field name as a column, writes one row per object and shows the CSV, which you can copy or download.
What happens with nested objects?
With flattening on, a nested object becomes extra columns named by path, so {"address":{"city":"Pune"}} gives a column called address.city. With it off, the nested object is placed in one cell as JSON text.
What happens with arrays inside a field?
They are written into the cell as JSON text, for example [1,2,3], because a single cell can't hold a list. You can split such columns in a spreadsheet afterwards.
How does it deal with missing fields?
If some objects lack a field that others have, the column is still created and the cell is left empty for those rows. Columns appear in the order they are first found.
Why do some cells have quotes around them?
CSV requires quotes around values that contain the separator, a double quote or a line break. A double quote inside a value is written as two double quotes. This is the standard that Excel and other tools expect.
Will it open correctly in Excel?
Usually yes. In regions where Excel expects a semicolon as a separator, choose the semicolon option. Excel can misread values that start with = + - or @ as formulas, so check data from untrusted sources before opening it.