Power Query Problems

Fix Power Query Unexpected-Format Errors for XLSB Files in Excel

Tauseeq MagsiTauseeq Magsi Nov 14, 2026 870 views

Question details

The user needs to import an Excel Binary Workbook into Power Query without an unexpected-format error.

Fix Power Query Unexpected-Format Errors for XLSB Files in Excel
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.
Before you start

Confirm that the source file has an .xlsb extension and can be opened in Excel. Have another XLSB file available for comparison if possible.

Solution 1Recommended

Update Office and retry the XLSB import

Use this first to check whether an Office update resolves the import error.

1
Open Office update settings

In Excel, select File > Account > Update Options.

2
Install available updates

Select Update Now and follow the prompts to install any available Office updates.

3
Retry the import

Restart Excel, then select Data > Get Data > From File > From Excel Workbook and choose the XLSB file.

Update Office and retry the XLSB import
Update options may differ: If Update Options is unavailable, Office updates may be managed by your organization. Contact your administrator.
Free Microsoft Office alternative

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.

Review and edit spreadsheet data in WPS SpreadsheetsCompatible with common Microsoft Excel formats, including XLSX and XLSFamiliar interface for an easier transition from ExcelFree and lightweight for everyday office work
QA img-9

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.