The fastest way to move text into Excel

You can move text from a text file into Excel in about two minutes using Excel's built-in import tool. The process works best when your text is organized into columns separated by commas, tabs, or spaces — Excel can then automatically split it into the right cells. If your text file is just one long block of words, you'll need to add separators first, or paste it into a single Excel column and split it manually afterward.

The method you choose depends on how your text is structured. A comma-separated file (CSV) opens directly in Excel with almost no work. A tab-separated or space-separated file needs one extra step. A plain text file with no separators requires the most manual work, but it's still straightforward.

Key Takeaways

  • CSV files (comma-separated values) open directly in Excel and automatically fill the correct columns.
  • Tab-separated or space-separated text files can be imported using Excel's Text Import Wizard, which appears automatically when you open them.
  • Plain text with no separators should be pasted into one column, then split using the Text to Columns feature.
  • You can also copy and paste text directly into Excel, then use Text to Columns to split it into separate cells.

Opening a CSV file directly in Excel

If your text file ends in .csv (comma-separated values), the simplest approach is to open it like any other file. Right-click the CSV file, select Open with, and choose Microsoft Excel. Excel will read the commas and automatically place each value into its own cell.

If you're already in Excel, go to File > Open, navigate to your text file, and select it. Make sure the file type dropdown at the bottom shows All Files or Text Files so you can see your file in the list. Click Open, and Excel handles the rest.

This method works because Excel recognizes the comma as a delimiter — the character that marks where one piece of data ends and another begins. No additional steps are needed.

Using the Text Import Wizard for tab or space-separated files

If your text file uses tabs or spaces to separate columns instead of commas, Excel will prompt you with the Text Import Wizard when you open the file. This three-step dialog lets you tell Excel which character separates your data.

Step 1: When the wizard opens, you'll see a preview of your data at the bottom. Leave the file origin as 65001: UTF-8 (the standard setting) unless you know your file uses a different encoding. Click Next.

Step 2: The wizard now asks what separates your columns. Uncheck Tab if it's selected, then check the box that matches your file — Space if your columns are separated by spaces, or Tab if they're separated by tabs. You'll see the preview update to show how Excel will split your data. If it looks right, click Next.

Step 3: This screen lets you set the data type for each column (text, number, date, or skip). For most purposes, the default settings work fine. Click Finish, and your data lands in Excel with each value in the correct cell.

Pasting text and splitting it with Text to Columns

If you want to copy text from a file and paste it into Excel, or if your text has no clear separators, you can paste it all into one column and then split it. Open your text file in Notepad or any text editor, select all the text with Ctrl+A, and copy it with Ctrl+C.

In Excel, click on cell A1 and paste with Ctrl+V. All your text will land in column A. Now select the entire column A by clicking the column header. Go to the Data menu and click Text to Columns.

The Text to Columns wizard works the same way as the import wizard. Choose the delimiter that separates your data — comma, tab, space, or another character. If your text has no separators and you just want to split it by character count (for example, the first 10 characters in one column, the next 10 in another), select Fixed width instead and drag the dividers to show where each column should break. Click Finish, and Excel splits your data across multiple columns.

Handling text with inconsistent spacing or formatting

Sometimes text files have extra spaces, irregular tabs, or mixed separators that make automatic splitting difficult. The Text Import Wizard and Text to Columns tool both let you preview the result before confirming, so you can see if the split looks right.

If the preview shows data landing in the wrong cells, go back and adjust your delimiter choice. If your file mixes commas and spaces, or has multiple spaces between values, you may need to clean up the text file first. Open it in Notepad, use Find and Replace to standardize the separators, and save it before importing into Excel.

Another option: paste the text into Excel, split it roughly with Text to Columns, and then manually move or edit cells that didn't split correctly. This is faster than perfecting the text file when you only have a few problem rows.

Saving your converted file as an Excel workbook

Once your text is in Excel and organized into columns, you'll want to save it as an Excel file so you can edit and format it. Go to File > Save As. The dialog will ask what format to use. Choose Excel Workbook (.xlsx) from the dropdown, give your file a name, and click Save.

If you opened a CSV file directly, Excel may ask whether you want to keep it as CSV or convert it to .xlsx. Choose Excel Workbook if you plan to add formulas, formatting, or multiple sheets. Choose CSV only if you need to share the file with a program that doesn't read Excel files.

Frequently Asked Questions

What if my text file doesn't have a .txt or .csv extension?

Excel can still open it. In the File Open dialog, change the file type dropdown to All Files so you can see files without recognized extensions. Select your file and open it. Excel will either open it directly or prompt you with the Text Import Wizard.

Can I convert a text file that has data in multiple tables or sections?

Yes, but you'll need to handle each table separately. Copy the first table into Excel and split it, then paste the second table below it. Alternatively, open the text file in Notepad, delete everything except the first table, save it as a new file, and import that. Repeat for each table.

Why does my data look wrong after importing — numbers are left-aligned instead of right-aligned?

Excel is treating them as text instead of numbers. Select the column, go to Data > Text to Columns, and in Step 3 of the wizard, click the column header and change the data type from Text to General or Number. Click Finish.

Can I automate this process so I don't have to do it manually every time?

If you're converting the same text file format repeatedly, save a blank Excel file with the import settings you used (the delimiter, data types, and column widths). Then you can open new text files and apply those same settings more quickly. For truly automated conversion, you would need to write a macro or use a third-party tool, which is beyond basic Excel use.