$ json --csv

json to csv converter.

Convert JSON arrays to CSV instantly. No uploads, no servers — everything runs here.

input

1
2
3
4
5

0 / ∞ chars

load sample

[
  { "name": "Alice", "age": 28, "city": "London", "active": true },
  { "name": "Bob", "age": 35, "city": "Berlin", "active": false },
  { "name": "Charlie", "age": 22, "city": "Paris", "active": true }
]

output

How does nested JSON get converted to CSV?

Nested objects are flattened using dot notation. For example, {"user": {"name": "Alice"}} becomes a column named user.name with value "Alice".

What if my JSON has inconsistent keys?

The converter scans all objects in the array and collects every unique key. Missing values are left empty.

Can I change the delimiter?

Yes, the tool supports comma, semicolon, and tab delimiters. Choose the one that matches your target application.

Handling Nested JSON

CSV is flat by nature, but JSON is often deeply nested. The key challenge is flattening nested objects into columns:

// Nested JSON
[{"name": "Alice", "address": {"city": "NYC", "zip": "10001"}}]

// Flattened CSV
name,address.city,address.zip
Alice,NYC,10001

Common Edge Cases

Edge Case	Problem	Solution
Commas in values	Breaks CSV parsing	Wrap in double quotes
Quotes in values	Breaks CSV escaping	Double the quotes (`""`)
Null values	Empty cells	Output empty string or `N/A`
Inconsistent keys	Missing columns in some rows	Use union of all keys, fill blanks
Arrays in values	Complex to represent	Join with delimiter or flatten

Excel tip: If CSV opens incorrectly in Excel (wrong encoding or delimiter), use Data → From Text/CSV instead of double-clicking the file. You can specify encoding and delimiter there.

learn more in our detailed guide.

→ read the guide