CSV ↔ JSON Converter
Convert CSV to a JSON array of objects, or JSON back to CSV, in your browser.
Related Tools
0 comments
How it works
CSV to JSON parses each row with an RFC-4180-aware reader that understands quoted fields, escaped double-quotes, and commas or newlines inside quotes. The first row becomes the object keys, producing an array of objects. JSON to CSV takes an array of objects, builds a header from the union of all keys, and quotes any value containing a comma, quote, or newline. Choose the delimiter (comma, semicolon, or tab) and whether the first row is a header. Parsing happens locally — nothing is uploaded.
a,b\n1,2 ⇄ [{ "a": "1", "b": "2" }]
Common use cases
- Turning a spreadsheet export into JSON for a frontend or API fixture.
- Flattening an array of API objects back into a CSV for Excel or Sheets.
- Cleaning up a semicolon-delimited European CSV into standard JSON.
Frequently asked questions
Does it handle commas inside quoted fields?
Yes. The parser follows RFC 4180: fields wrapped in double-quotes may contain commas, line breaks, and escaped quotes (""), and they are preserved correctly rather than splitting the row.
What happens if rows have different lengths?
Short rows are padded with empty strings for the missing columns so every object has the same keys. Extra columns beyond the header are kept under numeric fallback keys.
Why does my JSON fail to convert to CSV?
JSON to CSV expects a top-level array of flat objects. A single object, deeply nested objects, or invalid JSON will show an error explaining what was expected.