Old Excel software and some older business systems cannot open modern .xlsx files. They need the older .xls format, the binary Excel format used before 2007. If your data is sitting in a plain text file, you do not need to retype it into a spreadsheet. This guide shows how to convert text into an .xls spreadsheet, with each line becoming a row and each value becoming a cell.
How text becomes a spreadsheet
A plain text file has no grid, no cells, and no formatting. A spreadsheet has rows and columns. The conversion needs two rules to bridge that gap. First, each line of text becomes one row in the spreadsheet. Second, each value on that line becomes one cell, split by a separator. In this tool, the separator is the tab character, which is the invisible character you get when you press the Tab key. If your text uses commas or spaces instead of tabs, you will need to replace them with tabs first, or the whole line will land in a single cell.
How to convert text to an XLS spreadsheet
- Prepare your text with one row per line. Each line should hold one record, such as one product, one name, or one entry.
- Separate the values with tabs. Put a tab between each value on a line, so the converter can tell where one cell ends and the next begins.
- Paste the text or upload the .txt file. Pasting works for short lists. Uploading the file is easier for longer reports.
- Convert and download the .xls file. The tool builds the spreadsheet in your browser, with no sign-up, and gives you a file to download.
- Open the file and check it. Open it in Excel, LibreOffice Calc, or your old software, and confirm each row and column landed correctly.
- Save it under a clear name. Rename the download to something meaningful, such as stock-list.xls, so you can find it later.
A worked example
An old stock system exports a plain text report: one product per line, with the name, price, and quantity separated by tabs. Pasted into the converter, each line becomes one row, and each tab-separated value becomes one cell. The downloaded .xls file opens in the old software, and the team can sort and filter it like any spreadsheet. If the report had used commas instead of tabs, the same method would still work, as long as the separator is consistent on every line.
Mistakes to avoid
- Do not mix separators on different lines. If line one uses tabs and line two uses commas, the columns will not line up.
- Do not expect formatting to survive. Plain text has no bold, no colours, and no formulas, so the spreadsheet will be plain too.
- Do not use .xls for a brand new project. Modern software prefers .xlsx, which is safer and faster. Use .xls only when old software demands it.
- Do not skip the open-and-check step. Open the downloaded file and confirm the rows and columns landed where you expected.
Try it faster with the free tool
The free Text to XLS Converter below turns pasted text or a .txt file into a legacy Excel .xls file, the old Excel format made for old Excel versions and old software that cannot open modern .xlsx files. Each line becomes one row, and each tab-separated value becomes one cell. It runs in your browser, with no sign-up.
Try it here: Text to XLS Converter Online.
One line per row, one tab per cell, and a quick check in a spreadsheet app. That is all it takes to turn plain text into a real spreadsheet.