Does the converter handle quoted fields with commas and line breaks?

Yes. It follows the CSV standard (RFC 4180): fields in double quotes can contain the delimiter, line breaks and doubled quotes ("").

How are numbers and booleans detected?

With Detect numbers & booleans on, values like 42, 3.5, true and false become JSON numbers and booleans, and empty cells become null. Values that would lose information stay strings — for example 007 or very long IDs.

What if my CSV uses semicolons or tabs?

The delimiter is detected automatically. You can also choose comma, semicolon, tab or pipe yourself.

What if my file has no header row?

Turn off First row is header and each row becomes an array of values instead of an object.

CSV to JSON Converter

Convert a CSV or spreadsheet export into a JSON array of objects.

CSV input

id,name,city,price,in_stock,notes
1,Espresso machine,Berlin,249.90,true,"Includes milk frother, 1.5 L tank"
2,Coffee grinder,Paris,89.5,false,
3,"Beans ""Blue Mountain""",Kingston,34,true,"Ships in
2 days"

JSON output

[
  {
    "id": 1,
    "name": "Espresso machine",
    "city": "Berlin",
    "price": 249.9,
    "in_stock": true,
    "notes": "Includes milk frother, 1.5 L tank"
  },
  {
    "id": 2,
    "name": "Coffee grinder",
    "city": "Paris",
    "price": 89.5,
    "in_stock": false,
    "notes": null
  },
  {
    "id": 3,
    "name": "Beans \"Blue Mountain\"",
    "city": "Kingston",
    "price": 34,
    "in_stock": true,
    "notes": "Ships in\n2 days"
  }
]

[
  {
    "id": 1,
    "name": "Espresso machine",
    "city": "Berlin",
    "price": 249.9,
    "in_stock": true,
    "notes": "Includes milk frother, 1.5 L tank"
  },
  {
    "id": 2,
    "name": "Coffee grinder",
    "city": "Paris",
    "price": 89.5,
    "in_stock": false,
    "notes": null
  },
  {
    "id": 3,
    "name": "Beans \"Blue Mountain\"",
    "city": "Kingston",
    "price": 34,
    "in_stock": true,
    "notes": "Ships in\n2 days"
  }
]

Detected delimiter: Comma (,)

How to convert CSV to JSON

Paste CSV on the left, or open or drop a .csv or .tsv file.
The JSON appears on the right. The delimiter is detected automatically — commas, semicolons, tabs or pipes.
Choose whether the first row holds column names and whether numbers are detected.
Copy the JSON or download it as a .json file.

From rows to JSON objects

With a header row, every following row becomes an object whose keys are the column names. Values are converted carefully: numbers and booleans become real JSON types, while values that would lose information — like the ZIP code 007 or a 20-digit order number — stay strings.

CSV

name,age,city
Ada,36,"London, UK"

JSON

[
  {
    "name": "Ada",
    "age": 36,
    "city": "London, UK"
  }
]

Features

Full CSV support: quoted fields with commas, "" escaped quotes and line breaks.
Automatic delimiter detection for comma, semicolon, tab and pipe files.
Duplicate or empty column names are renamed so no data is overwritten.
Clear errors with the line number, for example for an unclosed quote.

Use cases

Turn a spreadsheet export into test data or fixtures for an app.
Prepare CSV data for an API that expects JSON.
Convert database or analytics exports for use in JavaScript.

Related tools

Need a spreadsheet again? JSON to CSV converts back. Tidy or sort the result with the JSON formatter, check it with the JSON validator, or turn config data from YAML into JSON with YAML to JSON.

Frequently asked questions

Does the converter handle quoted fields with commas and line breaks?: Yes. It follows the CSV standard (RFC 4180): fields in double quotes can contain the delimiter, line breaks and doubled quotes ("").
How are numbers and booleans detected?: With Detect numbers & booleans on, values like 42, 3.5, true and false become JSON numbers and booleans, and empty cells become null. Values that would lose information stay strings — for example 007 or very long IDs.
What if my CSV uses semicolons or tabs?: The delimiter is detected automatically. You can also choose comma, semicolon, tab or pipe yourself.
What if my file has no header row?: Turn off First row is header and each row becomes an array of values instead of an object.