Feedback by UserVoice

 

How can we improve Excel for Windows (Desktop Application)?

← Excel for Windows (Desktop Application)

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

86 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Roger Govier shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

18 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment

Excel for Windows (Desktop Application): Data Import

Categories

Feedback and Knowledge Base

(thinking…)