The simplest way to open a text file in Excel

The fastest route is to open Excel first, then open your text file from inside it. Excel can read most text files directly and will ask you how to split the data into columns — you do not need a separate conversion tool.

Open Excel. Go to File > Open. Navigate to your text file (it will have a .txt extension). Select it and click Open. Excel will show you a preview of how it plans to arrange your data, and you can adjust the settings before confirming.

This method works for any text file where the data is separated by something consistent — a comma, a tab, a space, or another character. Excel calls this separator a delimiter, and it will usually detect it automatically.

Key Takeaways

  • Open Excel and use File > Open to load your text file directly; Excel will preview how it splits the data before you save it.
  • The Text Import Wizard appears automatically and lets you choose which character (comma, tab, space) separates your columns.
  • If your text file has no consistent separator, you can use Find & Replace in Excel to add one, then re-open the file.
  • Once the data is arranged correctly in the preview, click Finish and then save the file with an .xlsx extension to keep it as an Excel file.

Understanding delimiters and the Text Import Wizard

When you open a text file in Excel, the Text Import Wizard appears automatically. This is a three-step dialog that shows you how Excel will interpret your data. The first step asks you to choose the file origin (usually UTF-8 or the default for your computer) — you can leave this as is unless you know your file uses a different encoding.

Step two is where you choose the delimiter. Excel offers common options: Tab, Semicolon, Comma, and Space. Check the box next to whichever one separates your columns. You will see the preview update in real time, showing you how your data will split. If none of these match, you can type a custom character in the "Other" field.

Step three lets you set the data type for each column — usually you can leave this as General, which lets Excel decide. If a column contains numbers that you want treated as text (like ZIP codes or phone numbers with leading zeros), click that column in the preview and change it to Text. Then click Finish.

What to do if your text file has no clear separator

Some text files have data crammed together with no consistent separator between columns. For example, a file might contain names and addresses all on one line with no commas or tabs between them. In this case, you need to add a separator before Excel can split it properly.

Open the text file in Notepad (right-click the file, choose Open with > NotepadCtrl+H to open Find & Replace. In the "Find what" field, type the text or pattern where the break should happen. In the "Replace with" field, type the same text followed by a comma. Click Replace All. Save the file and close Notepad.

Now open the file in Excel again. The Text Import Wizard will appear, and this time you can choose Comma as the delimiter. The data should split into columns correctly.

Saving your file as an Excel spreadsheet

Once the Text Import Wizard finishes and your data appears in the spreadsheet, you are still working with a temporary version. To keep it as an Excel file, you must save it with the .xlsx extension.

Press Ctrl+S or go to File > Save As. Choose a location and give the file a name. In the "Save as type" dropdown, select Excel Workbook (.xlsx). Click Save. Your text data is now a permanent Excel file that you can edit, format, and share.

Converting text files with fixed-width columns

Some text files use fixed-width columns instead of delimiters — each column takes up the same number of characters, and data is padded with spaces. A file might have names in columns 1–20, addresses in columns 21–50, and phone numbers in columns 51–60.

When you open this file in Excel, the Text Import Wizard will detect it and ask whether you want Delimited or Fixed width. Choose Fixed width. In step two, you will see a preview with vertical lines showing where Excel thinks the columns break. You can drag these lines left or right to adjust them, or double-click to remove a line you do not need. Once the breaks are correct, click Finish.

Handling special characters and encoding issues

If your text file contains accented letters, symbols, or characters from another language, Excel might display them as garbled text. This usually means the file uses a different character encoding than your computer expects.

When the Text Import Wizard appears, look at step one. Instead of leaving the file origin as default, click the dropdown and look for UTF-8 or Unicode. If the preview in step two shows the characters correctly, use that setting. If not, try other options until the preview looks right. Once you find the correct encoding, click Finish.

If you are still seeing garbled text after saving, the issue may be with how Excel is displaying the file rather than how it imported it. Open the file again, select all the data (Ctrl+A), and check the font. Some fonts do not include all characters. Try changing to Arial or Calibri, which support most common languages.

Using paste special if you have the text file already open

If you already have your text file open in Notepad or another text editor, you can copy the data and paste it into Excel instead of using the Text Import Wizard. Select all the text (Ctrl+A), copy it (Ctrl+C), and switch to Excel.

Click the cell where you want the data to start, then go to Edit > Paste Special (or press Ctrl+Shift+V). A dialog will appear. If your text is delimited, leave the default settings and click OK. If it is not working correctly, undo (Ctrl+Z) and try opening the file through Excel instead, which gives you more control over how the data splits.

Frequently Asked Questions

Why does my text file open in Notepad instead of Excel?

Windows associates .txt files with Notepad by default. To open it in Excel, right-click the file, choose Open with, and select Excel. Or open Excel first and use File > Open to navigate to the text file. Excel will handle the import correctly either way.

Can I convert multiple text files to Excel at once?

Excel does not have a batch converter, but you can repeat the process for each file — it takes only a minute per file once you know the delimiter. If you have many files with the same format, open the first one, note the delimiter and column layout, then use the same settings for the rest.

What if Excel splits my data into the wrong columns?

Go back to step two of the Text Import Wizard and check that you selected the correct delimiter. If the preview still looks wrong, undo the import (Ctrl+Z), close the file without saving, and edit the text file in Notepad to add or fix the delimiters before trying again.

Will converting to Excel change the original text file?

No. The original .txt file stays unchanged. When you save in Excel, you are creating a new .xlsx file. The text file remains as it was.

Can I convert an Excel file back to text?

Yes. Open the Excel file, go to File > Save As, and in the "Save as type" dropdown, choose Text (Tab delimited) (.txt) or CSV (Comma delimited) (.csv). Click Save. Excel will create a new text file with your data separated by the delimiter you chose.