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.
MicrosoftJust wanted to let you know that we released another phase, and you can now import data from local files with Power Query in Excel for Mac! For more information please see this announcement.
It's now been nearly a year since the last update on this topic. The import from web feature still requires us to go through the Word document voodoo, saved as txt, renamed to .iqy, only to get the Basic import features from Windows.
We can still not transform the data, select the columns to import into a table, set the data type, etc.
We cannot use the advanced functions to log in using an API.
I know that MacOS is a competitor to Windows, but when I buy Office, I expect to get Office. Not a milked down version of it. It's the same with OneNote and PowerPoint..
- Inbar_Privman
AlainL123 thank you for your comment.
Our team is currently working to introduce import from additional sources and transform data with Query Editor; however, there is no specific timeline for this as of yet. For further news, you can follow this site.
Please see the following article for more information about Power Query support in Excel for Mac: Import data in Excel for Mac (Power Query) (microsoft.com).
Inbar
Excel Team
Inbar_Privman Hi Inbar! Just wanted to share my excitement concerning the fact that the PQ Advanced Editor "landed" in my Mac today. Insiders Beta only, but nevertheless, a major development. Greatly appreciated!
For those who haven't read your blog post yet, I attach a link to it below.
https://insider.office.com/en-us/blog/shape-data-with-power-query-editor-in-excel-for-mac
I have Excel 16.68 (22110801) on the Insider program with an Office 365 Business Standard Subscription on a MacBook Pro with an Apple M1 Pro chip.
In the Power Query button the Launch Editor option isn't available. This is very frustrating as everything I read says it should be. Please help, I want to use PQ.
Matt
Inbar_Privman With all due respect to the efforts your team is laying down to port PQ to the Mac, but you're giving Mac users a Ferrari without the keys. Great to look at, but they can't drive it. PQ for the Mac is not PQ. Until you can deliver, perhaps best not to talk too much about the fact that PQ exists on or is coming to the Mac if you don't know when it's really going to happen.
Moved away from Excel for Mac after 11 years myself, as it just doesn't deliver the same greatness as the Windows version. And the VBA option mentioned in the link you shared is just not good enough. Tried it and would never have mastered it without quite advanced knowledge of PQ from working with it on the PC. Keep up the good work, though! Looking forward to the moment PQ comes to the Mac, for real!
