Convert XLS to TXT
Turn XLS workbooks into TXT files. One tab-separated text file per worksheet, as spreadsheets save Text (Tab delimited), in UTF-8 and with hidden sheets included.
Converted in an isolated sandbox on our serversDeleted after 24 hours
Drop XLS files on the dialor turn it to pick what to do
One tab-separated text file for each worksheet.Values are written as text in UTF-8, the way Excel saves Text (Tab delimited).
What you get
One TXT file per worksheet in the workbook. Each file is tab-separated, in UTF-8, so it opens in a text editor or imports into other tools as plain columns.
Hidden sheets are included. Chart sheets and empty sheets are skipped, so they produce no file.
What the cells become
Formulas give their last computed values, not the formulas. Dates are written as YYYY-MM-DD. Numbers are written without their display format.
A cell that holds a tab, a quote or a line break is quoted, so it stays in one cell when the file is read back. A merged cell keeps its text in its first cell.
Web page and XML files
Some files with an .xls extension are really web pages. For these, each table becomes one sheet, named as the page names its sheet. A file saved as XML Spreadsheet 2003 gives each worksheet with its values.
Choosing a sheet
Set Sheet to the name of one worksheet, or to its number counting from 1, to convert only that sheet. When Sheet is left out, every worksheet is converted. To join the resulting text files afterward, you can merge TXT.
XLS and TXT.What each format is, and the options this conversion takes.
- 01 · sheet
Sheet
The one worksheet to convert, by its name or by its number counting from 1. Every worksheet is converted when it is left out.
The formats
Excel 97-2003 Workbook
The binary Excel workbook format from Excel 97 through 2003, and its templates (.xlt). WPS Spreadsheets saves the same format as .et and .ett.
- Extensions
- .xls .xlt .et .ett
- MIME type
- application
/vnd .ms -excel - Kind
- Documents
Plain Text
Plain text with no formatting at all. The smallest, most portable form of a document.
- Extensions
- .txt .log
- MIME type
- text
/plain - Kind
- Text and data
In your code.The same XLS to TXT conversion through the API, for your app or your agent.
$ cv convert sheet.xls sheet/ --to txt$ cv convert sheet.xls sheet/ --to txtQuestions.What people ask about XLS to TXT.
One file for each worksheet that is converted. Chart sheets and empty sheets are skipped.
No. Each formula cell gives its last computed value.
As YYYY-MM-DD.
Yes. Set Sheet to the sheet's name or its number counting from 1.