Add support for Get & Transform (formerly Power Query)
Make Get & Transform (formerly Power Query) available in Excel for Mac (like in Excel for Windows)
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
Product Manager, Excel Team
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,
Use of Microsoft is critical. This lack of functionality makes me think I shouldn't upgrade to another Apple product.
PLEEEEASE ADD DATA MODEL SUPPORT FOR EXCEL FOR MAC. PLEASE AND THANK YOU!
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?
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...
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
Please add power query (like what is present on excel for windows) also for excel for mac
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.
Please add distinct count pivot feature!
Pls add power query for MAC, no power query , no use for xls.
Please! I need the power supplements in Mac. urgent!
[Deleted User] commented
We need the full powerpivot for mac - URGENT
Get Data from Folder when using power query for mac.
Add power supplements...
Absolutely correct , very dissaponted as we don't see all the option what wondows does
it can be modified to Mac instead of removing
Please add the support to import JSON, I need it to analyse sensor data.
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??
This feature is in the Windows version but missing in macOS.
I need more tools to transform data from csv.
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.