Blog Post

Excel Blog
2 MIN READ

Get & Transform (Power Query) in Excel for Mac - Phase 1

Guy Hunkin's avatar
Guy Hunkin
Icon for Microsoft rankMicrosoft
Oct 02, 2019

Excel 2016 for Windows introduced a powerful set of Get & Transform Data tools. These tools, based on Power Query technology, enable you to easily connect, combine, and shape data coming from a variety of sources.

 

Today, we are excited to announce the first step in a journey to support Power Query in Excel for Mac. This is by far the most popular idea on Excel UserVoice under Excel for Mac category. In this release, you can refresh your Power Query queries on Mac from Text, CSV, XLSX, XML and JSON files, and you can author queries with VBA.

 

Getting started

The new functionality is live for all Office 365 subscribers in Excel for Mac running version 16.29 (19090802) and later. If you are running an earlier version, find out how to update your Office for Mac.

 

Refreshing Power Query queries

You can now refresh the Power Query queries in your workbook that pull data from Text, CSV, XLSX, XML or JSON files. Triggering the refresh command is done the same way that you've been doing it so far. For example:

  • Click on the Data tab of the ribbon > then choose Refresh All
  • Right-click on your query table > then click Refresh
  • Right click on your PivotTable > then click Refresh Data
  • Use a VBA script
  • And more...

 

Please note that upon the first time you try to refresh your workbook queries, you may need to update the location of the data source so that it works on your Mac. Click the Data tab on the ribbon > Connections > select the desired connection > and click Change File Path button to update it.

 

Authoring Power Query queries

With this update, you can also create and manage Power Query queries in your workbook using VBA. Any existing macros and VBA scripts that reference Workbook.Queries and WorkbookQuery entities in the Excel's object model will work in Excel for Mac as expected.

Note: You may still need to adjust your scripts to reflect the notion of a file path on Mac (e.g.,  /Users/USERNAME/Desktop/data.csv) that is different than a file path on Windows (e.g., C:\Users\USERNAME\Desktop\data.csv).

 

Sharing your feedback

Let us know what you think and submit your feedback using Send a Smile/Frown (Send us a Smile :slightly_smiling_face: or Frown :slightly_frowning_face: button at the top right)!

 

Stay tuned for more updates!

 

Guy Hunkin

Program Manager, Excel

Updated Oct 02, 2019
Version 2.0
excel
Get & Transform
Get & Transform Data
mac
Power BI
Power Query
  • The_Gov's avatar
    The_Gov
    Copper Contributor
    Oct 03, 2019

    Hi there,

     

    Can you please give us an update or time frame when the Power Query feature will be included in the Excel 365 for Mac?

     

    No one at Microsoft has given any Office 365 for Mac user a time frame on when this feature will be available for all Mac users.  We pay a yearly subscription to use Office 365 and we expect Office 365 for Windows to have the exact features as Office 365 for Mac.

     

    KINDEST REGARDS

     

     

    PAUL

  • Ed Hansberry's avatar
    Ed Hansberry
    Steel Contributor
    Oct 03, 2019

    Is there a plan to actually be able to author queries using an editor similar to the one in Excel on Windows and Power BI Desktop on Windows? That is when it gets really useful.

     

    Or is the end goal to support most/all data refreshes, but the assumption is the authoring happens on Windows clients?

  • Mark_Lewus_mlewus's avatar
    Mark_Lewus_mlewus
    Copper Contributor
    Apr 21, 2021

    Hi

    I have been patiently waiting, but...  Power Query editing has been available for 5-1/2 years on Windows, and it's been 18 months since "Phase 1" was available on Mac.

     

    As an Office 365 subscriber I understand that Windows must be Microsoft's release platform for new features. Still, those of us in the Mac community pay the same fee as Windows users for this software. I do not think it is unreasonable to expect broadly similar functionality, especially after a 5 year delay. 

     

    Is this feature set really coming to Mac? What I mean is, are these features included in a planned and resourced development program? If so, can you offer a timeframe? "No" is a perfectly acceptable answer, but I think we deserve to know whether we will ever get this functionality or not.

     

    Thanks

    Mark

     

     

     

     

     

     

     

     

     

  • Guy Hunkin's avatar
    Guy Hunkin
    Icon for Microsoft rankMicrosoft
    Oct 03, 2019

    Ed Hansberry, the goal is to support full query authoring on Mac. As you can understand, this is an expensive project and we adopted a staged delivery plan - we aim to release valuable functionality to the users as soon as we are done with coding and testing.

     

    Hope it helps.

     

    Guy.

  • odhanson's avatar
    odhanson
    Icon for Microsoft rankMicrosoft
    Oct 27, 2019

    midior , I am sorry, I cannot comment about time frames. I can share that we are actively working on this and will definitely let you know when its ready to be shipped.

  • odhanson's avatar
    odhanson
    Icon for Microsoft rankMicrosoft
    May 13, 2020

    dmitrykaplan , 

    Excel.CurrentWorkbook()

    is table/range. You are basically asking PowerQuery to read data from the Excel workbook, and its complaining that 'ExcelInterop' is not enabled. If you eager to try this, I suggest you install insiders version of Office. It is open right now and we would love to get your feedback.

    Else, you will need to wait, hopefully not much longer, before this is opened up to the general public.

     

    Oded

  • lalamirchiseth's avatar
    lalamirchiseth
    Copper Contributor
    Oct 14, 2020

    Hi Guy Hunkin 

    Any update on authoring Power Query in Excel Mac Office 365???

    It has been more than a year you said the work is in progress and it is an expensive project (your message on 10th March 2019).

    If we can get a timeline then it will be of help. I am sure you must have presented a timeline to the management regarding the same. 

    The wait is unbearable actually. 

    For every Power Query authoring I have to first find a laptop with Windows OS, then do all the work, then transfer it on my Mac and then start using it. 

    And if there is one change required then the process has to be repeated. 

    This is frustrating actually. I am not sure if you will understand but many of us go through this periodically. 

    Please help us all.

    Regards

    Rajeev

  • pieter150's avatar
    pieter150
    Copper Contributor
    Jun 16, 2022

    Hi Inbar,

     

    This is great news - very well done and thank you.

    I very much look forward to trying out the new functionality.

    Pieter

  • Nevillrw's avatar
    Nevillrw
    Copper Contributor
    Jun 16, 2022

    Inbar_Privman - this is exciting news... I'm working with my IT admin to provide me access to the Beta channel now.

     

    This is transformative (excel pun 🙂 for the work I do and I want to thank you and the team!