Excel can open plain text files, but the result depends on how the text is formatted

Excel will open a text file (.txt), but it treats the content as data to be placed in cells, not as formatted text. If your file is a straightforward list or comma-separated values, Excel handles it well. If it is a paragraph of prose, you will get one long string in a single cell, which is not useful. The process itself is straightforward: use File > Open, navigate to your text file, and Excel will either place it directly in the sheet or walk you through a text import dialog where you can tell it how to split the data into columns.

Before you open the file, think about what you actually need. If you want to read or edit the text as written, a text editor or word processor is the right tool. If you want to organize the data into rows and columns, or perform calculations on numbers within the text, then Excel is the right choice. Opening a text file in the wrong tool wastes time.

Key Takeaways

  • Excel opens .txt files through File > Open, but treats them as raw data rather than formatted documents.
  • The Text Import Wizard appears automatically for most text files and lets you specify how to split data into columns using delimiters like commas or tabs.
  • If your text file contains only paragraphs of prose with no structure, Excel will place all of it in a single cell, which is usually not what you want.
  • Comma-separated (.csv) and tab-separated (.tsv) files open more cleanly in Excel because the delimiters tell Excel exactly where column breaks should be.

Opening a text file through the File menu

Open Excel and go to File in the top left. Click Open (or press Ctrl+O on Windows, Command+O on Mac). A dialog box appears showing your files and folders. At the bottom of the dialog, you will see a dropdown that says "Excel Files" or similar. Click that dropdown and change it to "All Files" or "Text Files" so you can see .txt files in your directory.

Navigate to the folder where your text file is stored, select it, and click Open. Excel will either open the file directly into the sheet, or it will show you the Text Import Wizard. The wizard appears when Excel is not certain how to split your data, which happens most often with plain .txt files.

Using the Text Import Wizard to split data into columns

The Text Import Wizard has three steps. In Step 1, you choose the file origin (usually UTF-8 or the default for your system) and preview how the text looks. You can usually leave this as is unless you know the file uses a different character encoding.

Step 2 is where you tell Excel how to split the data. You will see checkboxes for delimiters — the characters that separate one column from the next. The most common delimiters are Tab, Semicolon, Comma, and Space. If your file is comma-separated (a .csv file), check Comma. If it uses tabs, check Tab. If it uses spaces, check Space. As you check each one, the preview at the bottom shows you how the data will split. Uncheck any delimiter that is creating unwanted splits.

Step 3 shows you the final result. Each column gets a data type (General, Text, Date, or Do Not Import). For most text files, General is fine. Click Finish, and the data appears in your sheet with each piece in its own cell.

What happens if your text file is just paragraphs

If your .txt file contains only prose — paragraphs of writing with no delimiters — Excel will place the entire content into a single cell in column A. This is because there are no commas, tabs, or other markers telling Excel where to create column breaks. The text will be there, but it will all be in one cell, and you will not be able to work with it as structured data.

If this happens, you have two options. First, you can manually add delimiters to your text file before opening it in Excel — for example, adding commas or tabs between the pieces of data you want in separate columns. Second, you can open the file in a text editor or word processor instead, which is usually the better choice if you just want to read or edit the prose.

Saving your work after opening a text file

Once you have opened a text file in Excel and made changes, you need to decide what format to save it in. If you click File > Save, Excel will ask you to confirm the file format. You can save it as an Excel file (.xlsx), which preserves all formatting and formulas, or you can save it back as a text file (.txt), which removes any formatting and formulas you added.

If you save as .txt, Excel will warn you that some features may be lost. This is normal. If you want to keep both versions — the original text file and an Excel version with your work — use File > Save As and give the file a new name with the .xlsx extension.

When to use CSV or TSV files instead of plain text

If you regularly work with data that needs to move between text editors and Excel, use a comma-separated values (.csv) file instead of a plain .txt file. A .csv file is still a text file, but it has a standard format: each row is a line, and each column is separated by a comma. Excel recognizes this format when ready and opens it without the Text Import Wizard.

Similarly, a tab-separated values (.tsv) file uses tabs instead of commas. Both formats are plain text — you can open and edit them in any text editor — but they are structured in a way that Excel understands. If you are creating a text file specifically to use in Excel, save it as .csv and you will have fewer steps to take when you open it.

Troubleshooting common problems

If the Text Import Wizard does not appear when you open a text file, Excel may have decided it can open the file without help. This usually means the file has a clear structure that Excel recognized. Check the result: if the data is split correctly into columns, you are done. If it is all in one column, go back to File > Open, select the file again, and this time right-click it and choose "Open With" > Excel. This sometimes forces the wizard to appear.

If the data splits incorrectly — for example, if a comma inside a quoted phrase causes an unwanted column break — you may need to edit the text file before opening it. Open it in a text editor, fix the delimiters, save it, and try again in Excel. Alternatively, if the file is small, you can manually fix the columns after opening by cutting and pasting cells into the correct positions.

Frequently Asked Questions

Can I open a .txt file without the Text Import Wizard appearing?

Yes. If Excel recognizes the file structure, it opens without the wizard. If you want the wizard to appear so you can control how the data splits, right-click the file and choose "Open With" > Excel instead of double-clicking it.

What if my text file has special characters or symbols that look wrong in Excel?

This is usually a character encoding issue. In the Text Import Wizard Step 1, look for the file origin dropdown. Try changing it from UTF-8 to another option like ANSI or Latin-1. The preview will show you if the characters display correctly. Choose the encoding that makes your text readable.

Can I convert a text file to Excel format permanently?

Yes. Open the text file in Excel, make any changes you want, then go to File > Save As. Choose "Excel Workbook (.xlsx)" from the file type dropdown, give it a name, and click Save. The file is now an Excel file and will always open in Excel by default.

What is the difference between opening a .csv file and a .txt file in Excel?

A .csv file has a standard format that Excel recognizes when ready, so it usually opens without the Text Import Wizard. A .txt file has no standard format, so Excel shows the wizard to ask you how to split the data. Both are text files, but .csv is structured specifically for data.

If I save an Excel file as .txt, will I lose my formulas?

Yes. Text files cannot store formulas, formatting, or multiple sheets. When you save as .txt, Excel converts all formulas to their results (the numbers they calculate) and removes all formatting. If you need to keep the formulas, save as .xlsx instead.