How do I convert a CSV file to JSON?
Paste your CSV into FixDoks's CSV to JSON converter, or open a file, and click Convert. It auto-detects commas, semicolons, tabs or pipes, uses the header row as keys, and turns numbers and true/false into real values. The result is a JSON array of objects, ready to copy or download, all in your browser.
CSV to JSON at a glance
| Input | CSV, TSV or Excel export, up to 50 MB |
|---|---|
| Output | JSON array of objects |
| Processing | In your browser; your files are not uploaded |
| Price | Free |
| Works on | Chrome, Edge, Safari and Firefox on Windows, Mac, Android and iPhone |
How to use CSV to JSON Converter
- Paste CSV text or click Open CSV file. Exports from Excel and Google Sheets work.
- Leave the delimiter on Auto-detect, or pick comma, semicolon, tab or pipe.
- Choose whether the first row is a header and whether to convert numbers and true/false.
- Click Convert to JSON, then copy or download the .json file.
Convert spreadsheets to JSON
CSV (comma separated values) is how spreadsheets, CRMs and banks export data. JSON is what web apps, APIs and databases like MongoDB expect. This converter turns each CSV row into a JSON object, using the header row for the keys:
| CSV | JSON |
|---|---|
name,city,age | [{"name":"Asha","city":"Pune","age":29}, |
Handles real-world CSV
Simple converters split on every comma and break on real files. FixDoks follows the CSV standard (RFC 4180):
- Fields in double quotes can contain commas, such as "Sector 5, Salt Lake".
- Quotes inside a field are written as two double quotes ("") and come out as one.
- Fields in quotes can contain line breaks, which is common in address and comment columns.
- The delimiter is detected automatically. Excel in many European locales saves CSV with semicolons, and TSV files use tabs.
- A byte order mark at the start of the file, added by Excel's "CSV UTF-8" option, is removed.
- Empty header cells get names like column3, and repeated headers get a suffix (name, name_2) so no data is lost.
Options
Convert numbers and true/false turns "29" into the number 29 and "true" into a boolean. Numbers that start with zero, such as PIN codes like 012345 or product codes, stay as text so the leading zero is kept. Untick the option to keep every value as a string.
First row is the header: untick it if your file has no header row. You then get an array of arrays. Output arrays instead of objects gives the same compact array-of-arrays layout even when there is a header, skipping the header row.
From Excel to JSON
In Excel, choose File, Save As, and pick "CSV UTF-8 (Comma delimited)". In Google Sheets, choose File, Download, Comma separated values. Open that file here. Using the UTF-8 option keeps Hindi, Tamil and other non-English text readable. You can also select cells in a spreadsheet, copy them and paste straight into the box: copied cells are tab separated, which auto-detect picks up.
After converting, use the JSON formatter to explore or minify the result. To go back from JSON to a spreadsheet, use JSON to CSV.
The file is read and converted in your browser, so exports that contain customer or financial data are never uploaded. Files up to 50 MB can be opened.
Checking the result
The status line shows how many rows were converted. If the number looks wrong, the usual cause is a quote that was opened but never closed in the CSV, which makes the rest of the file one long field. Open the CSV in a text editor, search for that row and fix the quote.