Skip to content
Free data tool

CSV to JSON

This tool turns a CSV file with a header row into a JSON array, where each row becomes an object that uses the column names as keys. It helps developers load spreadsheet exports into code, tests or APIs without writing a parser.

  • Runs in your browser
  • Free, no account needed
  • Copy or download the result

Your input

135 characters

Cell values
Detect types turns plain numbers, true, false and null into JSON values.

Result

[
  {
    "name": "Ada Lovelace",
    "email": "ada@example.com",
    "team": "Research",
    "score": "92"
  },
  {
    "name": "Lin Chen",
    "email": "lin@example.com",
    "team": "Design",
    "score": "85"
  },
  {
    "name": "Priya Shah",
    "email": "priya@example.com",
    "team": "Sales",
    "score": "78"
  }
]

The short answer

Each CSV row becomes one JSON object, and the header row supplies the keys. A field that contains a comma, quote or line break must be wrapped in double quotes, and a quote inside it is written as two quotes. Keeping cells as text preserves IDs and ZIP codes with leading zeros.

FormulaRow i becomes {header1: cell(i,1), header2: cell(i,2), ...}; a quote inside a quoted field is written as ""

Worked exampleThe 3-row CSV with the columns name, email, team and score becomes an array of 3 objects, for example Ada Lovelace with team Research and score "92", where the score stays text in the default setting.

Example

Input
name,email,team,score
Ada Lovelace,ada@example.com,Research,92
Lin Chen,lin@example.com,Design,85
Priya Shah,priya@example.com,Sales,78
Result
[
  {
    "name": "Ada Lovelace",
    "email": "ada@example.com",
    "team": "Research",
    "score": "92"
  },
  {
    "name": "Lin Chen",
    "email": "lin@example.com",
    "team": "Design",
    "score": "85"
  },
  {
    "name": "Priya Shah",
    "email": "priya@example.com",
    "team": "Sales",
    "score": "78"
  }
]

How to use the csv to json

  1. Paste CSV with a header row into the CSV with a header box.
  2. Set Separator to Comma, Tab, Semicolon or Pipe.
  3. Choose Cell values: All text, or Detect types to turn plain numbers, true, false and null into JSON values.
  4. The JSON updates as you type. Press Copy result or Download.

How it works

By default every cell stays text, so ZIP codes and IDs keep their leading zeros. Spaces around a cell are kept as typed.

With Detect types, cells like 42, -3.5, true, false and null become real JSON values. Text such as 007 or TRUE stays a string.

Quoted fields can hold separators, line breaks and doubled quotes ("").

Every row must have the same number of fields as the header, and the error names the row that does not. Blank or duplicate column names are rejected.

Limits are 500 columns and 100,000 data rows. In typed mode, a number too large to store exactly causes an error.

Everything runs in your browser. Your input is not uploaded or stored. If you use Copy link, what you entered is placed in the link.

Questions and answers

How do I convert CSV to JSON?

Paste your CSV with its header row and pick the separator your file uses. You get a JSON array with one object per row.

Can I convert semicolon or tab separated files?

Yes. Change Separator to Semicolon, Tab or Pipe.

Why are my numbers in quotes?

The default keeps every cell as text so nothing changes by accident. Choose Detect types under Cell values to get JSON numbers and booleans.

Is my CSV uploaded?

No. The conversion happens on your own device, inside the browser tab.

Last updated November 1, 2026. Maintained by SnowRock. How our tools work

All 220 SnowRock tools