Excel: Power Query - all info at a glance

Excel offers you various ways to manage and process large amounts of data. With the integrated "Power Query" tool, Microsoft also gives you a tool that makes it especially easy to merge data from different sources.

How to find Power Query in Excel

The Power Query tool gives you the ability to merge different data sources in Excel and model them according to your needs.Follow these steps to add data sources via Power Query in Excel:

1. Open the Excel document into which you want to import data via Power Query.
2. Switch to the "Data" tab.
3. Click "Get Data" in the ribbon, then select the source type and follow the corresponding steps.
4. Use the navigator to select which elements you want to import from the data source and click the "Load" button.

After the import, a new sidebar opens, allowing you to manage and update the imported data sources.

Open Power Query Editor

The Power Query Editor offers you extensive options to edit the imported data. For a better overview and maximum flexibility, any editing steps are recorded there, so you can easily react to problems without starting over. In addition to the simple back and forth function, you also have the option to repeat steps or adjust the sequence afterwards.

1. Switch to the "Data" tab.
2. Click the "Get Data" button in the "Get and Transform Data" category in the ribbon and select the "Power Query Editor" option.