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.
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.
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.
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.
- 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
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.
$ cv convert sheet.xls sheet/ --to tsv$ cv convert sheet.xls sheet/ --to tsvQuestions.What people ask about XLS to TSV.
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.