Fix Excel Power Query Not Showing or Opening XLSB Tables
Question details
The user needs Excel Power Query to display and open tables from an XLSB workbook.

- Product
- Microsoft Excel Power Query
- Device & OS
- not provided
- Scenario
- Importing tables from an XLSB workbook through Power Query Navigator.
- Observed behavior
- Some Excel versions do not show XLSB tables in Navigator or display the error “External table is not in the expected format,” while XLSM sources work.
Confirm that the source workbook opens normally in Excel and identify the tables you expect to see in Navigator. Note your Excel version under File > Account so you can compare results after updating.
Update Excel and retest the XLSB workbook
Use this first to check whether an Excel update resolves the issue in your version.
In Excel, select File > Account > Update Options > Update Now. If Update Options is unavailable, contact your administrator or check how your Office installation is updated.
Restart Excel, then select Data > Get Data > From File > From Workbook and choose the XLSB file. Check whether its tables appear in Navigator or the error still occurs.

Use an XLSM or XLSX workbook as the Power Query source
Use this workaround when the XLSB source still fails and you can change the source format.
Collect details and report a reproducible XLSB failure
Use this when updating or changing the source format does not resolve the problem, or when XLSB is required.
Work with Excel-format spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for everyday spreadsheet work. Its Excel-format compatibility can make it easier to move existing files into WPS, though it does not fix Microsoft Excel Power Query issues.

Frequently Asked Questions
Why are XLSB tables missing from Power Query Navigator?
This has been reported with some Excel Power Query versions and may depend on the workbook. Update Excel through File > Account > Update Options > Update Now, then test the source again.
What can I do about the external table format error?
First, check that the XLSB workbook opens in Excel. If Power Query still reports “External table is not in the expected format,” try saving the source as XLSM or XLSX and import that file through Data > Get Data > From File > From Workbook.
Should I save the source as XLSM or XLSX?
Use File > Save As and choose XLSM if the workbook contains VBA macros you need. Choose XLSX if macros are not needed; XLSX does not retain VBA macros.
How do I report an XLSB import problem to Microsoft?
In Excel, select Help > Feedback. Include your Excel version, the import steps, the exact error or missing-table behavior, and sample-file details that you can safely share.




