Add support for Get & Transform (formerly Power Query)
Make Get & Transform (formerly Power Query) available in Excel for Mac (like in Excel for Windows)
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:
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!
- Excel Team
Lee D'Cunha commented
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.
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.
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
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).
Need more than 1048576 rows of data => need powerpivot :)
A significant feature that must be added! Please make it so.
Please stop assuming that Mac users are not excel proficient and give us the same functionality as the windows version.
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.
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.
Please make PowerPivot available in excel office 365 for mac.
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?
please add asap. Need cross compatibility between home and work.
This is a serious feature that is missing. Need to add it.
John Lott commented
The fact that distinct count is not standard in the current Mac version is mind boggling.
Giacinto Chianchiano commented
Why not Power Pivot availability for Excel on the Mac?
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.
Will Power Pivot be available for Excel on the Mac?
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.
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.
I agree that these need to be added