CSV to JSON

Turn CSV into JSON in your browser, the file is never uploaded

First row is the headerNumbers, true / false and nullTrim spacesSkip empty rows

CSV

id,name,email,age,isActive,zip
1,Ada Lovelace,[email protected],36,true,01234
2,"Hopper, Grace",[email protected],85,false,
3,Alan Turing,"[email protected]",41,true,90210

3 rows · comma delimited

Drop a CSV file here

JSON

[
  {
    "id": 1,
    "name": "Ada Lovelace",
    "email": "[email protected]",
    "age": 36,
    "isActive": true,
    "zip": "01234"
  },
  {
    "id": 2,
    "name": "Hopper, Grace",
    "email": "[email protected]",
    "age": 85,
    "isActive": false,
    "zip": null
  },
  {
    "id": 3,
    "name": "Alan Turing",
    "email": "[email protected]",
    "age": 41,
    "isActive": true,
    "zip": 90210
  }
]

[
  {
    "id": 1,
    "name": "Ada Lovelace",
    "email": "ada@example.com",
    "age": 36,
    "isActive": true,
    "zip": "01234"
  },
  {
    "id": 2,
    "name": "Hopper, Grace",
    "email": "grace@example.com",
    "age": 85,
    "isActive": false,
    "zip": null
  },
  {
    "id": 3,
    "name": "Alan Turing",
    "email": "alan@example.com",
    "age": 41,
    "isActive": true,
    "zip": 90210
  }
]

Preview

id	name	email	age	isActive	zip
1	Ada Lovelace	[email protected]	36	true	01234
2	Hopper, Grace	[email protected]	85	false
3	Alan Turing	[email protected]	41	true	90210

Numbers with a leading zero (007, ZIP codes) and numbers longer than 15 digits stay text, so nothing is lost.

How to convert CSV to JSON

Paste or type your CSV, or drop a CSV file.
Check the delimiter (guessed for you: comma, semicolon, tab or pipe) and whether the first row is the header.
Choose an array of objects (keyed by the header) or an array of arrays, and whether numbers, true, false and empty fields are read as such.
Check the rows in the table, then copy or download the JSON.

Questions

Are numbers kept as numbers?

Yes, when you ask: numbers, true, false and empty fields (null) are read as such. Numbers with a leading zero, such as 007 or a ZIP code, stay text so nothing is lost.

What if my CSV uses semicolons?

The delimiter is guessed from the text, so CSV from Excel in Europe (semicolons) or tab separated values work too; you can also pick it.

What happens to empty or repeated column names?

Empty names become column_1, column_2…, repeated names get _2, _3, and fields past the header become column_N, so no value is lost.

Is my data uploaded?

No. It's converted by your browser as you type; nothing is sent anywhere.