Browser-Based · Instant · Free

JSON to CSV.
Flat, Clean, Instant.

Turn a JSON array into a CSV file with one row per record and one column per field. Nested objects are flattened, and the result opens correctly in Excel, Google Sheets and databases.

Convert JSON to CSV

More data converters: JSON to Excel · CSV to JSON · Excel to JSON · XML to JSON · JSON to XML · XML to Excel · YAML to JSON · JSON Formatter

How to Convert JSON to CSV

1
Paste or open the JSON

A list of objects, an API response or a JSON Lines file. Click Example to try it.

2
Pick the separator

Comma for most programs, semicolon for Excel in countries that write decimals with a comma.

3
Copy or download

Copy the CSV straight into another program, or download it as a .csv file.

Getting a CSV that opens correctly

Which separator to choose

SeparatorUse it when
CommaThe standard. Google Sheets, databases, Python, R and Excel in English-speaking countries.
SemicolonExcel in most of Europe, where the comma is the decimal mark. Double-clicking a comma CSV there puts everything in column A.
TabData that itself contains many commas and semicolons, or pasting into a spreadsheet.
  • Excel-friendly (UTF-8 BOM) adds an invisible marker at the start of the file. Without it, Excel on Windows can show letters such as š, đ or é as garbled characters. Programs other than Excel ignore it; turn it off only if a system rejects it.
  • Quoting follows the CSV standard (RFC 4180): a value that contains the separator, a quote or a line break is wrapped in quotes, and quotes inside it are doubled.
  • Nested objects become columns such as address.city. Lists of simple values go into one cell separated by commas, or into tags.1, tags.2 columns if you choose "One column per item".
  • Different fields per record are fine: every field gets a column, and records without it get an empty value.
  • Several lists in one JSON? Choose which one becomes the rows in the Rows from menu.

Going the other way? Use CSV to JSON. For a spreadsheet with real number columns, use JSON to Excel.

Frequently Asked Questions

Is the JSON sent to your server?

No. The conversion is done in your browser and the CSV is created on your device. Nothing is uploaded or stored.

Why does Excel put all my data in one column?

Your Excel expects semicolons because your region uses a comma as the decimal mark. Choose Semicolon as the separator and download again.

Why are letters like š or é broken in Excel?

Excel needs the UTF-8 marker (BOM) to read such letters correctly. Keep "Excel-friendly (UTF-8 BOM)" switched on.

Can I convert nested JSON?

Yes. Nested objects are flattened into columns with dotted names, and lists are either joined in one cell or split into numbered columns.