How to Open Tab Delimited Files in Excel

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.

Microsoft Excel has the ability to open tab-delimited files and display them as spreadsheets. However, tab-delimited files have the extension TXT. Therefore, a tab-delimited file will open in Notepad rather than Excel when you double-click it. Instead of double-clicking a tab-delimited file, launch Excel first and open the file from within Excel.

Advertisement

Step 1

Launch Excel from the Microsoft Office Start menu folder. Click the "File" tab in the upper-left corner of the window, then click "Open."

Video of the Day

Step 2

Click the drop-down menu at the bottom of the window currently displaying "All Excel Files," then click "All Files."

Advertisement

Step 3

Double-click the tab-delimited file that you want to open. A window titled "Text Import Wizard" appears.

Step 4

Click to select the "Delimited" radio button, then click "Next."

Advertisement

Step 5

Click to place a check in the "Tab" box under "Delimiters," then click "Next."

Advertisement

Step 6

Click a column in the preview area at the bottom of the window, and then click a radio button such as "Text" or "Date" in the upper-left corner to indicate the type of data in the column. The "General" radio button is selected by default for all columns.

Step 7

Click the "Finish" button to open the file in Excel.

Video of the Day

Advertisement

Advertisement

references