Quick access

Saved in this browser. Sign in to keep it on all your devices.

JSON to CSV Converter

Convert JSON arrays to CSV format instantly.

JSON Input
CSV Output
Rows: Columns:

Examples

Version 1.1 Updated What's new

Release notes

  1. v1.1 Latest
    • Added an in-depth guide below the tool, written from what the tool actually does.
    • Nested fields are flattened into columns, and values with commas or quotes are escaped correctly.

About the JSON to CSV Converter

The JSON to CSV converter turns a list of JSON objects into a table: each object becomes a row and each key becomes a column, ready for Excel or Google Sheets.

How to use it

  1. 1 Paste a JSON array of objects.
  2. 2 Convert it to CSV.
  3. 3 Copy the CSV or download it as a file.

Frequently asked questions

What JSON shape works best?

An array of objects with similar keys, like [{"name":"Ann","age":30},{"name":"Bo","age":25}]. Each object becomes one row.

How are nested objects handled?

Nested fields are flattened into column names such as address.city, so the data still fits in a flat table.

Can I open the CSV in Excel?

Yes. Open or import the downloaded file in Excel, Google Sheets, or Numbers.

How a tree becomes a table

JSON can nest without limit while CSV is flat, so something has to give. Nested objects become dotted column names, and arrays are squeezed into a single cell:

{"id":1,"address":{"city":"Boston"},"tags":["a","b"]}

id,address.city,tags
1,Boston,a; b

A simple array is joined with a semicolon and a space. An array that holds objects is kept as a JSON string in its cell, because splitting it would need extra rows, and that would duplicate the parent’s data.

Records with different keys

Real data is rarely uniform. Columns are the union of every key found across all records, in the order they first appear, and a record without one of those keys gets an empty cell. An empty cell therefore has two possible meanings: the key was missing, or its value was null. If that distinction matters, keep the JSON as your source of truth.

Quoting rules

The output follows RFC 4180. A value is wrapped in double quotes if it contains a comma, a double quote or a line break, and any double quote inside it is doubled. So say "hi" is written as """hi""" with an extra pair around the word, and lines end with CRLF as the standard specifies.

Opening the result in Excel

The Download button adds a UTF-8 byte order mark so Excel displays accented letters and non-Latin scripts correctly. Text copied from the box has no such marker. Regions that use a comma as the decimal point often expect semicolons between columns, in which case use Data > From Text/CSV and pick the comma delimiter.

Excel also rewrites some values on opening. Long ID numbers lose digits past the fifteenth, leading zeros vanish from ZIP codes and phone numbers, and strings like 3-4 may turn into dates. Importing those columns as Text avoids it.

Treat exported data from strangers with care. A cell beginning with =, +, - or @ can run as a formula in a spreadsheet, an attack known as CSV injection. This converter leaves values unchanged so numbers such as -5 stay correct.