In addition to importing data to Excel, Power Query is designed to “transform” data. You can easily do things like remove columns or rows, rename and reorder columns, split columns, add new columns, fix date problems, join tables, and much more. The beautify of Power Query is that each step is defined separately in a query. When you “refresh” the data, all steps will be automatically repeated in exactly the same order. You can find Power Query tools on the Data tab of the ribbon:
Key benefits
Power Query has a vast set of features that are updated frequently. In a nutshell, here are a few key benefits:
Import data of all kinds directly into Excel with a modern and robust tool. Refresh data directly in the Excel workbook. No need to navigate back to a website and download data manually. Define specific steps to retrieve, clean, and reshape data. These steps will be repeated, in order, each time data is refreshed. Drop data into an Excel Table to analyse with formulas, pivot tables, and charts.
Power Query Examples
These articles have sample workbooks with simple queries already set up:
Tracking COVID-19 with Excel (more detail) Download Coronavirus data to Excel (3 more datasets)
Author
Dave Bruns
Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.
