JSON to CSV Converter

Paste a JSON array of objects (e.g. [{"name":"Alice","age":30},{"name":"Bob","age":25}]) into the input box and click Convert. The tool automatically detects all unique keys across every object and uses them as CSV column headers. You can then copy the output or download it as a .csv file ready to open in Excel, Google Sheets, or any data tool.

Nested objects are flattened using dot notation: a field like {"address":{"city":"London"}} becomes the column address.city. Arrays within objects are serialised as JSON strings in the cell. This covers the majority of real-world API responses. For deeply nested structures, you may need to preprocess the JSON before converting.

Yes — use the delimiter selector in the toolbar to switch between comma (,), semicolon (;), and tab (\t). Semicolons are the standard in many European locales where commas are used as decimal separators. Tab-delimited files (.tsv) are useful when your data contains commas within field values.

Yes — the converter follows RFC 4180 CSV quoting rules. Any field containing a comma, double quote, or newline is automatically wrapped in double quotes. Literal double quotes within a field are escaped by doubling them (e.g. "say ""hello"""). This produces standards-compliant CSV that Excel, Python's csv module, and Google Sheets parse correctly.

Yes. In Excel, use File → Import or drag the .csv file onto the Excel window and follow the import wizard (select comma or your chosen delimiter). In Google Sheets, use File → Import and select the CSV file. Both applications will place each column in a separate cell, preserving the structure generated by this tool.