What JSON structure can be converted to CSV?

An array of objects works best: each object becomes a row and each key a column. A single object becomes one row, and an array of plain values becomes a single “value” column.

What happens to nested objects and arrays?

With Flatten nested objects on, nested objects become columns like address.city. Arrays are written as JSON text in one cell, so no data is lost.

Will Excel open the CSV correctly?

Yes. Values with commas, quotes or line breaks are quoted as the CSV standard requires. If your Excel uses semicolons (common in Europe), choose the semicolon delimiter.

What does “Protect against Excel formulas” do?

It prefixes values starting with =, +, - or @ with an apostrophe, so spreadsheets show them as text instead of running them as formulas — a safeguard when data comes from untrusted sources.

JSON to CSV Converter

Turn a JSON array into a CSV table you can open in Excel or Google Sheets.

JSON input

[
  {
    "id": 1,
    "name": "Ada Lovelace",
    "email": "ada@example.com",
    "address": { "city": "London", "country": "UK" },
    "skills": ["math", "programming"],
    "active": true
  },
  {
    "id": 2,
    "name": "Grace Hopper",
    "email": "grace@example.com",
    "address": { "city": "New York", "country": "US" },
    "skills": ["compilers"],
    "active": false,
    "note": "Said \"It's easier to ask forgiveness\", then left."
  }
]

CSV output

CodeTable

id,name,email,address.city,address.country,skills,active,note
1,Ada Lovelace,ada@example.com,London,UK,"[""math"",""programming""]",true,
2,Grace Hopper,grace@example.com,New York,US,"[""compilers""]",false,"Said ""It's easier to ask forgiveness"", then left."

id,name,email,address.city,address.country,skills,active,note
1,Ada Lovelace,ada@example.com,London,UK,"[""math"",""programming""]",true,
2,Grace Hopper,grace@example.com,New York,US,"[""compilers""]",false,"Said ""It's easier to ask forgiveness"", then left."

How to convert JSON to CSV

Paste a JSON array on the left, or open or drop a .json file.
The CSV appears on the right. Switch to Table to preview it as rows and columns.
Pick the delimiter your spreadsheet expects and whether nested objects are flattened.
Download the .csv file and open it in Excel, Google Sheets or Numbers.

How JSON becomes a table

Each object in the array becomes a row, and every key that appears in any object becomes a column — so objects with missing or extra fields still line up. Nested objects are flattened into dotted column names.

JSON

[
  {"id": 1, "user": {"name": "Ada", "city": "London"}},
  {"id": 2, "user": {"name": "Linus"}, "admin": true}
]

CSV

id,user.name,user.city,admin
1,Ada,London,
2,Linus,,true

Features

Correct CSV quoting for commas, quotes and line breaks inside values.
Comma, semicolon, tab or pipe delimiters.
Exact numbers: long IDs aren't rounded or turned into scientific notation.
Optional protection against spreadsheet formula injection.

Use cases

Open API results in a spreadsheet to filter, sort and chart them.
Hand data exports to colleagues who work in Excel.
Import JSON data into tools that only accept CSV.

Related tools

Going the other way? Use CSV to JSON. If the JSON doesn't parse, check it with the JSON validator, or inspect it first with the JSON formatter. Other conversions: JSON to XML and JSON to YAML.

Frequently asked questions

What JSON structure can be converted to CSV?: An array of objects works best: each object becomes a row and each key a column. A single object becomes one row, and an array of plain values becomes a single “value” column.
What happens to nested objects and arrays?: With Flatten nested objects on, nested objects become columns like address.city. Arrays are written as JSON text in one cell, so no data is lost.
Will Excel open the CSV correctly?: Yes. Values with commas, quotes or line breaks are quoted as the CSV standard requires. If your Excel uses semicolons (common in Europe), choose the semicolon delimiter.
What does “Protect against Excel formulas” do?: It prefixes values starting with =, +, - or @ with an apostrophe, so spreadsheets show them as text instead of running them as formulas — a safeguard when data comes from untrusted sources.