CSV to JSON Converter

Paste CSV, get a JSON array. With "First row is headers" on, the header row becomes the keys and every line after it becomes an object. Turn it off and you get an array of arrays instead.

The delimiter is detected for you. After a conversion, the Auto option in the dropdown names what the parser picked: comma, semicolon, tab, or pipe. Wrong guess? Pick one yourself.

A two-row product export goes in:

sku,name,price,in_stock,zip
A-100,"Desk lamp, brass",24.99,TRUE,02134
A-101,Monitor arm,89,false,

And this comes out:

[
  {
    "sku": "A-100",
    "name": "Desk lamp, brass",
    "price": 24.99,
    "in_stock": true,
    "zip": 2134
  },
  {
    "sku": "A-101",
    "name": "Monitor arm",
    "price": 89,
    "in_stock": false,
    "zip": null
  }
]

Look at the zip code. We'll get to that.

Common use cases

Turning the spreadsheet your PM keeps in Google Sheets into seed data or test fixtures. Export as CSV, convert, commit.

Feeding a chart library or a frontend table. Most of them want an array of objects, which is exactly the shape you get here.

Checking what a CSV export really contains before you write the importer. Ragged rows and mystery columns are hard to miss once it's JSON.

Things to know

"Infer types" is on by default. Plain numbers become numbers, true and false (or TRUE and FALSE) become booleans, and empty cells become null. "yes" and "True" stay strings. So does anything that isn't a plain number, like $5 or 0x1F.

Inference costs you leading zeros. ZIP codes, phone numbers, and IDs like 007 lose them. Integers too big for JavaScript to hold exactly stay strings, so they keep every digit. Date-times that end in Z or an offset get rewritten as UTC: 2024-03-27T10:00:00+02:00 comes out as 2024-03-27T08:00:00.000Z. Plain dates are left alone. If any of that bothers you, untick the box and every value stays exactly as written.

Ragged rows don't break anything. Short rows get the missing keys filled with null, or "" with inference off. Long rows keep their spare cells in an _extra array, and a note next to the controls tells you how many rows overflowed.

Duplicate headers become name, name_1, name_2. Quoted cells can hold commas, line breaks, and doubled quotes. A quote that never closes stops the conversion with "Quoted field unterminated", which beats quietly swallowing the rest of your file.

Privacy

PapaParse runs in your browser tab. The customer export you just pasted stays on your machine, which is where it should have stayed all along. After one visit, it works offline too.