JSON to CSV
Convert a JSON array of objects to CSV format.
$json input
0 chars1 lines
$csv output[READY]
0 chars1 lines
Related Tools
FAQ
- What JSON structure is expected?
- The input must be a JSON array of objects, for example [{"name":"Alice","age":30},{"name":"Bob","age":25}]. Each object becomes a row and the keys become CSV column headers.
- How are nested objects handled?
- Nested objects are flattened using dot notation. For example, {"address":{"city":"NYC"}} becomes a column named address.city.
- Are special characters escaped?
- Yes. Values containing commas, double quotes, or newlines are wrapped in double quotes, and any existing double quotes inside are escaped by doubling them, following the RFC 4180 CSV standard.
JSON to CSV takes a JSON array of objects and converts it to comma-separated values. Headers are extracted from the union of all object keys. Nested objects are flattened using dot notation (e.g. address.city). Values containing commas or quotes are properly escaped. The output is ready to paste into Excel, Google Sheets, or any CSV-aware tool.