How to convert CSV to JSON
- Paste your CSV into the left box, or click Open File to load a .csv file.
- The JSON appears on the right as you type. Adjust the separator or header setting if needed.
- Click Copy or Download to save the JSON.
What the converter does
CSV (comma-separated values) is the plain table format that spreadsheets and databases export. JSON is the format most websites, apps and APIs expect. This tool reads each row of the CSV and writes it as a JSON object, using the header row for the key names:
name,age and Ana,34 become [{ "name": "Ana", "age": 34 }]
Options explained
- Separator. Files from some countries and programs use semicolons or tabs instead of commas. The tool detects this, and you can set it yourself.
- First row is the header. Untick this if your file has no column names. Each row then becomes a simple list of values.
- Detect numbers and true/false. Turns
34into a number andtrueinto a real true value. Untick it to keep everything as text, which is safer for ZIP codes, phone numbers and IDs with leading zeros. - Minify. Puts the JSON on one line to make the file smaller.
Handles real-world CSV
Values wrapped in quote marks, commas and line breaks inside a value, doubled quote marks, empty cells and Excel's hidden byte order mark are all read correctly. Columns with the same name get a number added so no data is lost.
Going the other way? Use JSON to CSV. Starting from a spreadsheet file? Excel to CSV reads .xlsx files.
Your data stays on your device
The conversion runs entirely in your web browser. Nothing you paste or open is sent to a server, so it is safe to use with customer lists, exports and other private data. There is no sign-up and no size limit beyond what your device can handle.
Frequently asked questions
How do I convert CSV to JSON?
Paste the CSV or open the file. The JSON appears instantly, ready to copy or download.
Can I convert an Excel file to JSON?
Yes. Save or export the sheet as CSV first, or use the Excel to CSV tool, then paste the result here.
Why are my numbers in quote marks?
If “Detect numbers” is unticked, every value is kept as text. Tick it to get real numbers.
Is my data uploaded?
No. The conversion runs in your browser and nothing is sent to a server.