Feedback by UserVoice

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

Power Query - Allow to select custom data range on Excel sheet on import

When importing data from non-formatted Excel worksheets (not from tables or defined names) Power Query uses an UsedRange property of worksheet (as described there https://social.technet.microsoft.com/Forums/en-US/9d38f271-2cc6-4170-9a48-1e4f45f6f125/missed-column-from-xlsx-worksheet-on-import?forum=powerquery and there http://excel-inside.pro/blog/2017/05/23/excel-sheet-as-a-source-to-power-query-and-power-bi-a-pitfall-of-usedrange/). This behavior cause problems when there are first empty rows and/or columns on the sheet, which may or may not be imported depending on formats. It creates problems when working with a lot of files in folders.

As Power Query dont work with formats, there is no reason to rely on UsedRange.

Please add an option to
-- select top left cell of the cells range to be imported,
or
-- select range address to be imported,
or
-- start import from the A1 cell

8 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

Maxim Zelensky shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

0 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base