JSON

{
  "data": {
    "users": [
      {
        "id": 1,
        "name": "Ada Lovelace",
        "address": {
          "city": "London",
          "country": "UK"
        },
        "tags": [
          "math",
          "computing"
        ]
      },
      {
        "id": 2,
        "name": "Grace \"Amazing\" Hopper",
        "address": {
          "city": "New York",
          "country": "US"
        },
        "tags": [
          "navy"
        ],
        "rank": "Rear Admiral"
      }
    ]
  }
}

2 rows · 6 columns

Drop a JSON file here

CSV

id,name,address.city,address.country,tags,rank
1,Ada Lovelace,London,UK,math; computing,
2,"Grace ""Amazing"" Hopper",New York,US,navy,Rear Admiral

id,name,address.city,address.country,tags,rank
1,Ada Lovelace,London,UK,math; computing,
2,"Grace ""Amazing"" Hopper",New York,US,navy,Rear Admiral

Preview

id	name	address.city	address.country	tags	rank
1	Ada Lovelace	London	UK	math; computing
2	Grace "Amazing" Hopper	New York	US	navy	Rear Admiral

How to convert JSON to CSV

Paste or type your JSON, or drop a JSON file.
If the rows are further in (e.g. data.items), pick the list to convert; the first one is picked for you.
Choose the delimiter, the header row, how nested objects and lists are written, and the line ending.
Check the preview, then copy the CSV or download it, with a byte order mark for Excel if you like.

Questions

How are nested objects converted?

They're flattened into dotted columns, such as address.city, or kept as JSON in one column. Lists are joined with ; or kept as JSON.

Which JSON shapes work?

An array of objects (a column for each key, in the order they first appear), an array of arrays, an object of objects (with a key column) or a single object.

Why does Excel show odd characters?

Excel reads CSV in an old encoding unless the file starts with a byte order mark. Tick the Excel-friendly download and accented letters show correctly.

Is my data uploaded?

No. It's converted by your browser as you type.