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 glad to announce that the first phase of the project is available for Insiders Fast. At this stage we support 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.
We have exciting times ahead of us!
- Excel Team
Power query / Get and Transform is a must needed feature in Excel for mac
<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.
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 support you will for it... this is mere antitrust !
There should literally be a class action lawsuit or antitrust action regarding this. We pay the exact same amount but don’t get the same features...unless we buy a Microsoft operating system??? Haven’t you guys already been through the antitrust exercise once? Clearly you haven’t learned your lessons. The fact that multiple features consistently lag or are slightly less convenient, is extremely unethical. Even the filter function sucks on Mac. Come on man!
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.
Please make the full functionality of power query available for Mac users!!
I'm trying to get external data from the web in office 2019 office on a mac. I have saved a plain test web query but when I run it I don’t nt get the data I want upload but instead d the hyperlink address in A1.
What is the update here? When will Power Query be available for excel on Mac?
Ed Hansberry commented
Yes, XLSM would be supported as the spreadsheet is the same. I would be curious to know if it supports XLSB and XLS. Kinda doubt it as those are very different file formats, not XML based.
Jeff Berube commented
You say it supports XLSX at this time, does that include XLSM?
Finally the update is live, but I'm unable to figure out how can i fetch data from an Odata source using the new functionality. Also, I'm unable to figure out what's new in this update.
Andres Morales commented
Please, in order to keep using Mac computers for work, this feature has converted in a must to have, because excel is a powerful tool.
What is the feedback you require to trigger release of the update?
@Shivam, Power Query can be used to import OData V4. You can do it to day via Excel for Windows or PowerBI Desktop tools. It is not available yet in Excel for Mac. Regarding your second question, the we still don't know when this update will be released to all customer as it really depends on the feedback we'll get.
When can we expect this update for all Mac users? My organisation does not allow me to enrol into the insiders program
Can PowerQuery be used to fetch data from OData V4 services??
Ed Hansberry commented
Now available for Office Fast Insiders!!! https://blog-insider.office.com/2019/05/30/you-asked-for-it-a-journey-to-power-query-in-excel-for-mac-starts-now/ Only supports CSV, XLSX, and a few other files. Hopefully more support coming soon!