TSV File Won't Open in Excel — Here's Why and 3 Fast Fixes

Excel opens .csv files automatically — double-click and you are done. But .tsv files do not get the same treatment. Windows does not associate the .tsv extension with Excel by default, and even when you force Excel to open it, the data often lands in a single column instead of separate columns.

There are three reliable fixes. Pick the one that suits your situation: the import wizard if you have Excel open and want to do it properly; the rename trick for a quick workaround; or the browser converter if you want a CSV file you can open with a double-click in the future.

Why Excel Won't Open a TSV File Automatically

Excel's behavior around file extensions is based on Windows file associations. The .csv extension is registered to Excel as a format it can open directly, which is why double-clicking a .csv file launches Excel and populates the data correctly.

The .tsv extension has no such registration. When you double-click a .tsv file, Windows either has no idea what to do with it (and shows an "Open with" prompt) or opens it in Notepad, which shows the raw tab-separated text without any column structure.

Even if you force Excel to open the file — by right-clicking and choosing Open with > Excel — Excel treats it as a text file and dumps the entire row into column A. The tab characters appear as literal text, not as column separators.

The underlying issue is that Excel only parses tab delimiters automatically for files it recognizes as tab-delimited. The workaround is to either tell Excel explicitly that this is a tab-delimited file (via the import wizard) or give it a file it already understands (CSV).

Fix 1: Use the Text Import Wizard

This is the proper solution if you need to keep working in Excel and do not want to install anything.

1. Open Excel first. Do not try to open the .tsv file directly.
2. Go to File > Open > Browse (or Ctrl+O > Browse).
3. In the file browser, change the file type dropdown (bottom right) from "All Excel Files" to "All Files (*.*)" — otherwise .tsv files are hidden.
4. Navigate to your .tsv file and double-click it.
5. The Text Import Wizard appears. In Step 1, choose Delimited and click Next.
6. In Step 2, check Tab under Delimiters (uncheck Comma if it is checked). You should see the data preview show separate columns. Click Next.
7. In Step 3, you can set column formats — this matters if you have leading zeros (set those columns to Text) or dates in specific formats. Click Finish.

Excel populates the data into columns correctly. You can then Save As an .xlsx or .csv file for future use.

Sell Custom Apparel — We Handle Printing & Free Shipping

Fix 2: Rename .tsv to .txt and Open in Excel

Excel opens .txt files using the same Text Import Wizard as above, but the difference is you can trigger the wizard by simply opening the file instead of navigating through File > Open > Browse with the All Files filter. This saves a few steps.

1. In File Explorer, right-click the .tsv file and choose Rename.
2. Change the extension from .tsv to .txt. Windows may warn you about changing the extension — confirm.
3. Double-click the .txt file. Excel launches (if it is the default for .txt) and shows the Text Import Wizard.
4. Follow the same steps as Fix 1: choose Delimited, select Tab, finish.

Note: this modifies your original file's name. If you need to keep the original name, make a copy first. The file contents are unchanged — only the extension is different.

If double-clicking the .txt file opens Notepad instead of Excel, right-click the file and use "Open with > Excel" to trigger the wizard.

Fix 3: Convert to CSV Using the Browser Tool

This is the cleanest long-term fix. Convert the TSV to a proper CSV file once, and it opens in Excel with a double-click from then on — no wizard required.

Use the free TSV to CSV converter: drop your .tsv file, click convert, and download the .csv file. The tool runs in your browser, handles proper RFC 4180 quoting for fields with commas, and produces a CSV that Excel opens correctly every time.

This approach is also the best option if:

• You need to share the file with someone who is not comfortable with the import wizard
• You are importing into a system that only accepts CSV uploads (CRMs, email platforms, databases)
• You want to automate future opens without the wizard step

Related: if your TSV file also needs to become an Excel file (not just CSV), see the guide on converting TSV to Excel directly.

Frequently Asked Questions

Why does Excel show TSV data in one column?

Excel puts all data in one column when it opens a tab-delimited file without using the Text Import Wizard. To fix it, use File > Open > Browse, change the file type filter to All Files, select the .tsv file, and use the wizard to select Tab as the delimiter.

How do I make Excel always open TSV files correctly?

There is no one-click setting. Each time you open a .tsv file in Excel, you need to use the import wizard to specify the Tab delimiter. The workaround is to convert TSV files to CSV first — CSV opens in Excel automatically without any wizard or settings.

Can I open a TSV file in Excel on Mac?

Yes. In Excel for Mac, use File > Import, choose "Text File," select your .tsv file, and pick Tab as the delimiter in the wizard. The process is nearly identical to Windows. Alternatively, Numbers (which comes pre-installed on Mac) often handles TSV files more smoothly than Excel.

My TSV file is opening in Notepad, not Excel — how do I change this?

Right-click the .tsv file in File Explorer, choose "Open with," then select Excel. To make this permanent, check "Always use this app." Note: this just changes what launches — you will still need the Text Import Wizard to get the data into columns correctly. The fastest permanent fix is to convert the TSV to CSV first, which opens in Excel with no extra steps.