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.
There’s a lot to Power Query. Start here to get the big picture and develop the skills you need to become proficient at it.
Excel has always been a rich platform for safely importing and connecting to a wide variety of data sources that you can analyze and refresh to get up-to-date information.
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.
When shaping data, you can perform many tasks on columns, such as adding, removing, renaming, splitting, and expanding them.
When shaping data, you can perform many tasks on rows, such as promoting or demoting column headers, removing, adding, and correcting them.
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.
Power Query is a mature technology and the following help topics show how to perform advanced operations.