JSON to CSV Converter: Flatten JSON Arrays to CSV Instantly

Why Convert JSON to CSV?

JSON is ideal for API data exchange but difficult to analyse in spreadsheet tools like Excel, Google Sheets, or Tableau. Converting JSON arrays to CSV unlocks pivot tables, charts, and data analysis workflows without writing code.

How JSON-to-CSV Flattening Works

Each object in the JSON array becomes one row. Each unique key across all objects becomes a column header. Nested objects are flattened using dot notation (e.g., address.city). Missing values are left blank.

Supported Input Formats

• Array of flat objects: [{"id":1,"name":"Alice"}, ...]
• Array of nested objects (auto-flattened with dot notation)
• Single object (outputs one data row)

Step-by-Step: Export JSON to CSV

1. Paste your JSON array or upload a .json file.
2. Preview the column headers auto-detected from the data.
3. Select delimiter: comma, semicolon, or tab.
4. Click Download CSV to get a ready-to-open spreadsheet file.

// JSON Input
[
  { "id": 1, "name": "Alice", "city": "London", "score": 92 },
  { "id": 2, "name": "Bob",   "city": "Berlin", "score": 87 }
]

// CSV Output
id,name,city,score
1,Alice,London,92
2,Bob,Berlin,87