Applies ToExcel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2024 Excel 2021 Excel 2019 Excel 2016

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.

You can refresh data sources on Excel for the web.

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

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.