Converting a TXT file to Excel involves importing the text data and splitting it into columns using a delimiter — comma, tab, pipe, or fixed width. Excel has built-in tools for this, and the approach depends on how your text file is structured.
Method 1: Open TXT in Excel Using Text Import Wizard
In Excel, go to File → Open and select your .txt file. The Text Import Wizard opens. Step 1: choose Delimited or Fixed Width depending on your file. Step 2: select your delimiter (Tab, Comma, Semicolon, or custom character). Step 3: set the data format for each column. Click Finish. Excel creates a new spreadsheet with your text data properly split into columns.
Method 2: Data > Get Data > From Text/CSV
In newer Excel versions (2016+), use Data → Get Data → From Text/CSV. Select your file. Excel automatically detects the delimiter and shows a preview. Adjust the delimiter setting if needed and click Load. This method uses Power Query, which provides better handling of encoding issues and can be refreshed if the source file is updated.
Convert TXT to CSV Then Import
If your text file uses commas as delimiters, rename the extension from .txt to .csv. Excel opens CSV files directly without the import wizard, treating commas as column separators automatically. This is the fastest method for comma-delimited text files.
Frequently Asked Questions
What delimiter should I use to import a TXT file into Excel?
Open the TXT file in a text editor to check what separates the values in each row. Common delimiters are comma (,), tab ( ), pipe (|), and semicolon (;). Choose the matching delimiter in the Excel import wizard. If the values are not separated by a consistent character but by fixed spacing, use the Fixed Width option instead.