CSV is the simplest way to move table data around, and JSON is what most web APIs, apps and scripts expect. This tool turns one into the other. Paste CSV or upload a file and the JSON updates as you type.
It reads CSV the way RFC 4180 describes it, so quoted fields, delimiters inside quotes, line breaks inside a cell and doubled quotes all come through correctly. The delimiter is detected for you, or you can set it. Output can be an array of objects, using the first row as keys, or an array of arrays. Everything runs in your browser and nothing is uploaded.
Paste your CSV or upload a file. The JSON appears as you type. Choose whether the first row holds the column names, pick array of objects or array of arrays, then copy the result or download it as a .json file.
Comma, semicolon, tab and pipe. Auto-detect looks at the first rows and picks the one that gives the same number of columns on most lines. If it guesses wrong, choose the delimiter yourself.
Yes. It follows RFC 4180. A field in double quotes can contain the delimiter, line breaks and quotes written as two double quotes (""). Blank lines are skipped.
When it is on, values become real JSON types: numbers become numbers, true and false become booleans, and null or an empty cell becomes null. Turn it off to keep every value as a string. Numbers with leading zeros, such as 007, and integers longer than 15 digits stay strings so no digits are lost.
With objects, missing values become null and extra values get a key such as column_4. With arrays, each row keeps the fields it has. The status line tells you how many rows were uneven.
Yes. The conversion runs in the background so the page stays responsive. For very large results the preview shows only the start, while Copy and Download use the whole result. Files up to 100 MB are accepted, depending on your device's memory.
No. Everything runs in your browser and nothing leaves your device.