Show Tables in Power Query when opening an xlsb file
When using Power Query / Get Data to open .xlsx files and .xlsm files, the Tables present in those files are shown in a list.
When opening a .xlsb file only Sheets are shown and not any of the Tables present within the file.
If there is only one table on a sheet, AND it starts in cell A1, then it is relatively easy to still load the data, but where there are multiple tables per sheet, OR the tables don't start in A1, then there is a lot of unnecessary work deleting Rows and or Columns to obtain your data.
Please make the treatment of .xlsb files the same as .xlsx files or provide a new Connector to deal specifically with .xlsb

Thank you for posting and voting for this. Unfortunately, this is something we are not planning to add any time soon.
Inbar Privman
Program Manager, Excel Team
22 comments
Comments are closed-
Anonymous commented
I NEED this. PLEASE fix this issue with XLSB!
-
Pascal commented
This has been ongoing for two years now, you have any ETA to resolve this?
-
Jörn Letschert commented
Bugfix would be utmost appreciated!
-
Ivan commented
I join to this voting
XLSB is the perfect format for bulk Excel files and should be used for Power Query with no limitations -
Jerry Norbury commented
XLSB files are also TORTUROUSLY slow to load when they have many sheets...
-
Steve commented
In my company we use lot of XLSB files and it's my sources as well for PQ.
This issue was driving me made until I found some info with this bug. I almost reached a decision: stop using PQ as it's not reliable for some unknown reasons. Now that I know why I vote for a resolution of this issue.
Please !!!!! -
Emiliano commented
yes... It would be important!
-
Alojz Lacko commented
Seems it is not solved for almost 2 years. Will that ever be? Let's hope, or what?
-
Anonymous commented
Important to get this fixed
-
Paul Coates commented
Definitely needed
-
Josue Jonnathan Berrios Achire commented
Definitely needed
-
Anonymous commented
yes please.
-
Anonymous commented
Agreed
-
Bev commented
Yes, definitely required
-
Anonymous commented
Yes its definitely needed
-
Marian commented
Agreed Roger
-
Marian commented
Definitely needed
-
Anonymous commented
Yes please.
-
Anonymous commented
Definitely needed
-
Guido commented
Absolutely required.