CSV to JSON Converter
A CSV to JSON converter reads comma-separated rows — including quoted fields with embedded commas, quotes, or line breaks — and produces a JSON array of objects keyed by the header row. Proper CSV quoting rules — a comma or line break inside a value must be wrapped in double quotes, and a literal quote inside a quoted value is doubled — are exactly what trips up a naive split-on-comma approach, which is why this parser follows the same RFC 4180 quoting rules that Excel and Google Sheets use when exporting.
How it works
- Paste CSV text. The first row is treated as the column headers.
- Read the converted JSON array immediately below.
- Copy the result with the Copy result button.
Formula Row 1 = keys; each following row becomes one JSON object
Frequently asked questions
Does this handle commas inside a value?
Yes, if the value is quoted (e.g. "Smith, John") per standard CSV (RFC 4180) rules.
What if a row has fewer columns than the header?
Missing values become empty strings in the resulting object.
Are numbers converted to JSON numbers?
No — every value is a JSON string, matching what CSV actually contains. Cast types in your own code if needed.
Does this handle Excel-exported CSV?
Yes — it supports both LF and CRLF line endings and doubled-quote escaping, which is how Excel exports CSV.
Is my data uploaded anywhere?
No. Conversion runs entirely in your browser.