Fix Power Query Unexpected-Format Errors for XLSB Files in Excel
Question details
The user needs to import an Excel Binary Workbook into Power Query without an unexpected-format error.

- Product
- Microsoft Excel Power Query
- Device & OS
- not provided
- Scenario
- Importing an XLSB workbook into Excel using Power Query.
- Observed behavior
- Power Query reports an unexpected-format error for an XLSB file, while other Excel formats import correctly.
Confirm that the source file has an .xlsb extension and can be opened in Excel. Have another XLSB file available for comparison if possible.
Update Office and retry the XLSB import
Use this first to check whether an Office update resolves the import error.
In Excel, select File > Account > Update Options.
Select Update Now and follow the prompts to install any available Office updates.
Restart Excel, then select Data > Get Data > From File > From Excel Workbook and choose the XLSB file.

Test the import in Excel Safe Mode on Windows
Use Safe Mode to check whether an add-in or startup customization is contributing to the error.
Compare the affected XLSB file with other workbooks
Test additional files to determine whether the error is specific to one workbook or affects XLSB imports more broadly.
Work with spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Its support for common Excel formats makes it easy to move everyday spreadsheet work to WPS, though it does not fix Microsoft Excel Power Query errors.

Frequently Asked Questions
How do I update Excel before retrying the import?
In Excel, select File > Account > Update Options > Update Now. If your organization manages Office updates, contact your administrator if the option is unavailable.
How can I tell if the XLSB file itself is the problem?
Try importing another XLSB file through Data > Get Data > From File > From Excel Workbook. You can also save a new test workbook as an Excel Binary Workbook and import it for comparison.
What should I do if the import works in Safe Mode?
On Windows, restart Excel normally and check File > Options > Add-ins. Use the Manage list to open COM Add-ins, then disable add-ins one at a time and retest.
Can WPS Office fix the Power Query error?
No. The error occurs in Microsoft Excel Power Query, so troubleshoot it in Excel. WPS Office is an alternative for working with common spreadsheet formats such as XLSX and XLS.




