Skip to content
WeDoConvert

JSON to CSV Converter

Paste a JSON array and get a CSV table you can open in a spreadsheet. Choose comma, semicolon or tab as delimiter.

0 characters

0 characters

Processed locallyFiles and text are processed in your browser and are not uploaded to our servers.Learn more

Need the opposite? CSV to JSON

How to convert JSON to CSV

  1. 01

    Paste your JSON

    Use an array of objects, such as API results, or an array of arrays.

  2. 02

    Choose delimiter and header

    Comma, semicolon or tab, with or without a header row of column names.

  3. 03

    Convert and download

    Copy the CSV or download it as a .csv file.

How columns are built

  • Columns follow the order in which keys first appear. A key that only shows up in a later object still gets its own column.
  • Missing keys and null values become empty cells.
  • Nested objects and arrays are written as compact JSON text in a single cell; they are not flattened into extra columns.
  • An array of arrays is written row by row, without an invented header.

CSV quoting and line endings

Fields that contain the delimiter, a double quote or a line break are wrapped in quotes, and quotes inside are doubled. Rows end with CRLF line breaks, which Excel and most CSV readers expect.

Quoting does not stop a spreadsheet from interpreting a cell as a formula. Review untrusted values beginning with =, +, - or @ before opening the CSV in a spreadsheet.

Related tools

Frequently asked questions

What JSON structure can be converted?

A top-level array whose items are all objects, or all arrays. A single object, or an array mixing objects and plain values, is reported with an explanation.

How are nested objects handled?

They are kept as JSON text inside one cell, for example {"city":"Utrecht"}. Nothing is lost, but the structure is not spread across columns.

Which delimiter should I use for Excel?

Comma works in most English-language setups. If Excel puts everything in one column, choose Semicolon.

Can I convert CSV back to JSON?

Yes. Switch Mode to CSV to JSON, or open the CSV to JSON page.