JSON to CSV Converter
Convert JSON arrays and nested objects into CSV format online. Automatically flattens nested keys, generates headers, and exports RFC 4180 CSV.
How JSON → CSV Works
- Scans all JSON array items to discover all unique column headers.
- Flattens nested object properties into dot-notation column names (e.g. user.address.city).
- Formats cell values according to RFC 4180, enclosing strings with commas in double quotes.
Example Input & Output
Extracts union of keys from all array objects to build the header row, flattening nested objects and escaping commas inside quotes.
[
{
"id": 1,
"name": "Sandeep",
"role": "Lead",
"location": "Hyderabad, India"
},
{
"id": 2,
"name": "John Doe",
"role": "Developer",
"location": "London, UK"
}
]id,name,role,location 1,Sandeep,Lead,"Hyderabad, India" 2,John Doe,Developer,"London, UK"
Common Use Cases
Spreadsheet Export
Import JSON database queries into Excel, Google Sheets, or Numbers.
Analytics & Reporting
Convert API data dumps into CSV tables for Tableau or PowerBI ingestion.
Key Specifications & Gotchas
Non-Array Top Level
Top-level JSON should ideally be an array of objects to generate tabular rows.
Frequently Asked Questions
Can I convert nested JSON to CSV?
Yes, nested objects are automatically flattened into dot-notated column names.
How are commas inside values handled?
Values containing commas or line breaks are automatically wrapped in double quotes per RFC 4180.
Related JSON & Data Format Tools
View all 41 tools →CSV → JSON
Convert CSV to JSON online. Transform spreadsheet tables into JSON arrays of objects with automatic type conversion and header mapping.
CSV Formatter
Format and clean CSV files online. Fix inconsistent delimiters, align columns, handle quoted values, and export clean RFC 4180 CSV tables.
JSON Formatter
Format, beautify, and pretty print JSON online with customizable indentation, key sorting, and instant syntax validation. 100% private in-browser tool.