Advertisement
Paste a JSON array of objects and click To CSV to get a spreadsheet-ready CSV, or paste CSV and click To JSON to parse it into a JSON array. The CSV handling follows RFC 4180 — quoted fields, embedded commas, and line breaks inside cells all work — and everything runs locally in your browser.
No. Conversion happens entirely in your browser with JavaScript — your data is never sent to a server, so it works offline and is safe for sensitive datasets.
A JSON array works best: an array of objects becomes a CSV whose columns are the union of the objects' keys, and an array of arrays becomes rows directly. Nested objects or arrays inside a cell are serialized back to JSON so nothing is lost.
The first CSV row is required and is treated as the column names — each following row becomes a JSON object keyed by those names (surrounding whitespace in names is trimmed). Values are kept as strings so the data round-trips exactly, without guessing types and corrupting things like ZIP codes or IDs with leading zeros.
The delimiter is detected automatically from the first row: comma, semicolon (common in European Excel exports), or tab (pasted from a spreadsheet). Generated CSV always uses commas.
Yes. Fields wrapped in double quotes can contain commas, line breaks, and escaped quotes (""), and the converter quotes any output field that needs it — so a,b or a value with a newline survives the round trip.