Convert JSON to CSV

How to use JSON to CSV

1. Paste JSON (an array of objects) or upload a .json file.
2. Pick a delimiter and whether to flatten nested objects.
3. Copy the CSV or press “Download CSV”.

Why convert JSON to CSV?

JSON is how applications exchange data, but analysts, accountants and most business users work in spreadsheets. CSV (comma-separated values) is the simplest bridge: every spreadsheet program, from Excel to Google Sheets to LibreOffice, can open it, and so can databases and data-analysis tools.

Typical cases include exporting an API response to inspect it in Excel, turning a database dump into a report, preparing data for a mail merge, or importing records into a system that accepts only CSV.

How the conversion works

CSV is a flat table of rows and columns, while JSON can nest objects inside objects. The converter therefore reads your array of objects, collects every key it finds as a column header, and writes one row per object.

• Nested objects are flattened using dotted names. {"address":{"city":"Pune"}} becomes a column called address.city.
• Arrays are written into the cell as JSON text, so no data is lost.
• If objects have different keys, the columns are the union of all keys and missing values are left empty.
• Values containing commas, quotes or line breaks are wrapped in quotes and escaped following the RFC 4180 rules, so they open correctly.

Making Excel open the file correctly

Excel guesses the file encoding, and often reads UTF-8 files as legacy Windows text, which garbles accented letters and non-Latin scripts. Keep “Add UTF-8 BOM” ticked to fix this. In some regions, Excel expects semicolons rather than commas as the separator because the comma is the decimal mark; if all your data appears in one column, choose the semicolon delimiter and convert again.

Tips

• The input should be an array of objects, such as [{...},{...}]. If your data is wrapped, for example {"results":[...]}, paste only the inner array.
• Check the preview table before downloading to confirm the columns are what you expect.
• Long numbers such as IDs may be shown in scientific notation by Excel. Format the column as text before importing if you need to preserve them.
• Your data stays in your browser. Nothing is uploaded.

Why use this json to csv tool

• Flattens nested JSON. Objects like {"a":{"b":1}} become an a.b column.
• Any delimiter. Comma, semicolon, tab or pipe.
• Excel friendly. Correct quoting and optional UTF-8 BOM so accents display properly.
• Live preview. See the table before you download.

Frequently asked questions

More free tools