JSON to CSV Converter
Convert JSON arrays to CSV format. Handles nested objects with dot notation flat...Convert JSON arrays to CSV format. Handles nested objects with dot notation flattening and properly escapes special characters.
Updated
JSON Input
CSV Output
Conversion Summary
Quick answer
A JSON to CSV converter turns a JSON array of objects into comma-separated rows, using the object keys as the column headers. This tool builds the header from the union of keys across every object, so a row that is missing a key still gets an empty cell in the right column, and it wraps any value containing a comma, quote, or line break in quotes following the RFC 4180 rules that Excel expects. Everything runs in your browser, so your JSON is never uploaded to a server.
Converter Features
Why Use JSON to CSV Converter?
Smart Conversion
Automatically detects JSON structure and converts arrays of objects into properly formatted CSV with headers.
Nested Object Flattening
Flatten nested JSON objects using dot notation (e.g., address.city) for complete data extraction.
Custom Delimiters
Choose between comma (CSV), semicolon (European locale), or tab (TSV) delimiters for compatibility.
Instant Download
Download the converted CSV file with one click, ready to open in Excel, Google Sheets, or any spreadsheet app.
100% Private
All conversion happens in your browser. Your JSON data never leaves your device.
Special Character Handling
Automatically escapes quotes, commas, and newlines in field values to produce valid CSV output.
Common Uses for JSON to CSV
Data Analysis
Convert API responses to CSV for analysis in Excel, Google Sheets, or data tools.
Database Export
Transform JSON database exports into CSV format for spreadsheet-based workflows.
Report Generation
Convert structured JSON data to CSV for creating reports and presentations.
Data Migration
Convert JSON data to CSV format when migrating between systems with different data requirements.
How It Works
Paste Your JSON Data
Enter a JSON array of objects or a single JSON object. Use the Simple or Nested sample buttons to see examples.
Configure Options
Choose your delimiter (comma, semicolon, tab), toggle the header row, and enable Flatten nested objects as needed.
Copy or Download CSV
Click Copy to copy the CSV to your clipboard or Download to save it as a .csv file ready for spreadsheets.
Tips & Best Practices
Use Flatten for Nested Data
Enable Flatten nested objects to turn a nested object like {address: {city: 'NYC'}} into a flat address.city column.
Try Different Delimiters
If your CSV doesn't open correctly in Excel, try using semicolon delimiter instead of comma, especially for European locale settings.
Array Values
Arrays within objects are converted to JSON strings in the CSV. For better results, ensure your data is a flat array of objects.