Developer Data

CSV to JSON

Input

name,address,age
Ada,"12 High St, London",36
Bram,"Prinsengracht 1",41

What to do

Output

[
  {
    "name": "Ada",
    "address": "12 High St, London",
    "age": "36"
  },
  {
    "name": "Bram",
    "address": "Prinsengracht 1",
    "age": "41"
  }
]

Processed in your browser · nothing is uploaded

Local · RFC 4180, not a comma split

Converts CSV with a header row into an array of objects, parsing properly rather than splitting on commas — so quoted fields containing commas, quotes and line breaks all survive.

How to use the csv to json

1 Paste your input. The result appears immediately.

2 Pick the operation you want.

3 Copy the result, or save it as a file.

Splitting on commas is the mistake almost every quick script makes, and it fails on the first address in the file. Real CSV, as described in RFC 4180, allows a field to be wrapped in double quotes, and inside those quotes a comma is data, a doubled quote is one literal quote, and even a line break is allowed. That is why a spreadsheet export with addresses or free-text notes turns to nonsense under a naive parser. This handles all three. It does not guess types — every value comes out as a string, because a CSV cell has no type information and guessing turns leading-zero product codes into integers and loses the zeros.

Questions

Why not just split on commas? −

Because a quoted field can contain commas, quotes and line breaks. The first address in your file will break a naive split.

Does it convert numbers to numbers? +

Can it use a semicolon or tab? +

What if my CSV has no header row? +

Is my data sent anywhere? +

Sources

RFC 4180 — common format for CSV files

Was this tool any good?

INTERNAL SIGNAL ONLY · WE USE IT TO FIND TOOLS WORTH REBUILDING