Forum Discussion

Copper Contributor

Apr 26, 2020

power query mac office

Hi all, I was under the impression that Power Query would be available for insider fast users of Excel...but...is it case ? I cannot import any xlsx data in my excel 16.37.. Can you help ? Marie

Excel on Mac

office 365

Riny_van_Eekelen

Platinum Contributor

Apr 27, 2020

marie365 Power Query is NOT available on Excel for Mac, unfortunately. You can only refresh queries made on Excel for Windows.

On a Mac myself, running Excel for Windows virtually, using Parallels.

Tiboli

Copper Contributor

Sep 30, 2020

Power Query is available on Office 365 (Excel) for Mac.

I use it all the time

Riny_van_Eekelen
Platinum Contributor
Oct 01, 2020
Tiboli I'm not sure we are talking about the same thing here. Unless I have missed a major recent update, "Get & Transform Data" (a.k.a. Power Query) is NOT available in Excel for the Mac to the same extent as it is on the PC versions. Not too long ago, MS introduced the possibility to refresh certain queries on a Mac, but the queries themselves can be created in Windows versions only.

If I'm mistaken, I would love to see some proof of your full use of PQ in Excel for the Mac. Having said that, it is of course possible to run the Windows version of Excel, virtually on a Mac. That's what I'm doing myself.