📊

JSON to CSV Converter

Convert JSON arrays to CSV format. Flatten nested objects with dot notation.

Delimiter

Include headersFlatten nested objects

JSON Input

CSV Output

name,age,city John,30,New York Jane,25,London Bob,35,Tokyo

3 rows3 columns58 characters

Data Preview

#	name	age	city
1	John	30	New York
2	Jane	25	London
3	Bob	35	Tokyo

About JSON to CSV Converter

Free online JSON to CSV converter that transforms JSON arrays into clean CSV data. Paste your JSON or upload a .json file to instantly get a downloadable CSV. Supports nested JSON objects with automatic flattening using dot notation (e.g., address.city). Choose your delimiter (comma, semicolon, tab, pipe), toggle header row inclusion, and preview the parsed data in a formatted table. Handles edge cases like missing fields, mixed types, and special characters in values. Copy the CSV output to clipboard or download as a .csv file. Shows column count, row count, and any conversion warnings. Ideal for exporting API responses to spreadsheets, data analysis, and converting between data interchange formats.

Frequently Asked Questions

What JSON structure does this tool expect?▾

The tool expects a JSON array of objects, like [{"name": "John", "age": 30}, {"name": "Jane", "age": 25}]. If you provide a single object, it will be automatically wrapped in an array. The object keys become CSV column headers.

How does nested object flattening work?▾

When 'Flatten nested objects' is enabled, nested objects are converted to dot-notation keys. For example, {"address": {"city": "Tokyo"}} becomes a column named 'address.city' with value 'Tokyo'. This works for any depth of nesting.

Can I open the CSV in Excel?▾

Yes. Download the .csv file and open it directly in Excel, Google Sheets, or any spreadsheet application. If you're in a region that uses semicolons, select the semicolon delimiter for better Excel compatibility.

What happens with missing or inconsistent fields?▾

The tool handles missing fields gracefully - if some objects lack certain keys, the corresponding CSV cells are left empty. Mixed data types are converted to strings. The tool shows column count and any warnings about inconsistencies in the parsed data.

Is this JSON to CSV converter free?▾

Yes, completely free with no signup. Convert any JSON array to CSV instantly, handle nested objects with dot notation flattening, and download the result. All processing happens in your browser - your data is never sent to any server.