Skip to content
◈

JSON to CSV

ConvertersFree · Private

Convert JSON arrays to CSV instantly. Handles nested objects with dot-notation flattening, custom delimiters, and large files via Web Worker. No data uploaded.

JSON Input (array of objects)
Drop a file here, or click to browse
CSV Output

What is JSON to CSV conversion?

CSV (Comma-Separated Values) is the universal format for spreadsheets, data analysis tools, and database imports. Converting a JSON array to CSV lets you open API data in Excel, import it into Google Sheets, load it into pandas, or feed it to any data pipeline that expects tabular data.

How to convert JSON to CSV

  1. Paste a JSON array of objects into the input. Each object becomes one CSV row.
  2. Choose your delimiter — comma for Excel/Sheets, semicolon for European locales, tab for TSV.
  3. Toggle Flatten nested objects to expand {"user": {"name": "Alice"}} into a user.name column.
  4. Copy the CSV or download it. Need to go the other way? Use our CSV to JSON converter.

How are nested objects handled?

When Flatten is enabled, nested objects are expanded using dot notation. For example:

// Input JSON
[{"user": {"name": "Alice", "city": "London"}, "score": 99}]

// Output CSV (flattened)
user.name,user.city,score
Alice,London,99

Arrays inside objects are converted to a JSON string representation in the cell, since CSV has no native array syntax.

Why this is safer for sensitive data

API exports, CRM data, and analytics JSON often contain personal information. This tool runs entirely in your browser — your data is converted locally and never uploaded to any server. The downloaded CSV goes directly from your browser to your filesystem.

Frequently Asked Questions

How do I convert JSON to CSV online?
Paste your JSON array into the input, click Convert, and download the CSV. Nested objects are flattened using dot notation (e.g. address.city).
What happens with nested JSON objects?
Nested objects are flattened: {"user":{"name":"Alice"}} becomes a column named user.name with value Alice.
Can I change the delimiter?
Yes. Choose comma, semicolon, tab, or pipe as the delimiter to match your target application.
What if my JSON has inconsistent keys?
The converter performs a full pass to collect all unique keys and uses them as headers, leaving empty cells for missing values.

Related Tools

◈
CSV to JSON

Convert CSV files to JSON arrays instantly in your browser. Auto-detects headers and delimiters, handles quotes and escaping correctly. Your data stays private.

◈
JSON to YAML

Convert JSON to YAML format instantly in your browser. Clean, readable output with proper indentation. No upload, no account — 100% private.

◈
JSON Formatter

Format, beautify, and minify JSON instantly in your browser. Syntax highlighting, error detection, sort keys, and one-click Fix. Your data never leaves your device.