Add support for Get & Transform (formerly Power Query)
Make Get & Transform (formerly Power Query) available in Excel for Mac (like in Excel for Windows)
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.
[Deleted User] commented
We need the full powerpivot for mac - URGENT
Add power supplements...
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??
I NEED TO COMBINE PIVOT TABLE WHILE ONLY USING SAME SLICER ON MY MAC PLEASE!:(
PLEASE I NEED PIVOT TABLE WIZARD FOR MY EXCEL ON MY MAC:(
JOSE LIZCA commented
Hi ! please with need to use power bi any Mac, when will be possible this for us who are using some office tool and we need more tool in our Mac
Excel 16.41 for mac:
"At this stage you can refresh from text, CSV..." it's an absolute lie, it does not work.
Query created on Excel for windows (it works with a windows path) but it does not work with a osx path in a Mac.
Source = Csv.Document(File.Contents("/Users/username/filename.csv"),[Delimiter="#(tab)", Columns=15, Encoding=65001, QuoteStyle=QuoteStyle.None])
Almost a year since the last update from Microsoft and over five years since the feature was requested... Unbelievable!
Cyd Dawson commented
I use Excel for Windows on my personal computer, and see places where Power Query and its accompanying features would be immensely helpful for my employer - however, we are an all-Apple office. I look forward to this feature being available for Mac and thank all the developers for their hard work in this area.
Roberto Dayeh commented
Hello, I wonder if Get & Transform could solve the issue with JSON files, which cannot be converted by Excel as a table, thanks.
Hey MS, We Mac users love Excel too. Please add Get & Transform (Power Query) to Excel for Mac. It's time to bring the Mac version up to date with the Windows version. Please give us the Excel power available in the Windows version.
Joshua Hester commented
This is definitely a step in the right direction, but in an office that uses both PC and Mac, we still cannot use Get & Transform until all data sources are supported and all query editing features are available in Excel for Mac. Please provide an update on the current status of this feature and when the full functionality will be available!
Barbara Turcott commented
Looks like I'm not the only one to ask this, but when is Power Pivot and Power Query going to be added to Excel for MAC, including the online subscription version? Could really use it.
Power BI, Power PIvot e outros da serie Power para iOS! Por favor! Seria pedir demais?
Need it very much
Need it very much
Да, да, да!!! Добавте Power Pivot и Power Query на Mac OS!!!! 🙏🙏🙏
С любовью из России!!! 😀
Over an year since the last release and no ETA or news regarding this important feature.
faster faster please.