JSON to CSV
Convert JSON arrays to CSV format instantly.
JSON input
CSV output
JSON vs. CSV
JSON excels at nested hierarchical data. CSV is optimal for flat tabular data that opens in spreadsheets.
- JSON: nested objects, mixed types, web APIs
- CSV: Excel/Sheets, BI tools, flat tabular data
- RFC 4180: fields with commas wrapped in quotes
- Nested JSON must be flattened or serialised
Formula / How it works
Takes a JSON array of objects and converts each object to a CSV row. The first row contains the column headers from the object keys. Values with commas or quotes are automatically escaped.