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

11 comments
-
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.
-
Jan Karel Pieterse commented
Yes, please!
-
Wyn Hopkins commented
Agreed Roger