To open a TSV file in Excel for Microsoft 365 on Windows, double-click the file or use Excel’s File > Open > Browse command. If you need to control how Excel reads the columns, choose Data > From Text/CSV, set the delimiter to Tab, check the preview, and select Load. A TSV (tab-separated values) file stores data as plain text, with tabs between fields; you do not need a special add-in to open one.
Opening a TSV puts its rows and columns into a worksheet so you can sort, filter, format, and analyze the data. Before importing important information, consider whether fields such as product codes, postal codes, or dates must retain their original text exactly. Excel may automatically interpret some values, so the import method and preview matter.
What You’ll Need
- A TSV file saved on your computer, or a location you can browse to, such as a network folder.
- Microsoft Excel for Microsoft 365 on Windows for the steps below. Excel for Mac has similar options, although their availability and labels can vary by update.
- If you plan to preserve leading zeros or prevent automatic date and number conversions, know which columns should be treated as text before you import.
Step-by-Step
-
Locate the TSV file. Find the file in File Explorer and check its name and extension. A filename might end in
.tsvor, in some cases,.txt. TSV files are plain text files; the extension alone does not guarantee Excel will interpret the separators correctly. If the file came from a colleague or a download, make sure you have the complete file rather than a web preview or a compressed archive. -
Choose whether to open or import. For a quick look at ordinary data, opening the file directly is usually enough. If the file contains values that must not be changed, or if you want to check the delimiter and character encoding, use the import route in steps 4–7. You can also use the import route even for a simple file; it gives you a preview before the data enters the worksheet.
-
Open a TSV directly in Excel. Start Excel, select File > Open > Browse, and navigate to the file. If it does not appear in the file picker, change the file-type filter to All Files or the closest available equivalent, select the TSV, and choose Open. Excel normally recognizes tab-separated data and places the fields in separate columns. You can also double-click a TSV in File Explorer if Windows is set to open that file type with Excel. If double-clicking opens another application, use Excel’s Open command instead or change the file association in Windows.
-
Inspect the worksheet after direct opening. Check several rows, especially the first and last, and confirm that values appear in the intended columns. Look for a row of headings, blank columns, unexpected date formatting, or codes that have lost leading zeros. Excel may automatically convert text that resembles a number, date, or scientific notation. If anything important changed, close the file without saving and import it using the controlled method below. The original TSV remains plain text unless you overwrite it outside Excel.
-
Start a controlled import. In a blank workbook, select Data > From Text/CSV on the Excel ribbon. Browse to the TSV, select it, and choose Import. Excel opens a preview window. Depending on the build, the command may be grouped under Get & Transform Data, and the preview may display a slightly different layout. If Excel opens the file directly instead, close it and start a blank workbook before using the Data tab.
-
Set the delimiter to Tab. In the preview, look for the delimiter control and choose Tab. If the delimiter is set to Comma or another character, the preview may show an entire row in one column or split values in the wrong places. Confirm that each field appears in its own column and that the first few rows match the source. If the preview already looks correct and identifies Tab, leave that setting in place.
-
Check the file origin and data types. If accented or non-Latin characters appear incorrectly, try the appropriate encoding in the File Origin or encoding control; UTF-8 is a common choice for modern text files. If leading zeros or date-like strings must remain unchanged, choose Transform Data in the preview rather than loading immediately. In the Power Query Editor, select the affected column or columns and use Transform > Data Type > Text. Check that the preview still shows the original values. This step is particularly important for identifiers such as 00481, which may otherwise become 481.
-
Load the data into Excel. When the preview and types are correct, choose Load to insert the data into a worksheet. If you used Transform Data, you can select Home > Close & Load in the Power Query Editor. Excel creates a table-like range from the imported records. Confirm the number of columns, the headings, and a few representative values before working with the data. If you need to change the import later, use the query or import controls available in the workbook.
-
Save an Excel copy. A TSV does not store Excel features such as multiple worksheets, formulas, or cell formatting. To keep the imported data and use Excel features, select File > Save As, choose a folder, and select Excel Workbook (*.xlsx) as the file type. Give the workbook a different name from the source. This leaves the original TSV unchanged and makes it clear which file is the editable Excel version.
On Mac: You can usually open a TSV from Excel using File > Open and selecting the file. For a controlled import, look for Data > From Text/CSV or the available text import command. The exact wording and Power Query options depend on your Excel for Mac update. If the import preview is not available, open a copy of the TSV and verify the columns and sensitive values before saving as an .xlsx file. Excel for the web has fewer import controls; if it does not open or split the file as needed, use the desktop app.
Common Mistakes
-
Assuming every text file is tab-separated. A file ending in .txt might use commas, semicolons, or spaces instead. Check the preview and select the separator that matches the file. Choosing Tab for a comma-separated file can leave all the data in one column.
-
Saving over the source. When using Save As, choose .xlsx and a different filename. Saving in a text format can discard workbook features, and writing over the original may make it harder to return to the untouched source. Keep the downloaded or supplied TSV as a backup.
-
Ignoring automatic conversions. Excel can remove leading zeros or reinterpret strings such as 3/4 as dates. A value can look plausible while no longer matching the source. Review identifier, date, and code columns before proceeding; import sensitive columns as text when their exact characters matter.
-
Expecting the original layout to carry over. TSV stores field values and row breaks, not fonts, colors, merged cells, or multiple sheets. If the source was meant to include formatting, ask for an Excel workbook or another format that preserves it.
-
Skipping the preview. A successful import dialog does not prove that the file was parsed correctly. Check the first rows and at least one row with unusual or empty fields. A shifted column can affect every later calculation or sort.
Tips
-
Keep an untouched copy of the TSV before editing or importing, especially if it is an exported report or a file you may need to reproduce later.
-
Use the preview to confirm that the first row is treated as data or headings as intended. If the file has no header row, do not assume the first record contains column names; rename columns in Excel after loading if useful.
-
For identifiers, account numbers, postal codes, and values with leading zeros, set the relevant columns to Text during import. Formatting a number as text after zeros have already disappeared does not restore them.
-
After loading, use Home > Format > AutoFit Column Width if values are present but appear cut off. You can also double-click the boundary between column letters to resize a column to its contents.
-
For a TSV that you receive regularly, the text import query can help you repeat the process. If the source file is replaced or updated, use the workbook’s query refresh option where available, and verify that the new data has the same structure.
-
Excel worksheets have a limit of 1,048,576 rows and 16,384 columns. If a TSV exceeds a worksheet’s capacity, Excel cannot place every record on one sheet; use a suitable database or data tool, or split the source before importing.
Troubleshooting
-
The TSV opens in Notepad or another app. Open Excel first, choose File > Open > Browse, and select the file. If it is missing from the list, adjust the file-type filter. You can change Windows’ default app for .tsv files, but that is optional; opening it through Excel avoids relying on the file association.
-
Everything appears in one column. Return to the text import preview and set the delimiter to Tab. If that does not split the fields, the file may use a different separator, or it may not be a TSV despite its extension. Open a copy in a plain-text editor and check whether fields are separated by tabs, commas, or another character. Then select the actual delimiter during import.
-
Values are in the wrong columns. Look for a different delimiter, quoted fields, or inconsistent rows. In the preview, compare a simple row with one that contains punctuation or empty fields. Do not replace tabs blindly in a text editor: a tab inside a field or an empty value can be meaningful. If the file is malformed, ask the source system or sender for a corrected export.
-
Leading zeros disappeared or dates changed. Close without saving if the source has not been overwritten, then import again and set the affected columns to Text in the transformation step. If you have only the altered workbook, reimport from the original TSV; changing the displayed cell format cannot recreate characters Excel already converted or removed.
-
Characters look garbled. Reimport and try a different File Origin or encoding, starting with UTF-8 if appropriate. Compare names or symbols with the original source rather than guessing from one character. If the sender knows the export encoding, use that setting; changing fonts alone will not repair text read with the wrong encoding.
-
Excel reports that the file is too large or stops short. Check the worksheet row and column limits and confirm that the file is not damaged or incomplete. For data beyond Excel’s worksheet limits, use a database or an application designed to process larger text files, or divide the source into smaller parts before opening it.
Frequently Asked Questions
What does TSV mean?
TSV means tab-separated values. It is a plain-text format in which tabs separate fields and line breaks separate records. It is similar to CSV, but the usual field separator is a tab rather than a comma.
Can I open a TSV file in Excel by double-clicking it?
Usually, yes, if Excel is associated with .tsv files in Windows. If another application opens it, use Excel’s File > Open command and browse to the file. For more control over conversions, import through Data > From Text/CSV.
How do I keep leading zeros in a TSV?
Import the file and set the affected column to Text before loading. For example, an identifier written as 00481 should remain text if those zeros are part of the identifier. Direct opening can convert it to 481, so check the preview and the resulting cell values.
Can I open a TSV in Excel for the web?
Excel for the web may handle a TSV differently from the Windows desktop app and offers fewer import controls. If it does not split the columns correctly or you need to set data types, open the file in desktop Excel, import it there, and save an .xlsx copy to OneDrive.
Will Excel change my TSV file when I open it?
Opening a file does not normally overwrite the source unless you save changes to that same file. However, Excel can interpret values when displaying them. Use Save As to make an .xlsx copy, and keep the original TSV if you need an unchanged version.
Why is a TSV different from an Excel workbook?
A TSV is plain text containing rows and fields; it does not preserve formulas, formatting, charts, or multiple worksheets. An .xlsx workbook can store those Excel features. Save an imported TSV as .xlsx if you want to continue working with it as a workbook.
Related
- How to Insert a Straight Line in Word: 3 Easy Methods
- How to Insert a Small Checkbox in Word
- How to Insert a Small Vertical Line in Word and Format It
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Delete Duplicate Cells in Excel Without Losing DataTo remove repeated entries from a list in Excel, select the list, choose Data > Remove Duplicates, confirm…
- How to Compare Two XML Files in ExcelTo compare two XML files in Excel, import each one with Power Query, shape both into tables with…
- How to Insert a Citation Placeholder in WordTo insert a citation placeholder in Word for Microsoft 365 on Windows, place the cursor where the citation…
- How to Share Excel in Real Time and Co-Edit SafelyTo share an Excel workbook in real time, save it to OneDrive or SharePoint, select Share, give your…
- Excel Insert Row Shortcut: Fast Ways for Windows and MacExcel has no built-in shortcut named “IR.” If you mean insert row, select the row with Shift+Space, then…
- Microsoft Excel: How to Open the App and FilesTo open Microsoft Excel on a Windows PC, select Start, type Excel, and choose the Excel app in…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.