Share via

Excel 365 with MAC. Power query

Anonymous
2022-04-25T15:19:44+00:00

Hi everyone. Anyone use excel 365 with Mac? Where can I find the Power Query Editor? I can't find the command in my version.

Thanks

Microsoft 365 and Office | Excel | For business | MacOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-04-25T16:08:05+00:00

    Hello,

    Power Query in Excel for Mac is limited when compared with Power Query in Excel for Windows. I suggest you refer to this article for more information: Import data in Excel for Mac (Power Query)

    In addition, please also look at this article to know the Power Query features in different Excel versions. Power Query data sources in Excel versions (microsoft.com)

    At last, you can also submit your idea to the Excel Feedback community (Excel · Community (microsoft.com)).

    Appreciate your understanding!!

    Best Regards,

    Chitrahaas

    1 person found this answer helpful.
    0 comments
  2. Jim G 134K Reputation points MVP Volunteer Moderator
    2022-04-26T17:38:02+00:00

    Hi

    PowerQuery is available to Office 365 subscribers in current Excel for Mac update, which is version 16.60. There may be other license type restrictions.

    To display your update level and license type, use the Menu Bar and choose Excel > About Microsoft Excel. PowerQuery is on the Data tab of the Ribbon in the group labeled Get and Transform Data.

    Please keep in mind this feature is still under development on the Mac. At the moment there are only two connectors: Excel Workbook and Text/CSV and these are only a few weeks old. My hope is that Microsoft continues working on this and brings out new connectors.

    Also, the interface is not completely built, yet. Here's a screen shot from Excel for Windows. It shows the Transform Data button, which is missing in the Mac version. On the Mac, Transform Data does work, but at the moment you have to use Transform Data programmatically using Visual Basic for Applications, AppleScript, or JavaScript.

    0 comments
  3. Jim G 134K Reputation points MVP Volunteer Moderator
    2022-04-26T21:07:26+00:00

    Well, wouldn't you know? Microsoft just added some PowerQuery features for testing in the beta channel!

    Shape data with Power Query Editor in Excel for Mac (office.com)

    0 comments
  4. Anonymous
    2022-04-27T14:58:02+00:00

    Hi Chitrahaas

    Thanks for your reply. Unfortunately this problem limits the use of Excel on Mac.

    I will consider alternatives.

    Best regards

    Nicola

    0 comments
  5. Anonymous
    2022-04-27T15:09:53+00:00

    Hi Jim.

    Thank you for your recommendation!

    Unfortunately I'm not an "insider".

    Do you think I can have this beta version? If so, how?

    Thanks again for your precious time.

    Nicola

    0 comments