TSV to ODS
Convert to
Tools for this file
Your files never leave your device.
Plain numbers like 1234 or -12.5 become real numbers you can sum. Dates, codes like 007 and numbers with commas or symbols stay text, exactly as written.
Questions about TSV to ODS
How does TSV to ODS work?
TSV to ODS turns a tab-separated file into an OpenDocument spreadsheet for LibreOffice Calc and other apps that read ODS. Everything goes on one sheet named Sheet1. Plain decimal numbers become numbers; dates, codes with leading zeros and long numbers are kept as text exactly as written in the TSV.
Which text encodings can the TSV be in?
UTF-8 with or without a byte order mark, or UTF-16 with a byte order mark. Anything that isn't valid UTF-8 is read as Windows-1252. In the ODS the text is stored as Unicode, so there is no encoding to pick when you open it.
Will a value like 0042 stay 0042?
Yes. Numbers with leading zeros are kept as text, so postcodes, product codes and IDs look exactly as they did in the TSV.
Can several TSVs become sheets in one ODS?
No. Each TSV becomes its own ODS file with one sheet called Sheet1. You can download the files one by one or together as a ZIP.