JSON to CSV Converter

Convert JSON data to CSV format instantly. Free online JSON to CSV converter with download option. Handles nested objects and arrays.

Last updated: June 1, 2026

JSON Input

CSV Output

What is JSON to CSV Converter?

A JSON to CSV converter transforms structured JSON (JavaScript Object Notation) data into CSV (Comma-Separated Values) format, which is the universal format for spreadsheet data. JSON organizes data as nested objects and arrays, which is ideal for APIs and programming but difficult to view in spreadsheets. CSV organizes data as flat rows and columns, which every spreadsheet application (Excel, Google Sheets, LibreOffice) can open directly. This tool bridges that gap — taking JSON arrays of objects and producing properly formatted CSV files where each JSON key becomes a column header and each object becomes a row.

How It Works

The tool parses your JSON input and identifies the structure. For arrays of objects, each object becomes a CSV row and each unique key across all objects becomes a column header. Nested objects are flattened using dot notation — for example, {address: {city: 'NYC'}} becomes a column called 'address.city'. Arrays within objects are joined as comma-separated values within a single cell. The tool handles edge cases like missing keys (empty cells), special characters in values (proper CSV quoting), and mixed data types. Output uses standard CSV formatting with proper escaping of commas, quotes, and newlines within values.

Examples

Array of objects → CSV format

Input

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

Output

name,age
Alice,30
Bob,25

Nested objects → Flattened CSV

Input

[{"user":"Alice","address":{"city":"NYC"}}]

Output

user,address.city
Alice,NYC

Common Use Cases

•Exporting API response data into spreadsheets for business analysis and reporting
•Converting database query results from JSON format for use in Excel or Google Sheets
•Preparing data exports for non-technical stakeholders who work with spreadsheets
•Migrating data between systems where the source outputs JSON and the target requires CSV
•Creating data files for import into CRM, accounting, or inventory management software
•Formatting JSON log data into tabular format for easier filtering and sorting

Frequently Asked Questions

How does JSON to CSV conversion work?▼

The tool flattens your JSON objects into rows and columns. Each unique key becomes a column header, and each object in the array becomes a row in the CSV. Nested objects are flattened using dot notation (e.g., address.city).

Can it handle nested JSON?▼

Yes, nested objects are flattened using dot notation to create column headers. For example, a nested field like user.address.zipcode becomes a column named 'user.address.zipcode' in the CSV output.

Can I download the result?▼

Yes, you can copy the CSV to clipboard or download it as a .csv file that opens directly in Excel, Google Sheets, or any spreadsheet application.

What happens with arrays inside objects?▼

Arrays are converted to comma-separated strings within a single cell. For example, ['red', 'blue'] becomes 'red,blue' in the CSV cell.

What if objects have different keys?▼

The tool collects all unique keys across all objects to create the complete set of column headers. Objects missing a particular key will have an empty cell in that column.

Does it handle special characters?▼

Yes, values containing commas, quotes, or newlines are automatically wrapped in double quotes following the RFC 4180 CSV standard. Internal quotes are escaped by doubling them.