// Converter
JSON to CSV online
Convert JSON arrays to CSV format - download or copy the result
by
CHUNKY
MUNSTER
MUNSTER
Output will appear here...JSON to CSV Converter maps a JSON array to CSV row-for-row, but real-world arrays rarely have perfectly uniform shapes. This converter walks every object first to build a header row that is the union of all keys, in first-appearance order. Rows that don't have a particular key produce an empty cell rather than throwing - that is the most useful behaviour when consuming output from APIs that omit nulls.
Quoting follows RFC 4180 strictly: a field containing , " or newline is wrapped in double-quotes, and any internal double-quote is escaped by doubling it. That output imports cleanly into Excel, Google Sheets and Postgres COPY without further massaging. Nested objects and arrays are JSON-stringified into a single cell because CSV is intentionally flat - the structure is preserved as text and is round-trippable via JSON.parse.
The header row is the union of every key in first-appearance order. Rows that lack a key just produce an empty cell, so heterogeneous arrays still convert cleanly.
Objects and arrays are JSON-stringified into a single cell. CSV has no notion of nesting, so this is the round-trippable convention - JSON.parse the cell later if you want the structure back.
Yes - RFC 4180. Any field containing a comma, double-quote or newline is wrapped in double-quotes, and any internal double-quote is escaped as "". Excel, Google Sheets, LibreOffice and Postgres COPY all accept this.
It is wrapped to a one-row array automatically. The keys become the header row, the values become the only data row.
Bookmark this JSON to CSV Converter for the next time you need to turn a JSON array into a clean, spreadsheet-ready CSV file.