CSV to JSON Converter
Paste CSV — or copy cells straight out of a spreadsheet — and get a JSON array of objects. The parser handles quoted fields containing commas and newlines, which naive splitting gets wrong.
How to use it
- Paste your CSV, or copy a range directly from Excel or Google Sheets and paste it here.
- If you pasted from a spreadsheet, set the delimiter to Tab — that is what copied cells actually use.
- Leave First row is a header ticked so column names become object keys.
- Click Convert to JSON.
Proper quote handling
The naive approach of splitting each line on commas breaks the moment a value contains one. A row like 1,"Smith, Ada",London has three fields, not four, and only a real parser gets that right. This tool tracks quoted state character by character, correctly handling commas inside quotes and escaped double quotes written as "".
Numeric conversion, and when to turn it off
With Convert numeric values enabled, a cell containing 42 becomes the number 42 rather than the string "42", which is usually what you want for calculations. Turn it off when your data contains identifiers that merely look numeric — postal codes, phone numbers, product SKUs, or account numbers. Converting those to numbers destroys leading zeros, so 01234 silently becomes 1234. This is the same bug that mangles gene names and postcodes in spreadsheets everywhere.