All conversions

TSV → XLSX

Convert TSV to Excel (XLSX)

Opening a TSV in Excel is the fastest way to damage it: identifiers become dates, leading zeros disappear, and long numbers turn into scientific notation. Writing the workbook directly skips the import guess entirely — every cell is written as the text it already was.

How to do it

  1. Open the .tsv here first, not in Excel. This is the whole point.
  2. Fix anything the review panel flags. It is easier now than inside a workbook.
  3. Export as XLSX. The file downloads as a genuine workbook that Excel, LibreOffice and Google Sheets all open natively.

Do it in the editor

What usually goes wrong

  • The date that used to be a code

    A key like 03-04 becomes 3 April the moment Excel imports it, and no undo brings the original back. Writing the workbook here never runs that conversion.

  • Leading zeros

    Postcodes and part numbers keep theirs, because every cell is written as text rather than as a number Excel is free to reformat.

Every cell arrives as text. If a column really should be numbers or dates, set that inside the spreadsheet afterwards, where you can see what it does to your data before you save.