What the CSV to JSON does
CSV to JSON turns spreadsheet data into JSON for apps, APIs, databases and code. Paste CSV, or copy cells straight from Excel or Google Sheets, and the separator is detected: commas, semicolons, tabs or pipes. Use the first row as keys to get a list of objects, or keep plain rows. Numbers and true/false become real JSON values, while codes such as 007, PIN codes and long ID numbers stay as text so nothing is lost.
How to use it
- Paste CSV or spreadsheet cells on the left.
- Check the separator and whether the first row is the header.
- Choose a list of objects or a list of rows, and whether to convert numbers.
- Copy or download the JSON.
Example
The sample with columns name, city, age and member gives 3 records. The second becomes { "name": "Rao, Ravi", "city": "Hyderabad", "age": 34, "member": false }, with the comma inside the quoted name kept and the age turned into a number.
Getting clean JSON
Quoted cells may contain commas, quotes (written as "") and line breaks, as in proper CSV. Empty header cells become column_1 and so on, and repeated headers get _2 added so no data is overwritten.
Numbers are only converted when they look like plain numbers. Values with leading zeros, more than 15 digits, spaces or symbols, such as phone numbers, Aadhaar numbers and product codes, stay as text, because turning them into numbers would change them.
Questions people ask
Is my data uploaded?
No. The conversion happens in your browser as you type, so data such as customer lists or keys never leaves your device.
Can I paste straight from Excel?
Yes. Copied cells arrive separated by tabs, which are detected automatically.
What if the import says a quote is never closed?
A cell starts with " but has no closing quote. Check the last rows for a stray quote mark.
How large a file can it handle?
Several megabytes is fine. For very large files, split them into parts.