JSON ↔ CSV Converter
Convert JSON arrays to CSV spreadsheets and CSV data back to JSON. Handles nested objects, custom delimiters, and instant file download.
Advertisement
Options
Input
Output
Advertisement
About JSON to CSV Converter
This free online tool converts JSON data to CSV (Comma-Separated Values) format for use in spreadsheet applications like Microsoft Excel, Google Sheets, and LibreOffice Calc. It also converts CSV data back to JSON for use in web applications and APIs.
Supported JSON Structures
- Array of objects — The most common format. Each object becomes a row.
- Nested objects — Flattened using dot notation (e.g.,
address.city). - Mixed types — Numbers, booleans, and null values are all handled correctly.
- Arrays within objects — Converted to JSON string representation in the cell.
Delimiter Options
- Comma (,) — Standard CSV format. Compatible with most applications.
- Semicolon (;) — Common in European locales where comma is the decimal separator.
- Tab — TSV format. Useful for data with commas in values.
- Pipe (|) — Alternative delimiter for data containing commas and semicolons.
How Nested Objects Are Flattened
When a JSON object contains nested objects, the "Flatten nested objects" option converts them using dot notation. For example, {"address": {"city": "NYC", "zip": "10001"}} becomes columns address.city and address.zip.