Shape data with Power Query Editor in Excel for Mac
Published May 11 2022 01:12 PM 17K Views
Microsoft

Shape data with Power Query Editor 

 

Power Query is a powerful and time-saving set of tools that helps you get and shape data quickly and easily. When this tool was first released in Excel for Mac, there was incredible excitement around the new capabilities now available on your Mac device. Power Query in Excel for Mac allows you to clean and shape your data from local files, SharePoint, SQL, as well as from tables and ranges.

 

Once we introduced the capability to refresh data (see previous posts from May 2020,  July 2020, and October 2020), and import data (May 2021), we received a ton of requests to add the ability to transform data using the Query Editor, which would provide users the full Power Query experience in Excel for Mac.

 

We’ve heard your feedback and we are excited to share that you can now clean and shape your data with hundreds of transformations available in Power Query Editor in Excel for Mac. 

 

How it works

  1. On the Data tab, click the Get Data (Power Query) button.Image2_NEW-2048x1277.png
  2. Click Launch Power Query Editor to open the Query Editor.
    Image3_NEW-2048x1280.png
  3. You can shape and transform your data using the Query Editor as you do in Excel for Windows. When you’re done, click the Close & Load button on the Home tab.Image4-2048x1280.png

The newly imported data appears in a new sheet.
Image5.png

Tips & Tricks

  • Supported data sources include
    • text, CSV, XLSX, XML, and JSON files
    • SharePoint, SharePoint Lists, SharePoint Folders, and OData
    • local tables and ranges
    • Microsoft SQL Server
  • You can also access the Query Editor from the data import flow by clicking the Get Data (Power Query) button, choosing a data source, and clicking the Transform Data button.

    PQ Editor Preview.png

     

Availability

UPDATE (31-Aug-2022) This feature is available to Insiders using either the Current Channel Preview or Beta Channel, running Version 16.64 (Build 22072501) or later.  It was previously only available to Insiders on the Beta Channel.

 

Don’t have it yet? It’s probably us, not you.

We typically release features over a period of time to ensure that things are working smoothly. This is true for Insiders as well. We highlight features that you may not have because they’re slowly released to larger numbers of Insiders. Sometimes we remove elements to further improve them based on your feedback. Though it is rare, we also reserve the option to pull a feature entirely out of the product, even if you, as Insiders, have had the opportunity to try them. 

 

Feedback

We’d love to hear from you! Please click Help > Feedback to submit your feedback about this feature.

 

Learn what other information you should include in your feedback to ensure it’s actionable and reaches the right people. We’re excited to hear from you!   

  

Do you have an idea to make Excel better? We'd love to hear about it. Go to the Excel forum in Microsoft Feedback to submit your idea or vote for other ideas. You can also click the Feedback button in Excel and choose "I have a suggestion".

 

Sign up for the Office Insider newsletter and get the latest information about Insider features in your inbox once a month! 

 

Want to know more?  Subscribe to our Excel Blog to get the latest updates. Stay connected with us and other Excel fans around the world – join our Excel Community and follow us on Twitter. 

 

 

18 Comments
Co-Authors
Version history
Last update:
‎Sep 06 2022 09:11 AM
Updated by: