TV
Home All Tools Blog About

JSON to CSV Converter

Convert JSON arrays to CSV format instantly. Handles nested objects and supports custom delimiters.

Delimiter:

How It Works

Paste a JSON array into the input area. The tool extracts headers from the first object's keys, then converts each array element to a CSV row. Click Download to save the result as a .csv file.

Converting JSON data to CSV is a common task for data analysts, developers, and business users who need to import API data into spreadsheet tools like Excel or Google Sheets. Our free JSON to CSV converter handles the conversion instantly in your browser.

**Why Convert JSON to CSV?**

JSON is the native data format of REST APIs and modern web applications. CSV is the universal format for spreadsheets and data analysis tools. Converting between them is a constant requirement when working with real-world data pipelines.

**How the Conversion Works**

1. The tool parses your JSON array and reads the keys from the first object
2. These keys become the CSV column headers
3. Each object in the array becomes one row
4. Values are properly quoted and escaped for CSV compatibility

**Handling Nested Objects**

Nested JSON objects can be flattened using dot notation. For example, `{"user": {"name": "Alice"}}` becomes a column named `user.name`. Arrays within objects are serialized as JSON strings in the cell.

**CSV Formatting Rules**

- Values containing commas, newlines, or double quotes are enclosed in double quotes
- Double quotes within values are escaped as two double quotes (`""`)
- The delimiter can be changed to semicolons (`;`) or tabs for different locale requirements

**Use Cases**

- Exporting API responses to Excel for non-technical team members
- Converting database query results (JSON format) to CSV for reporting
- Migrating data between systems
- Preparing data for import into CRM, ERPs, and other business tools
- Data analysis and visualization in tools that require CSV input

**Limitations**

This tool works best with flat or shallow JSON arrays. Deeply nested structures may require manual post-processing. For complex transformations, consider tools like jq (command line) or Python's pandas library.

**Privacy**

All conversion runs in your browser. Your data is never uploaded to our servers.

Frequently Asked Questions

The converter expects a JSON array of objects where each object has the same keys. Mixed schemas may result in empty cells for missing fields.
Yes. Nested objects are flattened using dot notation (e.g., address.city becomes a column). Arrays within objects are serialized as JSON strings.
Download the file and open it in Excel. If Excel does not split columns correctly, use Data > From Text/CSV and specify the delimiter during import.
Yes. Our converter supports custom delimiters including semicolons (common in European Excel locales) and tabs.
Values containing commas or newlines are wrapped in double quotes. Double quotes within values are escaped as two consecutive double quotes, per RFC 4180.