JSON to CSV Converter

JSON to CSV Converter

Updated August 20, 2026

Convert JSON to CSV online. Download a CSV you can open in Excel. Free JSON to CSV converter in your browser.

Delimiter

JSON array

CSV

Features

  • JSON to CSV converter online, free in your browser
  • Turn a JSON array of objects into a CSV you can open in Excel
  • Union of all keys becomes the header, so sparse objects still align
  • Choose comma, semicolon, tab, or pipe
  • Download a .csv file
  • Nested objects are stored as JSON text in the cell. Nothing is uploaded

Common Use Cases

  • Convert JSON to CSV for Excel or Google Sheets
  • Export an API response to a spreadsheet
  • Give a teammate a CSV from a JSON dump
  • Produce semicolon CSV for locales that use comma as decimal
  • Round-trip after CSV to JSON

How to convert JSON to CSV (and Excel)

A JSON to CSV converter walks every object and collects keys in first-seen order. Missing keys become empty cells. Paste a JSON array, pick a delimiter, download CSV, and open it in Excel.

A JSON object that is not an array is rejected because CSV needs a list of rows. Nested objects are stringified into one cell. Flatten first if you need nested fields as columns.

Examples

Valid - Array of objects
[{"id":1,"name":"Ada"}]
Valid - Sparse keys
[{"a":1},{"b":2}]
Invalid - Not an array
{"id":1}

Frequently Asked Questions

How do I convert JSON to CSV for Excel?

Paste a JSON array of objects, pick comma or semicolon, and download the CSV. Excel and Google Sheets open it as a table.

Will nested JSON become extra columns?

No. Nested objects and arrays are stringified in one cell. Flatten first if you need nested fields as columns.

Why UTF-8 without BOM?

It is the web default. Excel on Windows sometimes wants a BOM for umlauts. Add one in an editor if a column looks mojibake.

Related Tools

CSV to JSON

Convert back

Try it

JSON → Table

View JSON as a table

Try it

CSV to SQL

Emit INSERT statements

Try it

Tips

  • If the JSON is an object with a "data" array, extract that array first.
  • Pick semicolon when the consumer is Excel in a comma-decimal locale.