Convert XLSB to CSV

Turn XLSB documents into CSV files. One CSV 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

Every worksheet as its own CSV.Each sheet in the workbook becomes a separate file of plain rows.

  1. What you get

    One CSV per worksheet. Hidden worksheets are included, and empty worksheets are skipped, so the number of files can differ from the number of tabs you see.

    Formulas give their last computed values. Dates are written as YYYY-MM-DD, with the time added when the cell has one. Numbers are written without their display format.

  2. Converting one sheet

    Set Sheet to the name of a worksheet, or to its number counting from 1, and only that worksheet is converted. Leave it out and every worksheet is converted.

  3. When it fails

    If the file cannot be parsed, the conversion stops with input_corrupted. No CSV files come from that workbook.

    To join the resulting files into one table, try merge CSV.

XLSB and CSV.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 · XLSB

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

CSV

Rows of comma-separated values. The plainest way to move a table between programs.

Extensions
.csv
MIME type
text/csv
Kind
Text and data

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

terminal
$ cv convert report.xlsb report/ --to csv
$ cv convert report.xlsb report/ --to csv

Questions.What people ask about XLSB to CSV.

01OF 04

One CSV for each worksheet. Hidden worksheets are included, and empty ones are skipped.

Each formula cell gives its last computed value.

As YYYY-MM-DD, with the time added when there is one.

Yes. Set Sheet to the worksheet's name or its number counting from 1.

More conversions.Other ways in and out of XLSB and CSV.