The fastest way depends on your file's structure

If your text file has data separated by commas, tabs, or spaces, Excel can read it directly without conversion. Open Excel, go to File > Open, and select your .txt file — Excel's import wizard will let you choose how to split the columns. If your text is already organized into rows and columns with consistent spacing, this takes under a minute.

For files that need more work, you have two other routes: copy-paste the data into Excel and use the Text to Columns feature, or save the file as a .csv (comma-separated values) file first, then open it in Excel. Which one you choose depends on how messy your data is and whether you want to keep the original text file unchanged.

Key Takeaways

  • Excel can open .txt files directly if data is separated by commas, tabs, or consistent spaces — the import wizard handles the column split automatically.
  • The Text to Columns feature in Excel splits pasted text into separate cells based on a delimiter you choose, working on data already in the spreadsheet.
  • Saving a .txt file as .csv first makes it easier for Excel to recognize the structure, especially if columns are comma-separated.
  • If your text file has irregular spacing or mixed delimiters, you may need to clean it up in the text editor before Excel can split it correctly.

Opening a text file directly in Excel

Start Excel and click File in the top left. Select Open (or Open File on a Mac). Navigate to your text file and click it once to select it. At the bottom of the dialog, you may see a dropdown that says "All Excel Files" — change this to "All Files" or "Text Files" so your .txt file appears in the list.

Click the text file and then click Open. Excel will launch the Text Import Wizard, a dialog with three steps. On the first screen, choose the delimiter — the character that separates your columns. If your data uses commas, select Comma. If it uses tabs (the space created by pressing Tab), select Tab. If columns are separated by spaces, select Space. You can see a preview at the bottom showing how Excel will split your data.

Click Next to move to step two, where you can adjust column widths and data types if needed — usually the defaults work fine. Click Next again, then Finish. Your data will now appear in the spreadsheet with each column in its own cell.

Using copy-paste and Text to Columns

If you want to keep your text file open while working, or if the file is already partially in Excel, copy-paste is faster. Open your text file in Notepad, Word, or any text editor. Select all the text (Ctrl+A on Windows, Command+A on Mac), then copy it (Ctrl+C or Command+C).

Switch to Excel and click the cell where you want the data to start — usually A1. Paste the text (Ctrl+V or Command+V). All the text will land in a single column. Now select that entire column by clicking the column header (the letter at the top). Go to the Data menu and click Text to Columns.

The Text to Columns wizard works the same way as the import wizard: choose your delimiter on the first screen, preview the split on the second, and click Finish. Your data will now spread across multiple columns. If the split does not look right, press Ctrl+Z to undo and try a different delimiter.

Converting to .csv first

If your text file uses commas to separate columns, you can rename it to .csv and open it directly in Excel without the import wizard. Right-click the .txt file and select Rename (or press F2 with the file selected). Change the extension from .txt to .csv and press Enter. Windows or Mac will ask if you are sure — click Yes or Change.

Now double-click the .csv file. It will open in Excel automatically, and the columns will usually split correctly without any wizard appearing. This method works best when your data is already comma-separated and you do not need to adjust the delimiter.

If you want to keep the original .txt file unchanged, do not rename it. Instead, open Excel first, go to File > Open, and select the .txt file — this leaves the original file as-is and only opens a copy in Excel.

Fixing common problems with text import

If columns do not split the way you expected, the delimiter may be wrong or inconsistent. Go back to the Text to Columns wizard (Data menu) and try a different delimiter. If your data mixes commas and spaces, or uses irregular spacing, you may need to clean it up in the text editor first.

Open the text file in Notepad and look for the pattern. If some rows use commas and others use spaces, find-and-replace can help. Press Ctrl+H to open Find & Replace, type a space in the Find field, type a comma in the Replace field, and click Replace All. This converts all spaces to commas so the delimiter is consistent.

Another common issue is extra blank rows or leading spaces before data. Delete these in the text editor before importing — select the blank lines and press Delete, or use Find & Replace to remove leading spaces. Clean data imports much faster and with fewer errors.

Saving your Excel file in the right format

Once your data is in Excel, save it as an .xlsx file to keep all Excel features. Go to File > Save As, choose a location, type a filename, and make sure the file type dropdown says "Excel Workbook (.xlsx)". Click Save.

If you need to send the file to someone who uses an older version of Excel, you can save it as .xls instead — select "Excel 97-2003 Workbook (.xls)" from the file type dropdown. If you want to keep it as a .csv for use in other programs, select "CSV (Comma delimited) (.csv)" instead. Each format has trade-offs: .xlsx keeps formatting and formulas, .csv is simpler and works everywhere, and .xls is for older Excel versions.

Frequently Asked Questions

What if my text file does not have a clear delimiter?

If data is separated by irregular spacing or multiple spaces, use the Space delimiter in the import wizard and let Excel split on any space. If that creates too many columns, clean up the text file first by replacing multiple spaces with a single comma, then import again.

Can I convert a large text file with thousands of rows?

Yes, Excel can handle files with over a million rows. Use the direct open method (File > Open > select .txt file) rather than copy-paste, as it is faster for large files. If Excel runs slowly, your computer may need more memory, but the conversion itself will complete.

Will Excel keep my original text file when I convert it?

Yes, the original .txt file stays unchanged. Whether you open it directly in Excel, copy-paste it, or rename a copy to .csv, the original remains in your folder. Only save the Excel version if you want to keep the converted spreadsheet.

What happens to special characters or formatting in the text file?

Excel preserves letters, numbers, and punctuation, but not text formatting like bold or italics — those only exist in word processors, not plain text files. If your text file contains symbols or non-English characters, Excel usually handles them correctly, but check the preview in the import wizard to be sure.

Can I automate this conversion for multiple files?

Excel does not have a built-in batch converter, but you can open and save multiple files one at a time using the same steps. If you need to convert dozens of files regularly, a script or macro can automate it, but that requires learning VBA or using a third-party tool.