JSON to CSV Converter

What is a JSON to CSV Converter?

A JSON to CSV converter transforms structured JSON data into the comma-separated values format used by spreadsheet applications like Microsoft Excel and Google Sheets. JSON (JavaScript Object Notation) is the standard data format for APIs and web services, while CSV is the universal format for tabular data, reports, and data imports.

Calcon's JSON to CSV Converter handles the most common use cases: flat arrays of objects, nested objects (flattened using dot notation), custom delimiters, null value handling, and direct file download — all in your browser without sending data to any server.

How to Use the JSON to CSV Converter

1. Paste your JSON array into the left panel, or click Upload to upload a .json file from your computer.
2. The CSV output appears instantly in the right panel as you type or paste.
3. Adjust options: choose your delimiter (comma, semicolon, tab, or pipe), toggle headers, and set how null values should appear.
4. Click Download to save as a .csv file, orCopy to copy the output to your clipboard.

Supported JSON Format

The converter expects a JSON array of objects:

[
  { "name": "Alice", "age": 30, "city": "Mumbai" },
  { "name": "Bob",   "age": 25, "city": "Delhi"  }
]

Output CSV:

name,age,city
Alice,30,Mumbai
Bob,25,Delhi

Nested Object Flattening

Nested objects are automatically flattened using dot notation:

[
  { "user": { "name": "Alice", "city": "Mumbai" }, "score": 95 }
]

Output:

user.name,user.city,score
Alice,Mumbai,95