Forum Discussion
Excel 365 for Mac - Get & Transform/Power Query functionality
UY-SCUTI I went the opposite way. A long time Mac user, realising that Excel for Mac wasn't really living up to my needs. I had an MS365 Business subscription that allowed me to install the full Office package on up to 5 PC's and/or Macs, plus a bunch of mobile devices. I bought Parallels and W10 and happily run the full Excel version on a virtual Windows machine, on one of my Macs, a rather old MacBook Pro. Works good enough for me. If you have a newer Mac, it's going to run even better, I suspect. At the same time, running Excel on two more Macs and a Huwawei laptop (all under the same subscription), though with the limited functionality (as you recently discovered) on both Macs.
Just in case, roadmap is here Microsoft 365 Roadmap | Microsoft 365. If functionality is not included here nobody will share concrete plans for it. Power Query for Mac is not included.
Another related links are about data model (Power Pivot) on Mac Add PowerPivot to Mac excel – Welcome to Excel’s Suggestion Box! (uservoice.com) , not planned at all.
And PQ on Mac Add support for Get & Transform (formerly Power Query) – Welcome to Excel’s Suggestion Box! (uservoice.com)
IMHO, if you prefer Mac hardware and would like to have full functional Excel, install Windows on the top and work in it with such tasks.
Thank you for thinking along, have not really thought of the option of installing Windows OS on the Macbook! Will definitely give that a try, any chance you know if my Office 365 family subscription will allow me to install a Windows version as well?
Also thanks for those roadmap links, as for Get & Transform (former Power Query) it does seem like there is some activity on this topic still, also seeing users regularly requesting updates on this.
Guy Hunkin, Would you be able to tell more?
UY-SCUTI I went the opposite way. A long time Mac user, realising that Excel for Mac wasn't really living up to my needs. I had an MS365 Business subscription that allowed me to install the full Office package on up to 5 PC's and/or Macs, plus a bunch of mobile devices. I bought Parallels and W10 and happily run the full Excel version on a virtual Windows machine, on one of my Macs, a rather old MacBook Pro. Works good enough for me. If you have a newer Mac, it's going to run even better, I suspect. At the same time, running Excel on two more Macs and a Huwawei laptop (all under the same subscription), though with the limited functionality (as you recently discovered) on both Macs.
- Guy Hunkin
Microsoft
I suggest you follow the announcements on the Excel blogs portal here. In addition, it's worth noting that this support article accurately reflects the currently supported Power Query features on Mac. Hope this helps.
Guy
- Excel Team
Guy Hunkin Not really my problem. I moved away from Excel for Mac as it just can't deliver what I need/want. I believe the biggest issue is that you don't have full Excel functionality on a Mac. Quite a few missing features. With regard to PQ, the options in the support article arn't really user friendly. Using complicated VBA code to create the simplest of queries is not something I will spend any time on. As said in my post, I run Excel for Windows on a virtual machine on a Mac and am totally happy with that.
Up to UY-SCUTI to decide what he wants.
