The fastest way to convert text to Excel
Open your text file in Excel directly, and Excel will walk you through converting it. Go to File > Open, find your .txt file, select it, and click Open. Excel launches the Text Import Wizard, which shows you how your data will split into columns. You can adjust the separator (comma, tab, space, or something else) right there, preview the result, and click Finish. Your text is now in an Excel spreadsheet, ready to save as .xlsx.
This method works best when your text file uses a consistent separator — commas, tabs, or spaces between values. If your text is just paragraphs with no structure, Excel will put it all in one column, and you will need to split it manually afterward.
The whole process takes under a minute for most files. Once you have the data in Excel, you can save it as an Excel file (.xlsx) by going to File > Save As, choosing Excel Workbook from the dropdown, and clicking Save.
Key Takeaways
- Opening a .txt file directly in Excel triggers the Text Import Wizard, which lets you choose how to split your data into columns before saving.
- The Text Import Wizard recognizes common separators like tabs and commas automatically, but you can change the separator if it guesses wrong.
- If your text file has no separators, all data lands in column A, and you will need to use Excel's Text to Columns feature to split it afterward.
- After converting, save your file as .xlsx (Excel Workbook) so it stays in Excel format the next time you open it.
Using the Text to Columns feature for files already in Excel
If you already have a text file open in Excel but the data is all crammed into one column, use Text to Columns to split it. Select the column containing your data, go to the Data menu, and click Text to Columns. The wizard appears and shows you the same separator options as the import process.
Choose the separator your text uses — if it is comma-separated values (CSV), pick Comma; if it uses tabs, pick Tab. You will see a preview of how the data splits. Click Next, check the column format (usually General is fine), and click Finish. Excel splits your data across multiple columns based on the separator you chose.
This feature is also useful if you opened a text file and Excel guessed the wrong separator the first time. You can undo the import, select the column, and run Text to Columns again with the correct separator.
Converting CSV files (a common text format)
CSV stands for comma-separated values, and it is a text file format that Excel understands natively. When you open a .csv file, Excel usually recognizes it as data and imports it correctly without asking. However, if Excel opens it as plain text with all values in one column, use the Text to Columns method above with Comma selected as the separator.
CSV files are the most common way to move data between programs because they are simple and work everywhere. If someone sends you data as a CSV and you want to keep it as an Excel file, open it in Excel, check that the columns look right, then save it as .xlsx using File > Save As.
One thing to watch: if your CSV contains special characters or non-English text, Excel may not display it correctly depending on your computer's language settings. If the text looks garbled, close the file without saving, then try opening it again and selecting a different character encoding in the Text Import Wizard (usually UTF-8 works for most files).
Handling text files with no clear separators
Some text files are just paragraphs or lists with no commas, tabs, or other dividers between values. When you open these in Excel, everything lands in column A. You have two choices: manually split the data using Text to Columns if there is a hidden pattern, or manually reorganize it if there is not.
If the text has a pattern you can use as a separator — even spaces between words — select the column and use Text to Columns, then choose Space as the separator. Excel will split on every space, which may create too many columns, but you can delete the empty ones afterward.
If there is no pattern at all, you will need to manually move data into the right cells or retype it. This is tedious, but it is the only option for truly unstructured text. Before you start, consider whether the original data source can export in a structured format (CSV, tab-separated, or something similar) instead.
Saving your converted file as an Excel spreadsheet
After your text is converted and organized in Excel, save it in Excel format so it stays that way. Go to File > Save As. In the dialog that opens, find the dropdown that says "Save as type" and select Excel Workbook (.xlsx). Type a filename and click Save.
If you save it as a text file again (.txt), you will lose all the column formatting and have to convert it again next time. Saving as .xlsx keeps your columns, formatting, and formulas intact. If you need to share the file with someone who does not have Excel, you can save it as CSV instead, which most spreadsheet programs can open.
Excel will ask you to confirm the format if you are saving a file that was originally text. Click Yes to proceed. Your file is now a proper Excel spreadsheet.
Troubleshooting common conversion problems
If the Text Import Wizard does not appear when you open a text file, your computer may have a default program set for .txt files that is not Excel. Right-click the text file, choose Open With, and select Excel or another spreadsheet program from the list. If Excel is not listed, click Browse and navigate to your Excel installation folder to select it.
If your data looks wrong after conversion — numbers are text, dates are unrecognized, or columns are misaligned — go back to the Text Import Wizard. Select the column that looks wrong, and in the Column Data Format section, choose the correct type (Text, Number, Date, etc.). The preview will update to show the change.
If you have a very large text file (over 100,000 rows), Excel may take a while to open it or may run slowly. This is normal. If Excel crashes, your file may be too large for Excel to handle. In that case, consider splitting the text file into smaller pieces or using a different tool designed for very large datasets.
When to use other formats instead of Excel
Excel works well for structured data with clear rows and columns, but it is not the best choice for every text file. If your text file is a document with paragraphs, use a word processor like Microsoft Word or Google Docs instead. If it is code or configuration data, keep it as text and use a code editor.
CSV format is often better than Excel for sharing data because it is simpler and works with more programs. If you are converting text just to send it to someone else, consider keeping it as CSV instead of converting to .xlsx. CSV files are smaller, load faster, and do not require Excel to open.
For very large datasets or data that needs complex analysis, consider using a database program or a tool like Google Sheets, which can handle some tasks more efficiently than Excel.
Frequently Asked Questions
What is the difference between .txt and .csv files?
Both are text files, but CSV (comma-separated values) has a specific structure where commas separate data into columns. A .txt file is plain text with no assumed structure. Excel recognizes CSV format automatically, but a .txt file may need the Text Import Wizard to tell Excel how to split it into columns.
Will my formulas and formatting survive the conversion?
No. Text files contain only text, no formulas or formatting. When you convert a text file to Excel, you get plain data in cells. If you need formulas or special formatting, you will have to add them after the conversion is complete.
Can I convert an Excel file back to text?
Yes. Open the Excel file, go to File > Save As, choose Text (Tab-delimited) or CSV (Comma-delimited) from the Save as type dropdown, and click Save. Excel will warn you that you are losing formatting; click Yes to proceed. Your Excel data is now a text file.
What if my text file uses a separator that is not comma or tab?
In the Text Import Wizard, look for the "Other" checkbox in the Separators section. Check it and type the character your file uses (semicolon, pipe, colon, etc.). Excel will split your data using that character instead.
Why does Excel show my numbers as text after conversion?
This happens when the Text Import Wizard sets a column to Text format instead of Number format. Select the column, open Text to Columns again, and in the Column Data Format section, change it to Number. Click Finish, and Excel will convert the text to numbers.