Convert XLSB to XLSX

Some spreadsheet applications, document-management systems, and web services accept .xlsx but reject Excel’s binary .xlsb format. Converting the workbook provides an XML-based file that is easier to share, edit, and process in non-Excel software.

What the XLSB format is

XLSB is Microsoft Excel’s binary workbook format, introduced with Excel 2007. It stores workbook structures and worksheet data in a binary representation instead of the XML parts used by XLSX.

Excel users commonly choose File → Save As → Excel Binary Workbook (*.xlsb) for large models, reporting workbooks, and automated processes. XLSB can reduce file size and improve opening, saving, and calculation performance, although the result depends on the workbook’s contents. It can also contain VBA macros.

What the XLSX format is

XLSX is Excel’s XML-based workbook format and the default format for current versions of Excel. An XLSX file is a ZIP package containing XML worksheets, styles, relationships, shared strings, charts, and other workbook parts.

XLSX is supported by Microsoft Excel, Excel for the web, LibreOffice Calc, Apple Numbers, Google Sheets import, and many document-processing services. It is usually a better choice for interoperability and browser-based or document-management workflows, but XML packaging can make an XLSX file larger than the equivalent XLSB.

XLSX cannot retain a VBA project. If the workbook contains macros that must remain available, save it as .xlsm rather than .xlsx.

How to convert XLSB to XLSX

Microsoft Excel desktop

1. Make a copy of the original workbook.xlsb and open it in Microsoft Excel.
2. Check important worksheets, formulas, charts, tables, pivot tables, external links, and data connections before saving.
3. Select File → Save As.
4. Choose a destination, set the file type to Excel Workbook (*.xlsx), and save the copy as workbook.xlsx.
5. If Excel displays a compatibility warning, review the listed features before confirming. If VBA macros must be preserved, cancel the operation and select Excel Macro-Enabled Workbook (*.xlsm) instead.
6. Close and reopen the resulting .xlsx in the application that will use it, then test the workbook’s critical functions.

Excel desktop is normally the most reliable converter because it has the best compatibility with Excel formulas, formatting, charts, pivot tables, connections, and XLSB-specific workbook behavior.

LibreOffice Calc

LibreOffice Calc can open many XLSB workbooks and export them by selecting File → Save As and choosing Excel 2007–365 (*.xlsx). Use a current LibreOffice release and treat the result as a compatibility conversion: advanced formulas, pivot tables, conditional formatting, external data connections, embedded objects, and VBA may be altered, unsupported, or discarded. Reopen the exported file and compare it with the original.

Online converters

Services such as CloudConvert and Zamzar may provide XLSB-to-XLSX conversion in a browser. The usual process is to upload the .xlsb file, select XLSX as the output format, start the conversion, and download the generated file. Availability, file-size limits, and supported features can change, so verify the service’s current format list before uploading.

Online conversion transfers the workbook to a third-party server. Do not use it for confidential, regulated, or proprietary data unless the provider’s encryption, retention, deletion, and processing terms satisfy your requirements. Desktop Excel or LibreOffice is preferable for sensitive workbooks.

Quality and compatibility limitations

• Macros: Saving as XLSX removes VBA project data. Use .xlsm when macros must remain functional.
• Feature warnings: Excel may report unsupported legacy controls, embedded objects, external connections, custom XML, or other extensions. The warning identifies content that may not survive the conversion.
• External data: Links to other workbooks, databases, queries, and refresh credentials may require reconnection or recalculation in the target application.
• Formula results: Formulas are generally retained by Excel, but volatile formulas, unsupported functions, links, and cached values can produce different results after conversion. Recalculate and verify key outputs.
• Validation: Check formulas, named ranges, filters, charts, pivot tables, conditional formatting, print areas, page breaks, data validation, and connections in the converted file.
• Protection and encryption: Password-protected or encrypted workbooks may need to be unlocked in Excel before conversion; never upload such files to an online service without confirming its security requirements.