Convert XLS to TXT Online
What an old Excel workbook becomes when it is reduced to a plain text file.
- Add a file Choose or drop it here
- Pick the format Change it whenever needed
- Download the result After conversion completes
The 1997-to-2003 Workbook Hidden Behind an XLS Extension
An XLS file is the older binary workbook used by Excel 97, 2000, 2002, and 2003. Microsoft documents it as MS-XLS, commonly called BIFF8. It is not a text table and it is not the ZIP package used by newer XLSX files. A classic XLS workbook can contain several sheets, cell formulas, number formats, charts, names, print settings, links, and sometimes macro code. Its worksheet grid stops at 65,536 rows and 256 columns, ending at column IV. That older limit is useful evidence when an apparently large workbook is being exported: no genuine XLS sheet can hold a row beyond 65,536 or a column beyond IV.
TXT is much plainer. It is a stream of characters with line breaks; it has no standard workbook container, sheet tab, formula language, font setting, or fixed rule saying which character separates columns. A converter must choose a representation, usually tab-delimited text, and must decide which worksheet to export. That decision matters more than the three-letter extension. A text result can be excellent for an import program, a command-line tool, or inspection in a text editor, while being a very poor archival substitute for a working Excel model.
How Cell Records Turn Into Lines and Separators
The physical change is severe. BIFF8 stores typed cell records and workbook records inside Microsoft’s compound binary file structure. Text export writes the displayed or selected cell values as characters. A tab character normally marks the jump from one column to the next, and a carriage-return/line-feed marks the next row. That means the target has no place to retain a formula such as =SUM(B2:B20) as live behavior. It may carry the last calculated result, but it cannot recalculate after a value changes. A formatted date may also become whatever text the exporter displayed, rather than a date value with its original number format.
Tabs and line breaks already present inside cells need special care. Microsoft’s text-import guidance explains that a delimiter tells the importer where one value ends, while a text qualifier can protect a delimiter inside a value. A bare tab-delimited TXT file has no universal quoting convention comparable to CSV, so a literal tab in an address or a line break in a comment can split one source cell into several imported cells or rows. Choose an export that documents its delimiter and encoding, then inspect those difficult cells in a code editor before sending the file onward.
Useful Things Plain Text Keeps and Important Things It Cannot Carry
- Keep ordinary values: numbers and labels become easy-to-read characters, which suits many import tools.
- Keep row order: a tab-delimited export can preserve the order of cells on the chosen sheet.
- Lose extra sheets: one flat text file has no sheet-tab system; export each needed sheet separately.
- Lose live formulas: TXT can show a result but cannot hold Excel’s dependency rules or recalculate them.
- Lose visual instructions: colors, merged cells, widths, frozen headings, charts, and print areas are not plain text.
- Risk type changes: identifiers such as 00127 can be interpreted as numbers when a later program imports them.
The leading-zero risk is not cosmetic. In the XLS source, a value may be a text cell or a number shown with a custom format. Once it becomes the characters 00127, the next importer chooses whether to keep those characters or turn them into the number 127. Dates have the same problem: 03/04/2026 is ambiguous between day-first and month-first settings. Use a small test import with account codes, dates, currency, percentages, and long notes before treating the text file as a safe exchange format.
What Excel and Other Programs Actually Do With Text Exports
Excel can open and import delimited text, but the receiving settings decide the result. Microsoft’s Text Import guidance distinguishes delimited input from fixed-width input and lets a user choose a delimiter and text qualifier. It is safer to use an import path that exposes those choices than to double-click an unknown text file and accept automatic guesses. A locale that uses comma decimals, for example, can interpret a field differently from the system that produced it. UTF-8 is usually the best shared encoding when names or labels include non-English characters, but check the receiver’s documentation if it requires an older code page.
Modern Excel still opens old XLS files for backward compatibility. LibreOffice Calc can also open XLS and import text, but neither fact makes a text export reversible. A TXT file can be reopened as a table only after software guesses or is told its structure. It cannot restore a second worksheet, a chart, a formula, or the original column widths. Keep the unchanged XLS file and use TXT as a delivery copy with a clearly stated delimiter.
Why a Text Result Can Look Broken When the Source Was Fine
The common complaint is “everything landed in one column.” That does not mean the XLS conversion failed. It usually means the receiving program expected commas while the file uses tabs, or the file was opened as fixed-width text. Import it again, select the actual delimiter, and use a text qualifier where applicable. The opposite failure is a name or address split across columns because the value itself contains the delimiter. Inspect the original cell and either choose a safer delimiter or use an import process that supports quoted fields.
Another real failure is an apparently altered total. XLS formulas may have external workbook references, and plain text receives only the value available when the export ran. If the source had not recalculated, the text file may carry an old cached result. Open the XLS safely, check link prompts, calculate the relevant sheets, and compare several totals before export. Do not use TXT for a report that must demonstrate formulas or audit logic; use a workbook or a fixed rendering alongside it.
XLS and TXT at the Points That Matter During an Import
| Check | XLS | TXT export |
|---|---|---|
| Internal form | BIFF8 binary workbook | Characters and line breaks |
| Sheet capacity | 65,536 rows, 256 columns | No worksheet model |
| Sheets | Can contain many | One flat stream |
| Formulas | May be live | Not supported |
| Column boundary | Cell record | Chosen delimiter, often tab |
| Formatting | Stored in workbook records | Not stored |
Questions People Ask Before Sending an XLS File as Text
Does TXT contain every worksheet?
No. A plain text file has no worksheet tabs. Export each required sheet separately and name the files clearly.
Will formulas still work after conversion?
No. Text can retain a displayed result, not the formula engine or its references.
Why did all values import into column A?
The importer probably used the wrong delimiter. Import the file and select tab, comma, or the separator actually used.
Can I preserve 00127 as written?
Yes, if the receiving importer treats that field as text. Test it; automatic number detection may remove zeros.
Is changing .xls to .txt enough?
No. Renaming does not turn BIFF8 records into text. A real export must write the values and separators.
There is one Excel text format with a documented trap worth separating from ordinary tab-delimited TXT. Microsoft says that Formatted Text (Space Delimited), also called PRN, is limited to 240 characters per line; extra characters wrap onto the next line by design. That is not the same as a cell's 32,767-character Excel limit. If the receiving system asks for fixed-width or PRN text, a long description can therefore become a second physical line and make the next record appear shifted. Use a tab-delimited export when the receiver supports it, or test the exact fixed-width specification with a deliberately long field.
Blank cells also create a measurable difference. A row with five source columns can appear in text as four separators even where two fields are empty. Some importers preserve those empty positions; others trim trailing delimiters and then report fewer fields. Compare a row with an empty middle field and a row with an empty final field. If a converter displays formulas rather than values, determine which the receiving system expects before release. Plain text has no formula marker, so a result such as 42 and a formula string such as =SUM(A1:A3) are both merely characters once written.
For records with commas, quotes, tabs, and embedded line breaks, CSV may be more suitable only when both ends agree on CSV quoting. Excel's text import interface supports a text qualifier, but a bare TXT contract must state how those characters are handled. A safe conversion note can say: UTF-8, tabs between fields, CRLF between records, first row is headings, and no embedded tabs or line breaks. That small specification is far more useful to an import operator than the generic word TXT.