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).

  1. 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.

  2. 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.

  3. 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.

  4. 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.

  1. 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

From · XLS

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
To · TXT

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.

terminal
$ cv convert sheet.xls sheet/ --to txt
$ cv convert sheet.xls sheet/ --to txt

Questions.What people ask about XLS to TXT.

01OF 04

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.

More conversions.Other ways in and out of XLS and TXT.