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

45 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    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 →

    11 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Forgot password?
      Create a password
      Signed in as (Sign out)
      Close
      Close
      Submitting...

      Excel for Windows (Desktop Application): Data Import

      Feedback and Knowledge Base

      (thinking…)