Feedback by UserVoice

 

How can we improve Excel for Mac?

← Excel for Mac

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,790 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
started  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded  · 

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)

980 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Олег. commented  ·   ·  Flag as inappropriate

    Да, да, да!!! Добавте Power Pivot и Power Query на Mac OS!!!! 🙏🙏🙏

    С любовью из России!!! 😀

  • andre commented  ·   ·  Flag as inappropriate

    Over an year since the last release and no ETA or news regarding this important feature.

  • Dane Barber commented  ·   ·  Flag as inappropriate

    I appreciate the update, I'm already taking advantage of it.
    I really look forward to other features added, TY

  • Humaid commented  ·   ·  Flag as inappropriate

    Add distinct count in pivot table for Mac
    Add data model top excel for Mac

  • Sebastian commented  ·   ·  Flag as inappropriate

    More than half a year since the announcement that we can now refresh queries created in Mac on Windows, there is still no timeline, when we can create Queries in Excel on Mac. At least a rough timeline would be a nice gesture, as this feature has a history of five years.

  • Anonymous commented  ·   ·  Flag as inappropriate

    I need this functionality to get data from a website and import into excel... This is urgent and mac users should not be disadvantaged.

    PLEASE add this to Excel for Mac.

    Thanks

    David Finch

  • Anonymous commented  ·   ·  Flag as inappropriate

    I feel the same here. I have to run a virtual machine to run the windows version for Power Query, this is really frustrated. I saw Excel team are making progress on this such as such as .csv file and ODBC but please do catch up the progress with win, most important, as least make the xlsx format next in line.

  • Ángel commented  ·   ·  Flag as inappropriate

    "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."

    Same problem here!

← Previous 1 3 4 5 … 48 49

Excel for Mac: PivotTables and Power Pivot

Categories

Feedback and Knowledge Base

(thinking…)