CSV to JSON Converter

Paste CSV or a spreadsheet column and get a clean JSON array, with numbers and true/false kept as real types.

Runs in your browser. Nothing you type is sent to a server.

How to use CSV to JSON Converter — Free Online, Runs In Your Browser

  1. 1Paste your CSV, with the column names on the first line.
  2. 2Pick your indent size, and optionally sort the keys alphabetically.
  3. 3Copy the result, or download it as a file.

About CSV to JSON

Going from a spreadsheet export to something an API will accept normally means writing a throwaway script. This tool does it in the browser: paste the CSV, read the JSON.

The type handling is what makes the output actually usable. A naive converter turns every cell into a string, so you end up with "42" where you wanted 42 and "true" where you wanted a boolean, and then have to clean it up anyway. Here numeric and boolean cells are converted to their real JSON types, and empty cells become null rather than empty strings.

The parser handles quoted fields properly, so exported data containing commas inside addresses or descriptions does not shift every subsequent column.

Frequently asked questions

Does the first row have to be headers?
Yes — the first line is read as the column names, which become the keys of every object in the resulting array.
Are numbers kept as numbers?
Yes. A value like 42 or 3.14 becomes a JSON number, true and false become booleans, and an empty cell becomes null. Everything else stays a string.
What about fields containing commas?
Standard CSV quoting is respected: a field wrapped in double quotes may contain commas, line breaks and doubled quotes, and it is parsed as one value.
Can I paste straight from Excel or Google Sheets?
Copying from a spreadsheet usually gives tab-separated text rather than commas. Use File → Download → CSV first, then paste the contents here.
Is my data sent to a server?
No. The whole tool is JavaScript running on your own device, so your text never leaves the browser. You can load the page, go offline, and it still works.
Is it free?
Yes — unlimited use, no sign-up, no watermark and no limit on how many times you run it.