The fastest way to convert a text file to Excel

Open your text file in Excel directly, and Excel will walk you through converting it. You do not need a separate converter tool or any special software beyond what you likely already have. The process takes about two minutes and works whether your text file uses commas, tabs, spaces, or another separator to divide the data into columns.

The reason this works: Excel has a built-in import tool that recognizes how your data is structured and asks you to confirm the layout before saving. You are not converting the file itself — you are opening the raw text and telling Excel how to organize it into rows and columns.

Key Takeaways

  • Open Excel first, then use File > Open to select your text file; do not double-click the text file from your folder.
  • Excel's Text Import Wizard will appear and show you a preview of how your data will look in columns.
  • Choose the correct delimiter (comma, tab, space, or other) so Excel splits your data into the right columns.
  • Save the file as an Excel file (.xlsx) when you are done, which creates a new file and leaves your original text file unchanged.

Opening the text file through Excel, not your folder

The key step most people miss is the order: open Excel first, then open the text file from inside Excel. If you double-click the text file in your folder, it will open in Notepad or your default text editor instead.

Launch Excel. Go to File in the top left, then click Open. A window will appear showing your folders and files. Navigate to the folder where your text file lives. At the bottom right of the window, you will see a dropdown that says "Excel Files" or similar — click it and change it to All Files or Text Files. Now your .txt file will appear in the list. Click it once to select it, then click the Open button.

Using the Text Import Wizard to set up your columns

A window titled "Text Import Wizard" will open. This is where you tell Excel how to split your data. At the top, you will see a preview of your text file. Below that are three steps, but you only need to focus on Step 1 and Step 3.

In Step 1, look at the section labeled Delimiters. A delimiter is the character that separates one piece of data from the next. Check the box next to the delimiter your file uses. If your data looks like John,Smith,john@example.com, check Comma. If it looks like John Smith john@example.com (with space between), check Tab. If you are not sure, look at the preview window at the top — it will show you how the data splits into columns as you check each box. When the preview looks right, click Next.

Step 2 lets you set the data type for each column (text, number, date), but you can usually skip this. Click Next again. In Step 3, click Finish. Your text data will now appear in an Excel spreadsheet with each piece of data in its own cell.

Saving your file as an Excel document

Your data is now in Excel, but it is still technically a temporary import. To keep it, you must save it as an Excel file. Go to File, then Save As. A window will open asking where you want to save and what to name the file.

At the bottom of the window, you will see a dropdown labeled Save as type. Click it and select Excel Workbook (.xlsx) or Excel Workbook (.xls) — either works, though .xlsx is the current standard. Choose a folder and give your file a name. Click Save. You now have a real Excel file, and your original text file remains unchanged in your folder.

What to do if your data does not split correctly

If the preview in the Text Import Wizard shows your data all in one column, or split in the wrong places, you chose the wrong delimiter. Go back and uncheck the delimiter you selected, then check a different one. Common delimiters are comma, tab, semicolon, and space — try each until the preview shows your data in separate columns the way you want it.

If your text file uses a delimiter that is not in the standard list (for example, a pipe character |), click the Other checkbox and type the character in the box next to it. The preview will update when ready.

When your text file has headers or extra rows

If your first row contains column names (like "First Name", "Last Name", "Email"), Excel usually recognizes this automatically and treats it as a header. You can verify this in Step 1 of the Text Import Wizard — look for a field labeled Text Qualifier or check whether the preview shows your headers in a different format.

If your text file has blank rows at the top or bottom, or rows you do not want to import, you can delete them after the import is complete. Open the file in Excel, select the unwanted rows by clicking the row number on the left, right-click, and choose Delete. Then save the file again.

Using a different program if you prefer

Excel is the simplest option because it is built to handle this task, but you can also open a text file in Google Sheets or LibreOffice Calc (a free alternative to Excel). Both have similar import wizards. Google Sheets is online, so you do not need to install anything — go to sheets.google.com, click New, then File upload, and select your text file.

LibreOffice Calc works the same way as Excel: open the program, go to File > Open, select your text file, and use the import dialog to set your delimiter. If you came from the privacy guide, note that LibreOffice runs entirely on your computer with no cloud storage, while Google Sheets stores your file online by default — choose based on where you want your data to live.

Frequently Asked Questions

Will converting to Excel change my original text file?

No. The original text file stays exactly as it is. When you save in Excel, you are creating a new file with the .xlsx extension. Both files exist separately in your folder.

What if my text file is very large?

Excel can handle files with hundreds of thousands of rows, though very large files may open slowly. If your file is extremely large (over 1 million rows), you may need to split it into smaller pieces first, or use a database program instead.

Can I automate this if I have many text files to convert?

Excel has a macro feature that can repeat the same steps on multiple files, but setting it up requires some technical knowledge. For most people, converting files one at a time through the Text Import Wizard is the most straightforward approach.

What if my text file uses a format I do not recognize?

Open the text file in Notepad first to see what character separates your data. Look for patterns like commas, pipes (|), colons, or multiple spaces. Once you identify the separator, use that as your delimiter in Excel's Text Import Wizard.

Does this work on Mac?

Yes. Excel for Mac has the same Text Import Wizard. Open Excel, go to File > Open, select your text file, and follow the same steps. The menu names and buttons are identical.