CSV to JSON Converter
Turn spreadsheet exports into clean JSON objects.
CSV
JSON
About the CSV to JSON converter
Paste a CSV export and get back a JSON array where each row becomes an object keyed by the header row. It is the fastest way to get a spreadsheet into a shape your code can work with.
The parser follows RFC 4180, so quoted fields containing commas, quotes and line breaks come through intact rather than shredding your rows.
Delimiter detection
Left on automatic, the converter samples the first few lines and picks whichever of comma, semicolon, tab or pipe appears most often. That handles the semicolon-separated files European versions of Excel produce without you having to think about it.
If the guess is wrong — which happens when your data itself is full of semicolons — pick the delimiter explicitly.
Type detection
With type detection on, `42` becomes the number 42, and `true` becomes a boolean. Everything else stays a string.
Switch it off when you need values preserved exactly as written. Product codes like `007` and phone numbers with leading plus signs are the usual reason.
Headers and duplicate columns
The first row supplies the object keys. Blank header cells are filled in as `column_1`, `column_2` and so on so no field is silently lost.
If your file has no header row at all, turn the option off and every column will be numbered instead.
Frequently asked questions
My file has a weird character at the start of the first column name.
That is a UTF-8 byte order mark, which Excel adds when it saves. It is stripped automatically here.
Can I convert a TSV file?
Yes. Choose Tab as the delimiter, or leave detection on — tab-separated files are recognised.
What happens to empty cells?
They become empty strings. That keeps every object the same shape, which is usually what downstream code expects.
Does the file leave my computer?
No. Both pasting and uploading are handled locally in the browser.