Tab Delimited File to Excel Converter

Turn tab-separated data into a real spreadsheet

A TSV file is just plain text with a tab character between each value. Open one straight in Excel and you're gambling. Sometimes the columns split correctly, sometimes every row piles into a single cell, and sometimes a product code like 00815 quietly loses its leading zeros. This converter takes the guessing out of it. Give it your tab-separated data and it writes a proper .xlsx file with each value sitting in its own cell.

There are two ways in. Paste the data into the text box for a quick one-off, or upload a .tsv file up to 20 MB. Either route gives you the same clean spreadsheet, columns sized to fit, ready to sort, filter, or drop a formula onto.

What actually happens to your data

The conversion runs on PhpSpreadsheet, the open-source library behind most of the .xlsx files PHP applications generate. It reads your input one line at a time, splits each line on the tab character, and drops the pieces into consecutive cells. Blank lines get thrown out along the way, so a file with a few empty rows at the bottom won't leave you with ghost rows in Excel.

Every cell goes in with its type chosen on purpose. A value that reads as a plain number, like 4200 or 19.99, is stored as a number you can total right away. Everything else is written as literal text. That second half matters more than it sounds. Because those cells are locked to text, a value that starts with an equals sign or a plus or minus is never mistaken for a formula, so you won't open the file to a screen of #NAME? errors or a sheet that ran something you never asked it to.

The parser also tidies up quotes as it goes. If a value came wrapped in the extra quotation marks that some exports add around text, those collapse back to a single straight quote, so you don't inherit stray quote characters bracketing your data. Once the rows are placed, the tool widens each column to fit its longest value and saves everything as a single-sheet .xlsx. The file comes back with a generated name like a1b2c3d4.xlsx, so give it a name you'll recognise before you file it away.

Leading zeros stay where they belong

This is the detail a plain Excel import gets wrong most often. Any value that begins with a zero is kept as text instead of being crunched into a number. A ZIP code of 07030, a sort code of 001, an SKU of 00815 all land intact rather than collapsing to 7030, 1, and 815. If you've ever watched a column of IDs get silently mangled by a spreadsheet, you know why that's worth having.

Where it struggles, honestly

The parser splits on line breaks and tabs, and that plain approach has edges. A few things worth knowing before you convert:

• A line break inside a single field splits that record into two rows. Multi-line notes or addresses wrapped across lines are the usual culprit, so check those rows afterwards.
• Dates aren't turned into Excel date values. A cell like 2024-03-15 arrives as text, which reads fine but means you'll format the column as a date if you want to do date math on it.
• Numbers written with thousands separators or a comma decimal, like 1,250 or 3,14, come in as text rather than numbers. Strip the separators first if you need to calculate with them.

One more limit worth stating plainly: only the tab character counts as a delimiter here. If your file is really comma- or semicolon-separated, this isn't the converter for it.

Working with commas instead of tabs? The CSV to Excel converter does the identical job for .csv files, and it keeps leading zeros the same way.

A real example

Say a survey platform hands you a 5,000-row export as a .tsv, and one column holds respondent IDs that start with a zero. Paste it in or upload the file, press convert, and a second or two later you've got an .xlsx where the IDs still read 0042 instead of 42, the numeric answers are ready to average, and the free-text comments sit quietly as text. The conversion is the fast part. Deciding what to do with 5,000 opinions is the slow one.

Paste or upload, whichever's faster

For a handful of rows copied out of a terminal or a database client, pasting beats saving a file first. The two inputs are mutually exclusive by design: start typing in the box and the file picker switches off, choose a file and the box greys out, so there's never a question of which one gets converted. Both paths run through the exact same code.

Do you need Excel installed?

No. The .xlsx you download is the standard Open XML format, so it opens in Google Sheets, LibreOffice Calc, Numbers on a Mac, and every current version of Excel. Nothing about the file is tied to one program.

When a different tool fits better

And if your data is JSON rather than delimited text, the JSON to Excel converter flattens it into rows and columns without the hand-editing.

Need to go the other direction and turn a .csv into tab-separated text first? The CSV to TSV converter handles that.

One note on privacy. If you paste your data, it's never written to disk. It's parsed in memory and the only file saved is the .xlsx you download. If you upload a .tsv, that file is deleted the moment the conversion finishes. Nothing is stored, read, or handed to anyone else.