Add support for Get & Transform (formerly Power Query)

Make Get & Transform (formerly Power Query) available in Excel for Mac (like in Excel for Windows)

3,538 votes

(thinking…)

Facebook

Google

Forgot password?

Create a password

Signed in as (Sign out)

We’ll send you updates on this idea

Anonymous shared this idea · July 23, 2015 · Flag idea as inappropriate… · Admin →

started ·

AdminExcel Team [MSFT] (Product Owner, Office.com) responded · October 02, 2019

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.

Show previous admin responses (4)

planned ·

AdminExcel Team [MSFT] (Product Owner, Office.com) responded · June 01, 2019

Hi all,

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:
https://blog-insider.office.com/2019/05/30/you-asked-for-it-a-journey-to-power-query-in-excel-for-mac-starts-now/

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!

Guy Hunkin
- Excel Team

planned ·

AdminExcel Team [MSFT] (Product Owner, Office.com) responded · February 08, 2018

Hi everyone – There are many comments here asking for PowerPivot, which is being tracked separately. This suggestion is only counting votes for PowerQuery (Get & Transform).

To vote for the PowerPivot suggestion, please go to it – https://excel.uservoice.com/forums/304933-excel-for-mac/suggestions/19568977-add-powerpivot-to-mac-excel.

Thanks – Steve K [MS Excel]

Accepting Votes ·

AdminExcel Team [MSFT] (Product Owner, Office.com) responded · September 06, 2017

Thanks to everyone who has voted for this suggestion. The title has been updated so that it mentions Power Query, but no longer mentions Power Pivot or Power Map. Please add your votes to separate suggestions for those features. Keeping the suggestions separate will help make the voting more meaningful.

Thanks – Steve K [MS Excel]

Accepting Votes ·

Ashvini Sharma (Lead Program Manager, Microsoft) responded · November 05, 2015

Thanks for logging this item, folks. This is actually significant amount of work that is in our backlog. You can help by drumming up support for this (i.e. number of votes), which will help us balance this work with higher priority against other items.

Thanks in advance!
ash [MS XL]

917 comments

Add a comment…

Attach a File