JSON to CSV Converter

How to Convert JSON to CSV

1. Paste your JSON array or object into the input box above (or upload a .json file).
2. Pick your options — delimiter (comma, semicolon, tab) and how arrays should be handled.
3. Click Convert to CSV. Nested objects are flattened into dot-notation columns automatically.
4. Download or copy the CSV — open it directly in Excel, Google Sheets, or Numbers.

Nested JSON Example

Given this input:

[
  { "id": 1, "user": { "name": "Alice", "city": "NYC" }, "tags": ["admin","beta"] },
  { "id": 2, "user": { "name": "Bob",   "city": "SF"  }, "tags": ["user"] }
]

You get:

id,user.name,user.city,tags
1,Alice,NYC,"admin|beta"
2,Bob,SF,user

Do It in Code

If you'd rather convert in a script:

# Python
import json, csv, io
data = json.load(open("data.json"))
keys = data[0].keys()
with open("out.csv","w",newline="") as f:
    w = csv.DictWriter(f, fieldnames=keys); w.writeheader(); w.writerows(data)

// Node.js
const data = require("./data.json");
const headers = Object.keys(data[0]);
const csv = [headers.join(","), ...data.map(r => headers.map(h => JSON.stringify(r[h] ?? "")).join(","))].join("\n");

# jq one-liner
jq -r '(.[0] | keys_unsorted) as $k | $k, map([.[ $k[] ]])[] | @csv' data.json