Feedback by UserVoice

 

How can we improve Excel for Mac?

← 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,789 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

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

We are pleased to announce that the first set of Power Query features are now available in version 16.29 and greater. At this stage you can refresh from text, CSV, XLSX, JSON and XML files.

Refer to the following blog post for more details:
https://techcommunity.microsoft.com/t5/Excel-Blog/Get-amp-Transform-Power-Query-in-Excel-for-Mac-Phase-1/ba-p/876840

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.

Show previous admin responses (4)

979 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
  • Nayan Kalnad commented  ·   ·  Flag as inappropriate

    Moved to Excel 2016 for Mac. Disappointed to find out that Mac users cannot use the power features.

  • Anonymous commented  ·   ·  Flag as inappropriate

    Add Get & Transform capability as implemented in Windows XL 2016 (Data ribbon). Annoying that msft site says this capability is "in all versions of Excel/Office 365" and it's not

  • 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.

1 2 … 44 46 48 49

Excel for Mac: PivotTables and Power Pivot

Categories

Feedback and Knowledge Base

(thinking…)