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:
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.
When will Microsoft Excel provide an update on when Power Query will be available on Excel 365 for Mac? It is October 2019 and most MAC Office 365 users feel cheated and deceived!!
It has been over a month when i lodged a request for Power Query and now Power BI to be added onto Excel 365 for MAC.
Why it has taken so long for Microsoft to add this feature on Excel for MAC?
There are other Office 365 Mac users who have upgraded their notebooks and desktops from PC to MAC. So, as a consumer we expect Office 365 for Windows to have the same functions and features in Office 365 for MAC.
At the minute, I have to deviate between my Windows 7 Notebook and MAC Pro notebook when I am using the Power Query function and writing up some Visual Basic commands (Index and Match commands for a Dashboard spreadsheet).
Can anyone from Microsoft provide an update on this issue please?
To Guy and Excel Team,
The Excel team have not answered the question on when the Power Query update will be available on the Microsoft Office web site to allow Excel Mac users to download the update?
As an Office 365 user I feel cheated by the fact that the Power Query tool is available on Office 365 for Windows only and the Excel team do not realise how popular the Mac computer is at this point in time.
All Office 365 Mac subscribers pay a monthly subscription to use Word, Outlook and Excel. Hence as a customer, we expect to receive the full functions of Office that are available of Office 365 for Windows.
It is time to flood social media (Twitter, Facebook an Instragram) with posts to place the pressure on Microsoft to provide the Power Query feature and other features that are available on the PC version and not on the MAC version on the MAC version from now on.
I am currently using Office 365 for Mac (With Excel 365).
And I would like to know when will the Excel Power Query function be available for all Excel Mac Users this year?
Do you have a time frame on when the add in feature will be available on Excel for Mac.
I feel that it is unfair for all Mac Office 365 subscribers do not have access to the same features as Excel for Windows.
As a customer, we pay a monthly subscription. What would happen in a work environment that you have to prepare a non financial and marketing report on Excel for Mac 365 and the function on Excel is not available for the MAC???
Is that fair?
Hence, can you please provide us with a time frame on the release of the Power Query function for Excel 365 for Mac.
Thanks for all the votes and comments on this suggestion. We know this is important and it’s a big undertaking. Please continue to show your support for this.
Steve K [MS Excel]