Convert XLSX to TXT Online (Tab-Delimited Text)
How an Excel worksheet becomes plain tab-separated lines, what data it cannot carry, and the encoding and delimiter checks that keep a text import trustworthy.
- Add a file Choose or drop it here
- Pick the format Change it whenever needed
- Download the result After conversion completes
A Workbook Cell Stream Flattened Into Tabbed Lines
An XLSX workbook is a structured Office Open XML package with worksheets, styles, formulas, drawings, and other related parts. A TXT export is not a smaller version of that package. In Excel’s Text (Tab-delimited) format, each exported row ends with a carriage return and the columns are separated by tab characters; Microsoft identifies the tab character as ASCII code 009. The result is a sequence of text lines that another program can split into fields without understanding Excel’s workbook structure. It can represent the displayed text and values from a worksheet, but it has no records for a second sheet, a formula calculation rule, a cell color, a chart, or an Excel table. Converting XLSX to TXT is therefore appropriate only when the receiving system expects a simple row-and-field stream.
The word “text” alone is not enough information for a reliable exchange. Microsoft offers several text choices: tab-delimited text for Windows, Macintosh, and MS-DOS environments, plus Unicode Text for a Unicode character encoding standard. A system that asks for a .txt file may actually require tabs, a particular line ending, a fixed encoding, no header row, or a specific order of columns. Confirm that contract before exporting rather than assuming that any file with the TXT extension will parse correctly. A plain-text editor is valuable after conversion because it reveals actual tab gaps and line endings that a spreadsheet display can hide. Keep the XLSX source because it remains the only copy holding the workbook’s original structure and editable features.
What Excel Writes Into a Tab-Delimited Text File
Microsoft says that a tab-delimited TXT file saves only the text and values as they are displayed in cells of the active worksheet. “Active worksheet” is a hard limit: a workbook with ten tabs does not become one ten-section text file. Excel prompts that only the current worksheet will be saved, and each other worksheet must be exported as a separate text file if it is needed. The exported text follows the visible form of data, which makes display formatting important before conversion. A date or percentage that is shown in a certain form can be sent as that shown text rather than as the underlying spreadsheet calculation. Decide whether the recipient expects display labels or raw standardized values, and prepare the visible columns accordingly before generating the TXT output.
Formula behavior needs a separate check. Microsoft explains that if cells display formulas instead of formula values, the tab-delimited export saves those formulas as text; otherwise the displayed values are what the text file carries. This is not a reliable way to deliver a working calculation model, because a generic text reader has no Excel formula engine. Microsoft’s import guidance says that to preserve formulas when reopening in Excel, use the Text Import Wizard’s Delimited option and select tab characters as delimiters. That instruction is useful for an Excel round trip, not evidence that another application will calculate the formulas. A script or database import should receive a deliberate choice: final values, or literal formula strings it is explicitly designed to understand.
Five Consequences of Choosing TXT Instead of XLSX
- One active sheet becomes one file: Excel’s text formats save the active worksheet, so every required tab needs its own named export.
- Tabs replace cell boundaries: fields are separated by ASCII 009, and rows end with carriage returns instead of workbook cell records.
- All presentation is removed: Microsoft warns that every text format removes formatting; graphics, objects, and other worksheet contents are not retained.
- Formula meaning depends on display: displayed results become values, while cells displaying formulas can export their formula text rather than a calculation model.
- Encoding becomes a compatibility choice: Unicode Text protects a wider set of characters, but an old program that cannot read Unicode can lose the data when opening it.
Readers That Agree on Text and Readers That Do Not
Tab-delimited text is widely readable because the structure is simple, but its simplicity moves interpretation into the receiving program. Excel for Microsoft 365, Excel 2024, Excel 2021, Excel 2019, and Excel 2016 all support text import and export, and Microsoft’s Text Import Wizard can explicitly assign a delimiter and column types. A script may split on tab characters without making any date or number guesses, while Excel may apply a General type unless its import settings are controlled. A database loader may expect UTF-8, whereas a legacy Windows or DOS utility may expect a local code page. The export is compatible only when writer and reader agree about delimiter, encoding, line endings, header status, and data types. Put those rules in the receiving system’s documentation or test file, not in an assumption about the extension.
Unicode is a specific example of a compatibility trade-off. Microsoft describes Unicode Text as Unicode-encoded text, but also warns that opening it in a program that does not read Unicode, such as Windows 95 Notepad or an MS-DOS-based program, loses data. This does not make Unicode unsafe; it means the reader matters more than the filename. For a current importer, Unicode or its documented UTF-8 requirement is often the sensible way to retain accented characters and non-Latin writing. For a truly old importer, test a small file containing the real character set before exporting everything. A file that looks correct in the same Excel installation that wrote it has not yet passed that cross-program test.
The Text-Export Failures Hidden Inside Normal-Looking Cells
Missing worksheet data is the most common surprise because an XLSX file can look like one report while holding several tabs. Microsoft’s export instructions state that only the current worksheet is saved to a text file and tell users to repeat the process for every other worksheet. The fix is not to combine files blindly: give each sheet an explicit output name, confirm its active tab before export, and make the receiving job load all required files. A second problem is fields appearing in the wrong columns after import. The cause is usually a delimiter disagreement, not a broken Excel cell; inspect the TXT in a plain-text editor and confirm that the importer is configured for tab, not comma, space, or automatic detection.
Character corruption has a more precise cause than “special characters are difficult.” Microsoft notes that its non-Unicode tab-delimited text can convert the euro symbol to a question mark, while Unicode text can lose data when read by software that does not support Unicode. Select the encoding the destination documents, then test names, currency signs, apostrophes, quotes, tabs, and line breaks from the actual source data. Also check visible formatting before export, because TXT uses what is displayed in the active sheet. A code with leading zeroes, a long ID displayed in scientific notation, or a date shown in a local pattern can already be misleading before it is written to text. Format those fields as the destination requires and verify several raw lines after export, rather than trying to repair transformed data downstream.
Workbook Package and Tab-Delimited Text Compared
| Detail | XLSX workbook | Tab-delimited TXT |
|---|---|---|
| Structure | Office Open XML package with worksheet parts | Lines of text with tab-separated fields |
| Sheets | One or more worksheets | Active worksheet only per export |
| Field separator | Cell records inside worksheet XML | Tab character, ASCII 009 |
| Formatting and graphics | Can store styles, drawings, and objects | All formatting removed; objects and graphics lost |
| Formula handling | Stores calculation rules and values | Displayed value or formula text, depending on display |
| Encoding decision | Part of XML package rules | Tab text variant or Unicode choice must match reader |
Questions Before a Script Receives an XLSX Export
Does XLSX to TXT export every sheet in the workbook?
No. Microsoft says text export saves only the active worksheet. Export each necessary worksheet separately and verify that the receiving process loads the corresponding files.
What character separates columns in a tab-delimited TXT file?
Excel uses the tab character, ASCII 009, between columns and a carriage return at the end of each row. Configure the importer for tabs rather than relying on automatic separator detection.
Will formulas still calculate in the text file?
No. TXT has no Excel calculation engine. Exported output holds displayed values or, when cells display formulas, formula text; retain XLSX when live calculations must continue.
Why did a symbol become a question mark after export?
The selected non-Unicode text format may not represent that character; Microsoft specifically notes the euro symbol can become a question mark. Use an encoding the destination supports and test it with real data.