Convert a CSV file without uploading it
Most online converters send your file to a server. This one does not. Your browser reads the file, converts it, and gives you the JSON to download. That matters for customer lists, exports from internal systems and anything else you would rather keep on your own computer.
How to use it
- Click Open a CSV file, or drop the file on the box. Text files with the .csv, .tsv or .txt extension all work.
- Look at the table preview to check that the columns are split as you expect. If they are not, change the delimiter.
- Click Download JSON.
The table preview
The first 50 rows are shown as a table with the header at the top. It is the quickest way to see a wrong delimiter, a header that is missing, or rows that are too short or too long. Problems are listed under the input as well.
Large files
The browser does the work, so the limit is the memory of your device. Files of several megabytes are fine on a normal computer. For very large files, with millions of rows, use a command line tool such as csvkit or Miller, which the CSV vs JSON guide shows, or split the file first.
Character encoding
The file is read as UTF-8, which is what modern programs export. A byte order mark at the start is removed. If accents look wrong, save the file from your spreadsheet as CSV UTF-8 and open it again.
Options
You can choose the delimiter, the header row, type detection, empty value handling, nested keys and the indent. Keyed objects, columns and JSON Lines are in the main CSV to JSON converter and the CSV to JSON array page. To make a CSV from JSON, use JSON to CSV.