Excel can open text files directly, but the method depends on whether you want to keep the file as text or convert it permanently to an Excel spreadsheet
The simplest approach is to open Excel, go to File > Open, navigate to your text file, and select it. Excel will recognize common text formats like .txt and .csv and display the file in a new workbook. If the text file uses commas or tabs to separate data into columns, Excel's Text Import Wizard will appear automatically and let you preview how the data will split across columns before you confirm.
If you want to save the file as a permanent Excel spreadsheet rather than just viewing it as text, you can use File > Save As after opening it, then choose Excel Workbook (.xlsx) from the file type dropdown. This creates a new .xlsx file while leaving your original text file unchanged.
Key Takeaways
- Opening a text file in Excel requires only navigating to File > Open and selecting the text file — Excel handles the rest automatically for most common formats.
- The Text Import Wizard appears when Excel detects column separators like commas or tabs, letting you preview and adjust how data splits across columns.
- Dragging a text file directly onto an open Excel window opens it without using the menu, which is faster if Excel is already running.
- Saving the file as .xlsx converts it to a permanent Excel spreadsheet, while opening it without saving keeps it as a text file.
Using the File Menu to Open Text Files
Start by opening Excel. Click File in the top-left corner, then select Open. A file browser window will appear. Navigate to the folder where your text file is stored, then look for files with extensions like .txt, .csv, or .tsv. Click the file once to select it, then click the Open button.
Excel will load the file into a new workbook. If the text file contains data separated by commas, tabs, or other delimiters, the Text Import Wizard dialog will open automatically. This wizard shows you a preview of how your data will appear in columns. You can adjust the delimiter setting — for example, if your file uses commas to separate values, make sure Comma is checked. Click Finish when the preview looks correct, and the data will populate the spreadsheet.
Dragging a Text File Onto Excel
If Excel is already open on your screen, you can drag a text file directly from your file manager (File Explorer on Windows, Finder on Mac) onto the Excel window. This opens the file without using the menu and is faster if you are switching between multiple files.
The same Text Import Wizard will appear if the file contains delimited data. Adjust the settings as needed and click Finish. This method works the same way as using the File menu — it just skips the dialog steps.
Understanding the Text Import Wizard
The Text Import Wizard appears in three steps when you open a delimited text file. The first step shows you the file preview and lets you choose the file origin (usually UTF-8 or the default for your system). The second step is where you select delimiters — the characters that separate your data into columns. Common delimiters are commas, tabs, semicolons, and spaces. You can check multiple delimiters if your file uses more than one.
The third step lets you set the data format for each column. Most of the time you can leave this as General, but if a column contains dates or numbers that Excel is misreading, you can click the column in the preview and change its format. Once everything looks right, click Finish to complete the import.
Saving a Text File as an Excel Spreadsheet
After opening a text file in Excel, you can save it as a permanent .xlsx file. Click File > Save As. A dialog will open asking where to save the file and what format to use. In the Save as type dropdown, select Excel Workbook (.xlsx). Choose a location and filename, then click Save.
This creates a new Excel file while leaving your original text file untouched. If you want to replace the text file entirely, you can delete it after confirming the Excel version saved correctly. Most people keep both files if they need to share the data in text format with others or use it in programs that only read text files.
Handling Text Files That Don't Split Into Columns
Some text files contain plain text without delimiters — for example, a .txt file with paragraphs or sentences. When you open these in Excel, the entire line of text will appear in a single cell in column A. The Text Import Wizard will still appear, but no delimiter will be selected, which is correct.
If you want to split this text into columns later, you can use Excel's Text to Columns feature. Select the column containing the text, go to the Data menu, click Text to Columns, and choose your delimiter. This works the same way as the import wizard but lets you adjust the split after the file is already open.
Common Issues and How to Fix Them
If your text file opens but the data looks jumbled or appears in the wrong columns, the delimiter setting was incorrect. Close the file without saving, open it again, and when the Text Import Wizard appears, check different delimiter options in the preview until the data splits correctly.
If special characters like accented letters appear as symbols, the file encoding may not match Excel's default. In the Text Import Wizard's first step, try changing the file origin from UTF-8 to another option like Western European or the encoding your file was created in. If you are unsure, contact whoever created the file and ask what encoding they used.
If Excel does not open the text file at all, check that the file extension is recognized. Some text files use custom extensions like .log or .dat. You can rename the file to .txt and try again, or right-click the file, select Open with, and choose Excel from the list of programs.
Frequently Asked Questions
Does opening a text file in Excel change the original file?
No. Opening a text file in Excel creates a temporary copy in memory. The original file remains unchanged unless you explicitly save over it. If you use Save As to create an .xlsx file, both the original text file and the new Excel file will exist.
What is the difference between .csv and .txt files in Excel?
.csv files are comma-separated values and are designed specifically for spreadsheet data. .txt files are plain text and may or may not contain delimited data. Excel treats both the same way — it opens them and offers the Text Import Wizard if delimiters are detected.
Can I open a text file without the Text Import Wizard appearing?
If the wizard appears and you want to skip it, you can click Finish when ready without changing any settings. Excel will use its default delimiter detection. If you want to prevent the wizard from appearing in the future, save the file as .xlsx instead of .txt, since Excel only shows the wizard for text formats.
What should I do if my text file has thousands of rows?
Excel can handle files with over one million rows, so size alone is not a problem. However, very large files may open slowly. If the file is extremely large and Excel is sluggish, consider opening it in a text editor first to check the file size, or split the file into smaller chunks before importing.
How do I open a text file that uses a delimiter Excel doesn't recognize?
In the Text Import Wizard's second step, look for a field labeled Other with an empty text box. Type or paste the character your file uses as a delimiter — for example, a pipe symbol (|) or a colon (:). Excel will then split the data using that character.