Power Query is a technology embedded in Excel and other Microsoft products designed to help you shape your data. In Excel, select the Data tab on the ribbon to see the Get & Transform Data and Queries & Connections groups.

After you import and refresh data from a wide variety of data sources, you can then shape the data in a step-by-step transformation that gradually creates a unique, tabular shape to fit your data analysis needs.

We recommend you make this help topic a browser favorite that you can frequently use to easily find the Excel Power Query information you seek and corresponding help information in the Power Query documentation help site.

Follow like-minded folks who can often answer questions for you.

The most common way to create a query is to import data. After you shape your data in Power Query, you often load it into a worksheet or Data Model. Periodically, you may want to edit the query.

External data sources have connection information and data properties that you sometimes need to view and update.

Good news. You’ll find that filtering and sorting data in Power Query is very similar to Excel.

Sometimes you need to group data by a label, aggregate data with operations (Sum, Count, Average, Min, and Max), merge queries, and append queries.

Although most of the transformations you make when you shape data can easily be done in the user interface, the Query Editor is also a way to fine-tune your transformations, and when necessary, add formulas to solve complex issues.

You can import and refresh data files and databases on the Mac.

These help topics provide the reference information you may need along your data-shaping journey.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×