📊

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.

Related Tools

🔢

Binary/Hex/Decimal Converter

Convert numbers between binary, hexadecimal, decimal, and octal.

📐

Unit Converter

Convert between units of length, weight, temperature, volume, and more.

📋

CSV to JSON Converter

Convert CSV data to JSON format online. Supports custom delimiters and file upload.

🎨

Color Code Converter

Convert colors between HEX, RGB, HSL, and RGBA formats. Visual picker with Tailwind matches.

🤖

AI Prompt Generator

Generate perfect AI prompts for ChatGPT, Claude, Midjourney, DALL·E, and coding assistants.

📧

AI Cold Email Generator

Generate personalized cold emails with subject lines for B2B outreach, sales, and partnerships.

Browse all 50+ free tools