Convert XLS to TSV

Turn XLS workbooks into TSV files. One TSV per worksheet, hidden ones 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 TSV for every worksheet.Each sheet in the workbook becomes its own plain text file, with dates and values written out as text.

  1. What you get

    One TSV file per worksheet. Hidden worksheets are included, so a workbook with several sheets gives several files.

    Formulas are written as the last values they computed. Dates are written as YYYY-MM-DD. Numbers are written without their display format.

  2. What is skipped

    Chart sheets and empty sheets produce no file. Only worksheets that hold cells are converted.

    Cells that hold a tab, a quote or a line break are quoted, so each value stays in its own column and row.

  3. Choosing one sheet

    Set Sheet to convert one worksheet. Give its name, or its number counting from 1. When Sheet is left out, every worksheet is converted.

    To go the other way, use TSV to XLS.

XLS and TSV.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 · TSV

Tab-Separated Values

Tab-separated values.

Extensions
.tsv .tab
MIME type
text/tab-separated-values
Kind
Text and data

In your code.The same XLS to TSV conversion through the API, for your app or your agent.

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

Questions.What people ask about XLS to TSV.

01OF 04

One TSV per worksheet. Set Sheet if you want only one of them.

Yes. Hidden worksheets are converted along with the visible ones.

Each formula cell is written as the last value it computed. The formula itself is not written.

As YYYY-MM-DD. Numbers are written without their display format.

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