Feedback by UserVoice

How can we improve Excel for Mac?

Add support for Get & Transform (formerly Power Query)

Make Get & Transform (formerly Power Query) available in Excel for Mac (like in Excel for Windows)

3,400 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
planned  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded  · 

Hi all,

We are glad to announce that the first phase of the project is available for Insiders Fast. At this stage we support refresh from text, CSV, XLSX, JSON and XML files.

Refer to the following blog post for more details:
https://blog-insider.office.com/2019/05/30/you-asked-for-it-a-journey-to-power-query-in-excel-for-mac-starts-now/

I encourage you to try the new functionality and share your feedback with us via Send a Smile/Frown at the top right corner in your Excel for Mac.

We have exciting times ahead of us!

Guy Hunkin
- Excel Team

895 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • Lee D'Cunha commented  ·   ·  Flag as inappropriate

    Moved from Excel 2013 for Windows to Excel 2016 for Mac. Very surprised to learn that Mac users do not get full features. Appreciate MS does something about this quick as I need to use distinct count for most of my pivot tables at work.

  • Anonymous commented  ·   ·  Flag as inappropriate

    Microsoft and Apple should push their collaboration (for all) in Office 2016 mac and let users (customers) to benefit from all components. Power pivot, Power BI,...
    Office 2016 Mac must be the same for All.

  • D commented  ·   ·  Flag as inappropriate

    Why are us Mac-users still being short-changed? Surely in this day and age Microsoft engineers could have come up with power tools for us too?

  • Sam Johnson commented  ·   ·  Flag as inappropriate

    We need to be able to work across both PCs and Macs, so our standard applications and tools - including BI - need to work on both. If Power BI isn't going to be implemented on Macs, then we'll have to drop our plans to use it for internal self-service BI - and if it doesn't give us the BI we need, our rationale for sticking with Office365 disappears (Google Docs is much better for collaborative work).

  • ga84 commented  ·   ·  Flag as inappropriate

    Please stop assuming that Mac users are not excel proficient and give us the same functionality as the windows version.

  • Anonymous commented  ·   ·  Flag as inappropriate

    How disappointing since Excel was first a MAC product and I switched from 123 for Mac to it. I could understand when processor platforms were different that porting was a significant issue. But that is not an issue. I hope this is not the remnants of the Macs are toys theory. With IOS devices all over, you would think that it would offer a huge market of value.

  • Mouse commented  ·   ·  Flag as inappropriate

    I agree with the others, if you are going to continue to make Mac versions "lite" versions, then you will need to reduce the price. For serious business use, we need the power functions. Get off the stick, create and add them in. No more excuses.

  • Bruce commented  ·   ·  Flag as inappropriate

    I am using Office 365 for Mac. My work includes building Business Analysis Models for my customers and it is really problematic for me that this functionality does not exist. Could you tell me where the fix sits in the planned product release schedule?

  • JP commented  ·   ·  Flag as inappropriate

    This is a serious feature that is missing. Need to add it.

  • John Lott commented  ·   ·  Flag as inappropriate

    The fact that distinct count is not standard in the current Mac version is mind boggling.

  • Anonymous commented  ·   ·  Flag as inappropriate

    Distinct count in a pivot table is something i used ALL THE TIME in my Windows version before I moved to the Mac. I really miss it. So much more work to do it manually.

  • Rafael commented  ·   ·  Flag as inappropriate

    There is a big difference between the Office for PC Vs the Office for Mac. We are paying for a licence but the product is too different.

  • Anonymous commented  ·   ·  Flag as inappropriate

    I've had Macs since 1984 and they have been saying office will be at parity with the windows in the next version since then. This is beyond ridiculous.

Feedback and Knowledge Base