Get started with Power Query and take your data transformation skills to the next level. First, let's import some data.
Note: Although the videos in this training are based on Excel for Microsoft 365, we've added instructions as video labels if you are using Excel 2016.
-
Open Excel, and on the home screen, select New. In the Search for online templates box, search for Power Query.
-
Open the Power Query tutorial and press Create.
-
On the Import Data from Web worksheet, copy the URL, which is a Wikipedia page for the FIFA World Cup standings.
-
Select Data > Get & Transform > From Web.
-
Press CTRL+V to paste the URL into the text box, and then select OK.
-
In the Navigator pane, under Display Options, select the Results table. Power Query will preview it for you in the Table View pane on the right.
-
Select Load. Power Query transforms the data and loads it as an Excel table.
-
Double-click the sheet tab name and then rename it "World Cup Results".
Tip: To get updates to this World Cup data, select the table, and then select Query Refresh.
