Power Query updates in Excel for Mac

This content applies to: Excel for Mac

The Excel team has been working hard on enabling more Power Query functionality inside of Excel for Mac. This article showcases a brief summary of the latest updates to the Power Query experience found in Excel for Mac.

This new functionality is now generally available in Excel for Microsoft 365 for Mac version 16.57 (22011100) or later.  See this support article to check which version you’re using.

You can read the full article with the updates from the Excel team blog here.

Full support without Rosetta

For customers using the Excel for Mac app with an Apple silicon chip, you are no longer required to use Rosetta in order to use Power Query.

When launching the Excel application, you will get prompted with a message that explains this case.

We highly recommend that you turn off Rosetta to get the best experience.

Import data from local files

You are now able to connect to Excel and TXT / CSV files from your local folders. This experience resembles the ‘Get Data’ experience found in the Power Query online integrations.

Note: The latest update to the Power Query in Excel for Mac experience enables just the Get Data experience for both the Excel and TXT / CSV connectors. The Power Query Editor experience is not currently present in Excel for Mac.

Send feedback

Throughout the Power Query experience, you will find a feedback icon on the top right of the dialogs. You can click this feedback icon to send your feedback and suggestions about the Power Query experience in Excel for Mac to the Excel for Mac team.

We encourage you to try out the new Power Query experience in Excel for Mac and send your feedback to the team.