SmartQueryTools

Convert Encoding of TSV Files Online

Detect and convert the character encoding of TSV files directly in your browser. Switch between UTF-8, Latin-1, Windows-1252, and more — no upload required.

How to convert Encoding of TSV files

  1. Drop your file. The tool reads the raw bytes and picks an encoding: the one named by a byte order mark if there is one, otherwise UTF-8 if the bytes are valid UTF-8, otherwise Windows-1252.
  2. Check the detected encoding and the preview of the first 2,000 characters. Accented letters and symbols should look right.
  3. If they do not, choose another source encoding: UTF-8, Latin-1 / Windows-1252, ISO-8859-15, UTF-16 LE or UTF-16 BE. The preview updates as soon as you change it.
  4. Click Convert & Download UTF-8. The file is saved with _utf8 added to its name.

Your file is processed locally in your browser and is never uploaded. The free limit is 50 MB per file; larger files work if your device has the memory for them.

Worked example

A cheese wholesaler's supplier list was exported from an old Windows system in the Windows-1252 encoding. Read as UTF-8, every accented letter and the euro sign show up as the � replacement symbol.

Input (TSV)

supplier	city	contact	min_order
K�serei Br�ndli	Z�rich	Zo� M�ller	�250
Fromagerie B�rard	Besan�on	H�l�ne Roux	�400
Caseificio Rossi	Parma	Luca Bianchi	�180

Settings

  • Detected encoding: Latin-1 / Windows-1252 (the bytes are not valid UTF-8)
  • Source encoding: Latin-1 / Windows-1252, left as detected
  • Output: UTF-8, the only output option

Result

suppliercitycontactmin_order
Käserei BrändliZürichZoë Müller€250
Fromagerie BérardBesançonHélène Roux€400
Caseificio RossiParmaLuca Bianchi€180

Windows-1252 stores each of these characters as a single byte that is not valid UTF-8 on its own, which is why a UTF-8 reader shows �. Decoding with the right source encoding recovers them, and the file is saved as UTF-8. The euro sign is a useful test: Windows-1252 stores it as byte 0x80 and ISO-8859-15 as 0xA4, so the wrong choice between those two shows a different symbol.

Frequently Asked Questions

Which encodings can I convert to?

Only UTF-8. You can read the file as any of the six listed encodings, but the download is always UTF-8, which every current database, language and spreadsheet can read.

Why is there no separate ISO-8859-1 option?

Browsers treat the label ISO-8859-1 as Windows-1252, following the web Encoding Standard, so the two would always give the same result. They are offered as one option, Latin-1 / Windows-1252. Windows-1252 only adds printable characters in bytes 0x80 to 0x9F, such as €, curly quotes and dashes. ISO-8859-15 is a separate table and does change some characters.

What if no source encoding makes the preview look right?

The text may have been damaged before it reached you. A UTF-8 file that was opened and saved as Windows-1252 shows sequences like Zürich in every encoding. Changing the encoding again cannot undo that. Fix the common sequences with Find and Replace, or export the data again from the source.

Related Tools