The simplest way to convert a TXT file to XLS format

The fastest route is to open your text file directly in Microsoft Excel, then save it as an Excel file. Excel can read plain text files and will automatically split the data into columns if it recognizes a pattern — usually a comma, tab, or space between values. If your text file is already organized with consistent separators between data points, this method takes about two minutes.

If your text file contains unstructured data or you need more control over how the columns are created, you will need to use Excel's Text to Columns feature, which lets you choose exactly where the splits happen. This adds a few extra steps but gives you precision over the final layout.

A third option is to copy and paste the text into Excel manually, which works well for small files or when you want to arrange the data yourself as you go. For very large files or data you plan to reuse, the first two methods are more reliable.

Key Takeaways

  • Opening a TXT file directly in Excel and saving it as XLS works for most files, especially those with consistent separators like commas or tabs between values.
  • Excel's Text to Columns feature gives you control over where data splits into separate columns, which is useful when your text file has irregular spacing or formatting.
  • The conversion process does not change your original text file — you are creating a new Excel file, so your TXT file stays intact.
  • After conversion, check that numbers appear as numbers (right-aligned) and dates are recognized correctly, since Excel sometimes imports them as text.

Opening and saving a TXT file as XLS in Excel

Start by opening Microsoft Excel. Go to File, then Open. Navigate to the folder where your text file is stored and select it. The file will appear in Excel with all the text in a single column. If the text contains commas, tabs, or other consistent separators, Excel may have already split it into multiple columns automatically — if so, you are done with the hard part.

Once the file is open and the data looks correct, go to File and choose Save As. In the dialog box, change the file format from "Text (Tab delimited)" or whatever format Excel shows to "Excel Workbook" or "Excel 97-2003 Workbook" depending on whether you want a modern .xlsx file or the older .xls format. Type a new filename and click Save. Excel will ask whether you want to keep the file in Excel format — click Yes.

Your original TXT file remains unchanged in its folder. You now have a separate Excel file with the same data. If the data did not split into columns the way you wanted, move to the next section.

Using Text to Columns when data does not split automatically

If your text file opened in Excel but everything is still in one column, or the columns are not in the right places, use the Text to Columns feature. First, select all the data in the column by clicking the column header (the letter at the top). Go to the Data menu and click Text to Columns.

A dialog box will open with three steps. In Step 1, choose the delimiter — this is the character that separates your data. If your file uses commas, check Comma. If it uses tabs, check Tab. If it uses spaces, check Space. If the separator is something else (like a pipe symbol |), check Other and type the character. You will see a preview at the bottom showing how the data will split.

Click Next to move to Step 2, where you can adjust column widths if needed — usually you can skip this. Click Next again for Step 3, where you can set the data type for each column (text, number, date, etc.). Most of the time the defaults are fine. Click Finish, and Excel will split your data into the correct columns.

Now save the file as described in the previous section. Go to File, Save As, change the format to Excel Workbook, and click Save.

Handling numbers and dates that import as text

After conversion, check whether numbers look right. Numbers that Excel recognizes as numbers are right-aligned in their cells; text is left-aligned. If your numbers are left-aligned, they imported as text, which means formulas and sorting will not work correctly.

To fix this, select the column with the numbers, go to Data, and click Text to Columns again. Go through the steps without changing anything — just click Finish. Excel will convert the text to actual numbers. The same process works for dates that imported as text.

If only a few cells have this problem, you can also select them, go to the Data menu, and look for a small yellow warning icon that says "Convert to Number" — click it and Excel will fix those cells when ready.

Copy and paste for small files or custom layouts

If your text file is short or you want to arrange the data yourself as you place it, copy and paste is the most straightforward method. Open your text file in Notepad or any text editor. Select all the text (Ctrl+A on Windows, Command+A on Mac), then copy it (Ctrl+C or Command+C).

Open Excel and click on the cell where you want the data to start — usually A1 in the top left. Paste the text (Ctrl+V or Command+V). The text will appear in that cell or column. From there, you can manually split it into columns by cutting and pasting sections, or use Text to Columns as described above.

This method is slower for large files but gives you the most control and works well when you want to clean up or rearrange data as you go.

Saving in different Excel formats

When you save your file, Excel offers several format options. The most common are Excel Workbook (.xlsx), which is the modern standard and works on all recent versions of Excel, and Excel 97-2003 Workbook (.xls), which is the older format. Most people should choose .xlsx unless you know the person receiving the file uses very old software.

If you need the file in a different format — such as CSV (comma-separated values) or ODS (OpenDocument Spreadsheet, used by LibreOffice) — you can save it in those formats too. Go to File, Save As, and look through the format dropdown menu. The file will convert to that format when you save.

Keep in mind that some formatting, formulas, or features may not transfer perfectly between formats, especially when saving to older formats like .xls. If you plan to edit the file further, .xlsx is the safest choice.

Checking your converted file for errors

After conversion, spend a minute reviewing the data to make sure nothing went wrong. Scroll through and check that columns are in the right order, that numbers are not cut off, and that any dates are formatted correctly. Look for cells that should contain numbers but show text instead — these will be left-aligned instead of right-aligned.

If you notice problems, you can undo the save (Ctrl+Z or Command+Z) and try again with different settings in Text to Columns, or go back to your original text file and check whether the data itself has formatting issues that need to be fixed first.

Once you are satisfied with the layout, save the file one more time to make sure all changes are stored. Your text file is now in Excel format and ready to use.

Frequently Asked Questions

Will converting a TXT file to XLS change the original text file?

No. When you open a text file in Excel and save it as an Excel file, you are creating a new file. Your original TXT file stays exactly as it was in its folder. You now have two separate files — the original text file and the new Excel file.

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

Open the text file in Notepad to see what character separates the data. Common separators are commas, tabs, spaces, pipes (|), or semicolons. Once you identify it, use Text to Columns and select that character as the delimiter. If it is not in the standard list, check the Other box and type the character.

Can I convert a TXT file to XLS without Microsoft Excel?

Yes. LibreOffice Calc and Google Sheets can both open text files and save them as Excel files. The process is similar: open the file, let the program split the data into columns, then save it in Excel format. Online conversion tools also exist, though uploading sensitive data to a website carries privacy risks.

Why do some of my numbers show as text after conversion?

Text files do not distinguish between numbers and text the way Excel does. If your numbers imported as text (left-aligned instead of right-aligned), select the column and use Data > Text to Columns, then click Finish without changing settings. Excel will convert them to actual numbers.

What is the difference between XLS and XLSX?

XLS is the older Excel format, and XLSX is the modern format. XLSX files are smaller, more find, and work on all current versions of Excel. Unless you are sending the file to someone using very old software, choose XLSX. Both formats work the same way for basic spreadsheets.