JSON to CSV Converter

Paste your JSON array and get a CSV file instantly. Supports nested objects, custom delimiters, and file download. All processing is done in your browser.

Options

JSON Input

CSV Output

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, or Copy 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

Frequently Asked Questions

How to convert JSON to CSV?

Paste your JSON array into the left panel and the CSV output appears instantly in the right panel. You can also upload a .json file. Once converted, click Download to save the CSV file or Copy to copy it to your clipboard. No signup or installation required.

What JSON format is supported?

The converter supports JSON arrays of objects. Each object in the array becomes a row in the CSV, and each key becomes a column header. For example: [{"name":"John","age":30},{"name":"Jane","age":25}] converts to a CSV with columns "name" and "age".

How are nested JSON objects handled?

Nested JSON objects are automatically flattened using dot notation. For example, {"user":{"name":"John","city":"Delhi"}} becomes two columns: "user.name" and "user.city". This makes deeply nested JSON fully usable in spreadsheet applications.

Can I change the CSV delimiter?

Yes. The converter supports four delimiter options: Comma (,) — the standard CSV format used by Excel and Google Sheets; Semicolon (;) — common in European locales; Tab — creates a TSV (Tab-Separated Values) file; and Pipe (|) — used in some data pipelines.

Is there a file size limit?

There is no hard file size limit — all conversion happens locally in your browser, so your data never leaves your device. However, very large files (above 50MB) may cause the browser to slow down depending on your device memory.

Can I open the CSV in Excel?

Yes. Download the CSV file and open it directly in Microsoft Excel, Google Sheets, LibreOffice Calc, or any spreadsheet application. For Excel users in Europe, use the Semicolon delimiter option as European Excel versions often expect semicolons instead of commas.

Related Text Tools

Subscribe to the Calcon newsletter

Get new calculators, tools, and practical guides delivered to your inbox. No spam — unsubscribe anytime.