CSV ↔ JSON Converter
What is CSV ↔ JSON Converter?
CSV ↔ JSON Converter is a free online tool for bidirectional conversion between CSV and JSON. CSV is the universal export format of spreadsheets, databases and analytics tools — but it's deceptively messy in the real world: quoted fields with embedded commas, Excel's locale-dependent semicolon exports, ragged rows and stray quotes everywhere. JSON is what APIs and applications actually consume. This tool bridges the two in both directions, leniently parsing real-world CSV instead of rejecting anything that isn't strict RFC 4180.
Features
- CSV → JSON — First row as object keys (or plain arrays), with configurable 2 or 4 space indentation
- JSON → CSV — Arrays of objects (keys become the header row) or arrays of arrays, properly quoted and escaped
- Delimiter sniffing — Auto-detects comma, semicolon or tab by counting delimiters outside quotes, or pick one explicitly
- Lenient parsing — Quoted commas and newlines, escaped quotes, BOMs, CRLF/LF/CR line endings, and stray quotes in unquoted fields all handled gracefully
- Ragged rows — Short rows are padded with empty strings; extra cells are kept under generated, collision-free key names
- Values stay strings — No type inference, so
00123stays00123and1E5never becomes a number
How to use
Paste CSV or JSON into the input panel and pick the conversion direction. In CSV → JSON mode, choose a delimiter (or leave it on auto) and toggle whether the first row is a header. The converted output appears live as you type, with parse errors reported at the exact physical line. Use swap to flip the output back into the input for quick round-trip checks, then copy the result with one click.
Privacy
Conversion in the browser UI runs locally on your device — pasted data is not uploaded. (A public API endpoint also exists for programmatic use; anything you send there is, by definition, transmitted.)