TSV to JSON converter
To convert TSV to JSON, drop your TSV file in the box below. It converts straight away; press Download to save the JSON. It all happens in your browser, so your file stays on your device.
Convert to
Converted on this device, never uploaded
What changes
| TSV to JSON | What happens |
|---|---|
| Shape | An array of objects, keys from the first row |
| Numbers | 12 and 4.50 become numbers; 007, +46 and 15+ digit IDs stay text |
| Quotes | Quoted cells, as Excel writes them, are read correctly |
| Empty cells | Empty strings |
| Encoding | UTF-8, UTF-16 or Windows-1252 |
How to convert TSV to JSON
- Add your TSV. Drop the file in the box, or click to choose it. It becomes JSON straight away.
- Check the result. Look at the preview. The delimiter and value types are set for you; change them if needed.
- Download. Press Download to save the JSON.
Why JSON
Turn tab-separated data, such as a database or spreadsheet export, into JSON: one object per row, keyed by the header.
Questions
Values with a leading zero (007), a plus sign, or more than 15 digits stay text so nothing changes: ZIP codes, phone numbers and long IDs keep every digit.
The second becomes name_2, so no value is lost.
Yes. Turn off “Numbers and true/false as values”.
No. The conversion happens right in your browser, so your file stays on your device. There is no account to make, either.