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
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:
https://techcommunity.microsoft.com/t5/Excel-Blog/Get-amp-Transform-Power-Query-in-Excel-for-Mac-Phase-1/ba-p/876840
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.
921 comments
-
Thomas Wilk
commented
it would be nice to have Power Query and other data analytics add-ins available for the Mac OS.
-
Anonymous
commented
Please add power query editor to mac.
-
Ron
commented
I would like to see Get and Transform / Power Query features in my Mac version of Excel. I have version 16.29 and I don't see anything related to Power Query?
-
Anthony
commented
The latest Excel for Mac (v 16.29 and later) can refresh from Text, CSV, XLSX, XML and JSON files, but not when those files are on SharePoint Online (or other cloud storage locations). Please add this functionality, as we are moving to SPO and away from file servers. I know I can refresh from a local copy (via OneDrive sync client), but each person's local file path may be different, so a shared Excel file won't update correctly for each person.
-
Jordan Breiner
commented
Please add power query editor to mac.
-
Wolfgang Müller commented
Hello,
Data import from web does not work..... (Version 16.31 MAC)
I cant add the web linkBR
WM -
Anonymous
commented
Not happy, can't even get a file that combines 4 CSV files into a PivotReport to refresh with the new Mac Power Query functionality.
-
Vincent RAPP
commented
Power query / Get and Transform is a must needed feature in Excel for mac
-
David MC
commented
Hey @Guy. Thanks for the response. I can definitely understand the cost and the lift, but I think the frustration you are hearing in all of our responses is because this enhancement request was submitted in 2015 and has spent over a year and a half as the number one most requested feature. A staged delivery plan is a great option, but I think most of us feel this stage (refresh only) should have come 18 months ago. I think it would help us positively support this development if you would share where this work is on the product development timeline in relation to the other enhancements being considered. Also, that would help us know for how much longer we need to keep using something with parity cost to the windows platform, but not parity in features.
-
@Paul, as mentioned in the blog post this functionality is available in Excel 365 for Mac.
Guy Hunkin
- Excel Team -
@David MC, the goal is to support full query authoring on Mac. As you can understand, this is an expensive project and we adopted a staged delivery plan - we aim to release valuable functionality to the users as soon as we are done with coding and testing. Hope it helps.
Guy Hunkin
- Excel Team -
David MC
commented
Nope. Sorry. Go back and try again. As I said in my previous post: "We don't simply want a way to refresh PQ connections in Excel for Mac, we NEED a way to create and edit M-Code in PQ for Mac. And, frankly, we need it yesterday. Figure it out."
-
Paul
commented
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!!
-
Anonymous
commented
Adding Data Model to Excel for Mac!!!
-
Paul
commented
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?
PAUL
PAUL
-
Anonymous
commented
Power query / Get and Transform is a must needed feature in Excel for mac
-
Anonymous
commented
<MidNightRead><FileHeader><TypeOfRead>1</TypeOfRead><NetworkId>2945</NetworkId><Date>310819</Date></FileHeader><MeterRecords><Record><MeterType>1P</MeterType><DateTime>2019-09-01 00:00:00</DateTime><MeterID>LWT73282881138</MeterID><PF>0.78</PF><kWh>788.66</kWh><kWh-TZ1>301.33</kWh-TZ1><kWh-TZ2>146.1</kWh-TZ2><kWh-TZ3>5.69</kWh-TZ3><kWh-TZ4>335.54</kWh-TZ4><kVAh>998.48</kVAh><kVAh-TZ1>422.4</kVAh-TZ1><kVAh-TZ2>186.1</kVAh-TZ2><kVAh-TZ3>25.69</kVAh-TZ3><kVAh-TZ4>364.29</kVAh-TZ4><PowerOn_Duration>1418</PowerOn_Duration><MD-kW>0.0</MD-kW><MD-kW-Time>2019-00-00 00:03:00</MD-kW-Time><MD-kW-TZ1/><MD-kW-TZ2/><MD-kW-TZ3/><MD-kW-TZ4/><MD-kVA>0.0</MD-kVA><MD-kVA-Time>2019-00-00 00:03:00</MD-kVA-Time><MD-kVA-TZ1/><MD-kVA-TZ2/><MD-kVA-TZ3/><MD-kVA-TZ4/><kWh-TZ5/><kWh-TZ6/><kWh-TZ7/><kWh-TZ8/><kVAh-TZ5/><kVAh-TZ6/><kVAh-TZ7/><kVAh-TZ8/><MD-kW-TZ5/><MD-kW-TZ6/><MD-kW-TZ7/><MD-kW-TZ8/><MD-kVA-TZ5/><MD-kVA-TZ6/><MD-kVA-TZ7/><MD-kVA-TZ8/></Record><Record><MeterType>1P</MeterType><DateTime>2019-09-01 00:00:00</DateTime><MeterID>LWT73282881967</MeterID><PF>0.9</PF><kWh>2018.57</kWh><kWh-TZ1>838.09</kWh-TZ1><kWh-TZ2>354.71</kWh-TZ2><kWh-TZ3>42.81</kWh-TZ3><kWh-TZ4>782.96</kWh-TZ4><kVAh>2218.32</kVAh><kVAh-TZ1>917.46</kVAh-TZ1><kVAh-TZ2>396.64</kVAh-TZ2><kVAh-TZ3>51.58</kVAh-TZ3><kVAh-TZ4>852.64</kVAh-TZ4><PowerOn_Duration>1418</PowerOn_Duration><MD-kW>0.0</MD-kW><MD-kW-Time>2019-00-00 00:03:00</MD-kW-Time><MD-kW-TZ1/><MD-kW-TZ2/><MD-kW-TZ3/><MD-kW-TZ4/><MD-
-
Bernhard Keim
commented
Power Query is the feature I miss most on the Mac. I am looking forward to see this implemented.
-
David MC
commented
I am still confused about this update. I am running v.16.27 and in my XLSX file, I still do not see a way to edit a PowerQuery connection made in Excel for Windows. If this isn't possible with the most recent "fast insiders" release than this isn't an answer to our request at all. We don't simply want a way to refresh PQ connections in Excel for Mac, we NEED a way to create and edit M-Code in PQ for Mac. And, frankly, we need it yesterday. Figure it out.
-
Paul
commented
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.
Paul