Add support for Get & Transform (formerly Power Query)
Make Get & Transform (formerly Power Query) available in Excel for Mac (like in Excel for Windows)
Anonymous
shared this idea
Hi all! We are happy to let you know that in addition to refreshing your data from supported sources, you can now import data from local files such as Excel workbooks, and Text and CSV files with Power Query in Excel for Mac. This new functionality is available to Beta channel users running version 16.50 (build 21050400) or later.
You can check out the blog for this new feature here: https://insider.office.com/en-us/blog/import-data-from-local-files-with-power-query-in-excel-for-mac
For more information about Power Query features that are currently supported in Excel for Mac, please take a look at the following support article: https://support.microsoft.com/office/7b2f337d-e7d2-4fdf-bf00-3dfbb1e5e9c5
Inbar Privman
Product Manager, Excel Team
1026 comments
-
Anonymous
commented
Where is the Data Model in the Pivot Table in Excel? It doesn't seem to show. Is it still not available? I appreciate the help,
-
Anonymous
commented
Use of Microsoft is critical. This lack of functionality makes me think I shouldn't upgrade to another Apple product.
-
Robert
commented
PLEEEEASE ADD DATA MODEL SUPPORT FOR EXCEL FOR MAC. PLEASE AND THANK YOU!
-
Edward
commented
So looks like at this stage Power Query is not yet available for Mac. It's in the works clearly, but when will it actually be available?
-
Ángel
commented
Hi Guy!
Thanks for the update and for your work on this :)
Quick question: any plans to support "local folders" as a source for refreshing Power Query queries on Mac?
I see you support SharePoint folder and files, and local files, but not local folders...
Thanks!
-
Heather
commented
When will it be possible to create (not just refresh) Power Query queries on Excel for Mac?
-
Michael Carroll
commented
It is utterly disgraceful that in 2021 you do not have the option to import a json file into Excel for Mac
-
Anonymous
commented
Please add power query (like what is present on excel for windows) also for excel for mac
-
tp
commented
It is certainly welcome to have more data sources added. But....it still leaves the support for transform and large file power pivot functionality missing.
Please get Excel for Mac functionality equal to Excel for Windows in these areas. -
Anonymous
commented
Please add distinct count pivot feature!
-
mc
commented
Pls add power query for MAC, no power query , no use for xls.
-
Ricardo
commented
Please! I need the power supplements in Mac. urgent!
-
[Deleted User]
commented
We need the full powerpivot for mac - URGENT
-
Anonymous
commented
Get Data from Folder when using power query for mac.
-
Joao
commented
Add power supplements...
-
Ramzan
commented
Absolutely correct , very dissaponted as we don't see all the option what wondows does
it can be modified to Mac instead of removing -
MJ
commented
Please add the support to import JSON, I need it to analyse sensor data.
-
Anonymous
commented
Since my original office is undergoing renovations due to Hurricane Laura & Hurricane Delta damage, I am working in a satellite office and using my personal MacBook Pro for all work-related tasks. I cannot believe that we are STILL waiting for all of the Pivot Table tools and features to be implemented for Mac users... unacceptable. I tried to use the online version as a work around, but I was disappointed to find out that the online version also lacks important features that I regularly use on my PC. Can we at least get an estimated timeline for the rollout of these features for mac users, please??
-
Anonymous
commented
This feature is in the Windows version but missing in macOS.
I need more tools to transform data from csv. -
Bart
commented
It's great that you guys have made Power Query available for mac users for office 365, but is it possible to also include office 2019 and 2016 in this update? As a costumer with no IT background I find it strange that Power Query is included in office 2016 and 2019 on windows but not on mac.