Toolverge

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.

2 row(s) converted

[
  {
    "name": "Ada",
    "age": "36"
  },
  {
    "name": "Grace",
    "age": "85"
  }
]

How it works

  1. Paste CSV text. The first row is treated as the column headers.
  2. Read the converted JSON array immediately below.
  3. 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.