How to convert JSON to CSV?

Extract each object in a JSON array as a CSV row, using keys as column headers and values as cell content. Nested objects can be flattened with dot notation (e.g., user.name), arrays can be joined or expanded.

How are nested JSON objects handled?

Nested objects are automatically flattened with dot-joined keys (e.g., address.city). Custom separators are supported. Deep nesting is recursively expanded.

How are JSON array fields converted to CSV?

Array fields can be joined with semicolons (tag1;tag2), converted to JSON strings, or skipped entirely.

What delimiters are supported?

Comma (,), Tab, Semicolon (;), and Pipe (|) delimiters are supported.

Is data uploaded to a server?

No. All conversion runs locally in your browser.

Free JSON to CSV Converter

Convert JSON data to CSV format with nested flattening, array expansion, and custom delimiters

What Can the JSON to CSV Converter Do?

The JSON to CSV Converter is a free online data format conversion tool that quickly transforms JSON array data into CSV table format. Supports automatic nested object flattening (e.g., user.address.city), multiple array field handling options, custom delimiters, and column sorting. The resulting CSV can be directly imported into Excel, Google Sheets, and other tools. All processing runs locally in your browser—no data is ever uploaded.

Core Features

Nested Flattening: Automatically expand deep nested objects into dot-separated columns (e.g., address.city)
Array Handling: Three modes—semicolon join, JSON stringify, or skip
Multiple Delimiters: Comma, Tab, Semicolon, and Pipe delimiters
Auto Detection: Automatically identifies JSON arrays or objects with data/results/items fields
Error Location: Precise JSON syntax error position reporting

How to Use

1. Paste JSON data in the input box, or click "Load Example" to see it in action.

2. Select CSV delimiter, nested object and array handling options.

3. Click "Convert to CSV" or press Ctrl+Enter.

4. Copy the result or download as a .csv file.

Use Cases

Data Analysis

Data analysts convert API JSON responses to CSV for import into Excel or Pandas for statistical analysis.

Database Migration

Developers convert MongoDB JSON exports to CSV format for import into MySQL and other relational databases.

Report Generation

Ops teams convert monitoring system JSON responses to CSV for more readable reports.

Technical Background

CSV (Comma-Separated Values) is the most universal tabular data exchange format, supported by virtually all data processing tools. The core challenge of JSON to CSV conversion is handling nested structures and arrays: nested objects need flattening to dot-notation paths, and arrays require decisions on joining, expanding, or skipping. RFC 4180 defines the CSV standard, requiring fields containing commas, newlines, or double quotes to be wrapped in double quotes, with internal double quotes escaped as two double quotes. TSV (Tab-Separated Values) is a CSV variant using tab delimiters, common in bioinformatics and log analysis.

📊 JSON to CSV

📥 JSON Input

⚙️ Conversion Options

📤 CSV Output