Developer Tools
CSV to JSON Converter
Convert spreadsheet data into JSON for APIs, apps and databases. Paste CSV or open a file; the converter detects the delimiter, handles quoted fields and converts numbers automatically.
Convert CSV to JSON
Paste CSV (the first row should contain column names) or open a .csv file.
How to Convert CSV to JSON
- Paste CSV data, or press Open File to load a .csv or .tsv file. To convert an Excel or Google Sheets table, copy the cells and paste them – they are pasted as tab-separated text, which is detected automatically.
- Choose Array of objects to use the first row as keys, or Array of arrays to keep every row as a list.
- Press Convert to JSON, then copy or download the result.
Example
This CSV:
name,age,city
Ayesha,29,Lahore
Bilal,34,Karachibecomes:
[
{ "name": "Ayesha", "age": 29, "city": "Lahore" },
{ "name": "Bilal", "age": 34, "city": "Karachi" }
]Handling Real-World CSV
- Commas inside values are handled when the value is wrapped in double quotes, such as
"Lahore, Pakistan". - Semicolon-separated files, common in European Excel exports, are detected automatically.
- Number conversion: with the option ticked,
29becomes the number 29 andtruebecomes a boolean. Untick it to keep every value as text, which is safer for phone numbers, postcodes and IDs with leading zeros. - Empty lines are skipped, and rows with a different number of columns are reported as warnings.
Parsing uses Papa Parse, a widely used open-source CSV library.
Privacy
Your data is converted in your browser and never uploaded, so it is safe for customer lists and business data.
Frequently Asked Questions
How do I convert an Excel file to JSON?
Select the cells in Excel or Google Sheets, copy them and paste them here. Alternatively, save the sheet as CSV and open the file with the Open File button.
Why did my phone numbers lose their leading zero?
Number conversion turned them into numbers. Untick "Convert numbers & true/false" to keep all values as text.
Can I convert CSV without a header row?
Yes. Choose "Array of arrays" and each row is output as a list of values.
Is my data uploaded?
No. Conversion runs entirely in your browser.