Convert XLSB to TSV
Turn XLSB documents into TSV files. One TSV per worksheet, hidden ones included, and empty sheets are skipped.
Converted in an isolated sandbox on our serversDeleted after 24 hours
Drop XLSB files on the dialor turn it to pick what to do
One TSV for each sheet of your workbook.Every worksheet becomes its own plain-text file, hidden sheets included.
What you get
One TSV file per worksheet. Hidden worksheets are converted too, and empty worksheets are skipped, so you get a file only for sheets that hold something.
Formulas give the last value Excel computed for them. Numbers are written without their display format.
How values are written
Dates are written as YYYY-MM-DD, with the time added when the cell has one. Cells that hold a tab, a quote or a line break are quoted, so each value stays in its own column and row.
Converting one sheet
Set Sheet to a worksheet name or to its number, counting from 1, and only that worksheet is converted. Leave Sheet out and every worksheet is converted.
To join several of the resulting files into one, you can merge TSV.
XLSB 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 Binary Workbook
Excel's binary workbook format, smaller and faster than xlsx for big sheets.
- Extensions
- .xlsb
- MIME type
- application
/vnd .ms -excel .sheet .binary .macroEnabled .12 - 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 XLSB to TSV conversion through the API, for your app or your agent.
$ cv convert report.xlsb report/ --to tsv$ cv convert report.xlsb report/ --to tsvQuestions.What people ask about XLSB to TSV.
Yes. Each worksheet becomes one TSV, except empty worksheets, which are skipped.
Yes. Hidden worksheets are included along with the visible ones.
No. Each formula cell gives its last computed value.
Set Sheet to the worksheet's name or its number, counting from 1. Only that worksheet is converted.