Feedback by UserVoice

David MC

My feedback

  1. 4,028 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1025 comments  ·  Excel for Mac » Data Import  ·  Flag idea as inappropriate…  ·  Admin →

    Hi all! We are happy to let you know that in addition to refreshing your data from supported sources, you can now import data from local files such as Excel workbooks, and Text and CSV files with Power Query in Excel for Mac. This new functionality is available to Beta channel users running version 16.50 (build 21050400) or later.
    You can check out the blog for this new feature here: https://insider.office.com/en-us/blog/import-data-from-local-files-with-power-query-in-excel-for-mac
    For more information about Power Query features that are currently supported in Excel for Mac, please take a look at the following support article: https://support.microsoft.com/office/7b2f337d-e7d2-4fdf-bf00-3dfbb1e5e9c5

    Inbar Privman
    Product Manager, Excel Team

    An error occurred while saving the comment
    David MC commented  · 

    Hey @Guy. Thanks for the response. I can definitely understand the cost and the lift, but I think the frustration you are hearing in all of our responses is because this enhancement request was submitted in 2015 and has spent over a year and a half as the number one most requested feature. A staged delivery plan is a great option, but I think most of us feel this stage (refresh only) should have come 18 months ago. I think it would help us positively support this development if you would share where this work is on the product development timeline in relation to the other enhancements being considered. Also, that would help us know for how much longer we need to keep using something with parity cost to the windows platform, but not parity in features.

    An error occurred while saving the comment
    David MC commented  · 

    Nope. Sorry. Go back and try again. As I said in my previous post: "We don't simply want a way to refresh PQ connections in Excel for Mac, we NEED a way to create and edit M-Code in PQ for Mac. And, frankly, we need it yesterday. Figure it out."

    An error occurred while saving the comment
    David MC commented  · 

    I am still confused about this update. I am running v.16.27 and in my XLSX file, I still do not see a way to edit a PowerQuery connection made in Excel for Windows. If this isn't possible with the most recent "fast insiders" release than this isn't an answer to our request at all. We don't simply want a way to refresh PQ connections in Excel for Mac, we NEED a way to create and edit M-Code in PQ for Mac. And, frankly, we need it yesterday. Figure it out.

    David MC supported this idea  · 

Feedback and Knowledge Base