How to convert TSV to JSON
To convert TSV to JSON, upload your TSV file, choose JSON as the output format and press Convert. The finished JSON file is ready to save to your phone or computer in seconds, free, with no watermark and no sign-up. Your file is deleted from our server about 30 minutes after the conversion.
This free online converter turns TSV spreadsheet files into JSON in your browser, with no software to install and no watermark. The conversion runs on our server using LibreOffice and pandas, and the result is ready to save to your phone or computer in seconds. Your TSV file is deleted automatically about 30 minutes after the conversion.
Why convert TSV to JSON?
- The standard format for web APIs
- Readable by people and programs
- Works in every programming language
- Opens in: every programming language, browser developer tools and code editor
What to expect from this conversion
- JSON stores a single table, so formatting, colours, charts and formulas are dropped and only the values are kept. Only the first sheet is exported to CSV and TSV; JSON keeps every sheet.
- TSV has no formatting, so the spreadsheet is created with plain cells. Numbers and dates are detected automatically.
TSV vs JSON
| Property | TSV | JSON |
|---|---|---|
| Full name | Tab-Separated Values | JavaScript Object Notation |
| Released | 1980, Universal | 2001, Douglas Crockford (RFC 8259) |
| Family | Spreadsheet | Spreadsheet |
| Opens in | Excel, Google Sheets, databases, Python, R and text editors | every programming language, browser developer tools and code editor |
| Best for | text with many commas; bioinformatics and data science | web and app development; API data |
Steps to convert TSV to JSON
- Drop your TSV file onto the converter, or click to choose it.
- Check that JSON is selected as the target format and adjust the options if you want.
- Press Convert, then save the new JSON file to your device when it finishes.
Tips for the best result
- Check that the first row contains your column names.
- Use XLSX when you need several sheets.
Frequently asked questions
How do I convert TSV to JSON?
Drop your TSV file on the converter, confirm that JSON is the target format and press Convert. When it finishes, press Save to device or download the JSON file. No account or software is needed.
Is the TSV to JSON converter free?
Yes. It is free, with no watermark, no sign-up and no limit on how many files you convert. The site is supported by ads.
What should I know before converting TSV to JSON?
JSON stores a single table, so formatting, colours, charts and formulas are dropped and only the values are kept. Only the first sheet is exported to CSV and TSV; JSON keeps every sheet. TSV has no formatting, so the spreadsheet is created with plain cells. Numbers and dates are detected automatically.
Will formulas and formatting be kept when converting TSV to JSON?
JSON stores a single table, so formatting, colours, charts and formulas are dropped and only the values are kept. Only the first sheet is exported to CSV and TSV; JSON keeps every sheet.
Which programs open JSON files?
JSON files open in every programming language, browser developer tools and code editor.
How large a file can I convert?
Up to 100 MB per file. Files are deleted from the server about 30 minutes after conversion, and no one looks at them.