You Asked for It: A Journey to Power Query in Excel for Mac Starts Now!

Hi all,

We’re here today with another story about the power of feedback from the Office Insiders community!

When we first integrated the Power Query technology in Excel for Windows, we got a lot of feedback that people love it! It is a truly powerful and time-saving set of tools to gather and shape data fast and easily in Excel. But we also heard from our Mac Office Insiders community that you want Power Query to be supported in Excel for Mac, as well. “Excel for Mac is a toy without Power Query!”, some of you said.

And we heard you! We got our best engineers working on this project, and today we are glad to announce the first step in a journey to support Power Query in Excel for Mac. In this release, you can refresh your Power Query queries on Mac from Text, CSV, XLSX, XML and JSON files.

Getting started 

The new functionality is live for all Office Insiders Fast customers in Excel for Mac version 16.26.521.0 16.26 (19052200) and later.

UPDATE! This feature is now also available to Insider Slow customers running 16.27 (19070800) and later.


Scenarios to try

Refresh your workbook queries as you would usually do (for example, via Data > Refresh All or VBA). Note that the refresh will work only for those queries that pull data from text, CSV, XLSX, XML or JSON files.

You may need to update the file path so that it works on your Mac. Click Data > Connections > select the connection that failed to refresh > and click Change File Path to update it.

Feedback

We'd love to hear from you! You can share your comments right here, or submit your feedback using Send a Smile/Frown (Send us a Smile �� or Frown ☹ button at the top right)!

Guy Hunkin

Senior Program Manager

Excel Team

Was this discussion helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this discussion?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this discussion?

Thanks for your feedback.

I am glad to see this beginning to get attention. However development of Get & Transform and PowerPivot for Mac needs to be accelerated. I pay the same price for my 365 subscription on Mac as I did for Windows. Yet Mac is missing important features.

176 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Discussion Info


Last updated February 18, 2021 Views 4,281 Applies to: