JSON to CSV Converter
Paste a JSON array of objects and convert it to CSV — choose your delimiter, toggle the header row, and download or copy the result.
What Is a JSON to CSV Converter?
A JSON to CSV converter transforms a JSON array of objects into a flat, tabular CSV (Comma-Separated Values) format. Object keys become column headers and each object becomes a row. This is essential when you need to import API data into spreadsheets, databases, or reporting tools that expect CSV input. This tool also handles nested objects by flattening them with dot notation, validates your JSON before conversion, and properly escapes special characters in CSV output.
How to Use the JSON to CSV Converter
- Paste JSON — Enter or paste a JSON array of objects into the input area
- Choose Delimiter — Select comma, tab, semicolon, or pipe as the output separator
- Toggle Header — Enable or disable the header row in the CSV output
- Review Output — The CSV result updates automatically with row and column counts
- Export — Copy the CSV to your clipboard or download it as a .csv file
Why Use This JSON to CSV Converter?
- Smart Flattening — Nested objects are automatically flattened using dot notation (e.g., address.city)
- JSON Validation — Invalid JSON is caught with clear error messages before conversion
- Proper Escaping — Fields containing delimiters, quotes, or newlines are correctly escaped per RFC 4180
- Multiple Delimiters — Output as comma, tab, semicolon, or pipe-separated values
- Real-Time — Results update instantly as you type or change settings
- Privacy First — All processing happens in your browser. No data is ever sent to a server
FreeToolbox vs Other JSON to CSV Tools
| Feature | FreeToolbox | ConvertJSON | json-csv.com |
|---|---|---|---|
| Browser-based | Yes | No (server) | No (server) |
| Nested object flattening | Yes (dot notation) | Yes | Yes |
| Real-time conversion | Yes | No (click to convert) | No |
| Multiple delimiters | Yes (4 types) | Comma only | Yes |
| JSON validation | Yes (with messages) | Basic | Yes |
| No ads or signup | Yes | Has ads | Free tier limited |
FAQ
What JSON format is expected?
The tool expects a JSON array of objects, like [{"name":"John","age":30},{"name":"Jane","age":25}]. A single object (not in an array) is also accepted and will be converted to a single-row CSV.
How are nested objects handled?
Nested objects are flattened using dot notation. For example, {"user":{"name":"John"}} becomes a column named 'user.name'. Arrays within objects are serialized as JSON strings.
What if objects have different keys?
The tool collects all unique keys across all objects and uses them as columns. If an object is missing a key, that cell is left empty in the CSV output.
Are special characters handled correctly?
Yes. Fields containing the delimiter character, double quotes, or newlines are automatically wrapped in double quotes per the CSV standard (RFC 4180). Existing double quotes are escaped as double-double quotes.
Can I open the downloaded CSV in Excel?
Yes. The downloaded .csv file can be opened directly in Microsoft Excel, Google Sheets, LibreOffice Calc, or any spreadsheet application. If using a non-comma delimiter, you may need to use the import wizard.