CSV to JSON
Turn CSV, TSV or Excel sheets into JSON. Headers become keys, numbers are typed and dotted headers rebuild nested objects.
JSON
The JSON appears here as you paste CSV or open a .csv, .tsv or Excel file.
Ctrl+F search · Ctrl+↵ copy result · Ctrl+Shift+F result to input · Esc then Tab leaves the editor
How to convert CSV to JSON
- Paste CSV, or open a .csv, .tsv or Excel .xlsx file. For a workbook, pick the sheet.
- The separator is detected. Check the options: header row, number detection, nested objects and what empty cells become.
- Copy or download the JSON, or send it to JSON Formatter or another tool.
Frequently asked questionsUseful details
4 answers +
Is my file uploaded?
No. CSV and Excel files are read in your browser, and the JSON is made on your device.
What if a value contains a comma or a line break?
Put it in double quotes, as spreadsheet apps do when they save CSV: "Turing, Alan". Quotes inside a quoted value are written twice ("").
How do I get nested JSON?
Name the columns with dots, such as address.city and address.zip, and keep Dotted headers make nested objects ticked. Numbered parts such as tags.0 and tags.1 become a list.
Why does it say some rows have a different number of cells?
Those rows have more or fewer values than the header row, often because of an unquoted comma inside a value. Missing cells are treated as empty and extra cells get keys like column5.
More help
Guides, common conversions and useful next steps.
Continue with your result
Use the action beside a finished result to send it directly, or open another tool: