Convert a JSON array of objects to CSV and back — with proper quoting and header detection.
// Output appears here…
CSV is the universal format for spreadsheets; JSON is the format of APIs. This converter flattens a JSON array of objects into CSV rows (union of all keys becomes the header) and parses CSV back into typed JSON. Quoting follows RFC 4180. Runs locally.
When converting JSON to CSV, the header row is the union of all keys across every object, so no field is lost even if some objects omit it. Missing values are left as empty cells.
Yes. It follows RFC 4180: fields containing commas, quotes or newlines are wrapped in double quotes and embedded quotes are doubled, so the output opens cleanly in Excel and other tools.
Yes. Numeric and boolean-looking values are converted to numbers and booleans rather than left as strings, while you can choose your delimiter (comma, semicolon or tab).