JSON to CSV Converter

How to use the JSON to CSV Converter

1. Paste a JSON array of objects, or open or drop a .json file on the left.
2. The CSV appears on the right immediately, with one column for every key found in any row.
3. Choose comma, semicolon or tab, and decide whether nested objects become dot columns.
4. Copy the CSV or download it and open it in Excel, Numbers or Google Sheets.

Examples

[
  {"id": 1, "name": "Ada Lovelace", "email": "ada@example.com", "active": true},
  {"id": 2, "name": "Alan Turing", "email": "alan@example.com", "active": false},
  {"id": 3, "name": "Grace Hopper", "email": "grace@example.com", "active": true}
]

[
  {"order": "A-1001", "customer": {"name": "Lena", "city": "Berlin"}, "total": 59.9, "items": ["mug", "tea"]},
  {"order": "A-1002", "customer": {"name": "Tom", "city": "Leeds"}, "total": 12.5, "items": ["card"]}
]

{
  "results": [
    {"sku": "TS-01", "title": "T-shirt, blue", "price": 19.99},
    {"sku": "HD-07", "title": "Hoodie \"Classic\"", "price": 49}
  ]
}

About this tool

APIs and databases speak JSON, but colleagues, accountants and spreadsheet apps prefer rows and columns. This converter reads a JSON array, collects every key that appears in any object, and writes one CSV row per item. Missing keys simply leave an empty cell, so records with different shapes still line up.

Nested objects are flattened into dot-separated columns: {"customer": {"city": "Berlin"}} becomes a customer.city column. Arrays are kept as compact JSON text by default, or can be spread across numbered columns. Values that contain the delimiter, quotes or line breaks are quoted correctly, so the file opens cleanly everywhere.

Tip: if Excel shows everything in one column or mangles accented letters, switch to the semicolon delimiter or enable the BOM option under More options.