JSON to CSV Converter
Convert JSON data to CSV format instantly. Paste your JSON array of objects and get a properly formatted CSV file with headers. Supports custom delimiters, handles nested quotes, and allows direct download. Useful for data export, spreadsheet import, and database migration.
How to Convert JSON to CSV
- Paste your JSON array of objects into the input field
- Select your preferred delimiter (comma, semicolon, tab, or pipe)
- Choose whether to include column headers
- Click "Convert to CSV" to generate the output
- Copy the result or download as a .csv file
Supported JSON Format
The converter expects a JSON array where each element is an object. Object keys become CSV column headers, and values become row data. Missing keys in some objects will produce empty cells.
Frequently Asked Questions
What JSON format does this converter accept?
It accepts a JSON array of objects (e.g., [{"key":"value"}]) or a single JSON object. Each object's keys become column headers in the CSV output.
How are special characters handled?
Values containing commas, quotes, or newlines are automatically wrapped in double quotes per RFC 4180 (the CSV standard). Internal quotes are escaped by doubling them.
Can I convert nested JSON?
Nested objects and arrays are converted to their string representation. For deeply nested data, you may want to flatten the JSON first before converting.
What is the maximum file size?
This browser-based converter handles JSON up to several megabytes. For very large files (100MB+), consider using a command-line tool or programming language.
Can I open the CSV in Excel?
Yes. Download the .csv file and open it directly in Microsoft Excel, Google Sheets, or any spreadsheet application. Use semicolon delimiter if your locale uses commas as decimal separators.