Convert CSV to JSON
Turn a spreadsheet exported as CSV into JSON ready for your code or API.
Everything runs in your browser. Nothing you type or paste is sent to a server.
How to convert CSV to JSON
- 1
Paste the CSV or open the file.
- 2
Tell us whether the first row holds headers.
- 3
Copy or download the JSON.
About this tool
We detect whether the separator is a comma, semicolon, tab or pipe. Quoted fields with commas or line breaks are read correctly.
With “Detect numbers and booleans”, values like 42 or true become JSON numbers and booleans.
Frequently asked questions
What if there are no headers?
Turn the option off to get an array of arrays, one per row.
Are leading zeros kept?
Values like “007” stay as text so the zeros aren't lost.