WebTools

Developer Tools

CSV to JSON Converter

Convert CSV or spreadsheet exports to JSON in your browser, with quoted fields, delimiters and types handled.

By Nitin Raturi · Last reviewed

Input

How to use the CSV to JSON Converter

Turn spreadsheet CSV into JSON in your browser.

  1. Paste CSV or open a CSV file.
  2. Check the delimiter and whether the first row is a header.
  3. Choose whether to detect numbers and true/false.
  4. Copy or download the JSON.

Good to know

  • Rows with a different number of fields are listed so you can fix them.
  • Tap the ⓘ next to any field for a short guide to it.

Parses CSV the way RFC 4180 describes, including quoted commas, quotes and line breaks.

Runs in your browser. Nothing you type is uploaded or saved in the link.

CSV text

Comma-separated values: one record per line, fields separated by a delimiter.

How to fill it in

  • Paste from a spreadsheet export. Fields with commas, quotes or line breaks must be in double quotes.
  • A quote inside a quoted field is written twice: "".

Example

In the sample, "Rao, Asha" stays one field because it is quoted: "Rao, Asha".

Or open a CSV file

Read a .csv file from your device instead of pasting.

How to fill it in

  • Files up to 20 MB, read as UTF-8. The file is never uploaded.

Delimiter

The character between fields. Excel in some regions uses a semicolon.

How to fill it in

  • Leave on Detect, or choose comma, semicolon, tab or pipe.

First row is a header

Uses the first row as names, giving one object per record.

How to fill it in

  • Turn off to get a plain list of rows instead.

Detect numbers and true/false

Turns plain numbers into numbers, true/false into booleans and empty fields into null.

How to fill it in

  • Leave off to keep every value as text. Values with leading zeros, such as PIN codes like 011001, always stay text.

Result

Records
2
Columns
3
Delimiter
comma

JSON

[
  {
    "name": "Rao, Asha",
    "city": "Pune",
    "amount": "12500"
  },
  {
    "name": "Ravi Kumar",
    "city": "Kochi",
    "amount": "8000"
  }
]

ChangelogHow we test this toolEmbed this tool

How this calculator works

  1. Step 1Split into recordsOne per lineLine breaks inside quotes stay inside the field.
  2. Step 2Split into fieldsAt each delimiterCommas inside quotes are kept as text.
  3. Step 3Name the fieldsHeader rowEach record becomes an object with those names.

CSV looks simple, but quoted fields make naive splitting at commas go wrong. This converter reads quotes the way the CSV standard (RFC 4180) describes.

Worked example: a quoted comma

"Rao, Asha" contains a comma, but it is one field because it is in quotes.

Reading the second line of the sample
Line
"Rao, Asha",Pune,12500
  1. Field 1 (quoted)Rao, Asha
  2. Field 2Pune
  3. Field 312500
  4. As JSON, with number detection{"name":"Rao, Asha","city":"Pune","amount":12500}

Reading the result

  • All text (default)"12500"Safe for codes, PIN codes and phone numbers.
  • Detect types12500Numbers, true/false and null, ready for calculations.
  • QuotesCommas, line breaks and "" inside quoted fields.
  • DelimitersComma, semicolon, tab or pipe, detected for you.
  • Uneven rowsLines with too few or too many fields are listed.
  • Excel exportsA byte-order mark at the start is removed.

Converting is the first step. Checking and comparing the result come next.

To validate and format the output, use the JSON formatter. The diff checker compares two exports, and the remove duplicate lines tool cleans a column of values.

Common mistakes

  • Mistake: Splitting CSV at every comma in your own code.

    Instead: Use a real CSV parser so quoted commas survive.

  • Mistake: Turning PIN codes or account numbers into numbers.

    Instead: Keep type detection off, or check leading zeros.

  • Mistake: Opening a semicolon CSV as comma-separated.

    Instead: Let the converter detect the delimiter, or choose it.

Read how we test our calculators, or browse more developer tools.

Frequently asked questions

Is my file uploaded?

No. The CSV is read and converted in your browser. Nothing is sent to a server or saved in the link.

Why does a comma inside a name not split the field?

Fields wrapped in double quotes may contain commas, quotes and line breaks. That is how the CSV standard keeps such values together.

Why are my numbers in quotes?

By default every value stays text, which keeps PIN codes and account numbers exact. Turn on “Detect numbers and true/false” to get real numbers.

My Excel CSV uses semicolons. Will it work?

Yes. The converter detects comma, semicolon, tab and pipe delimiters, or you can choose one.

What happens to rows with missing fields?

Missing fields become empty and extra fields are dropped. The line numbers of such rows are listed so you can check them.

Sources and methodology

The formulas are standard time-value-of-money results. We check every figure against golden values worked out independently, by closed form and by month-by-month simulation; see the methodology.

Written and maintained by Nitin Raturi, a software engineer (about the author). Last reviewed 27 Oct 2026; next review due by . Found an error? Tell us.

Changelog

  • : Initial release. Demand metrics remain unverified.

  • JSON Formatter & Validator

    Check JSON, see the exact line and column of any error, and format or minify it, all inside your browser.

  • Diff Checker

    Compare two texts or code files line by line, inline or side by side, with changed words highlighted.

  • Base64 Encoder & Decoder

    Encode text or files to Base64 and decode it back, with UTF-8 and URL-safe support, entirely in your browser.