M365 Excel - Import Data from the Web – Union County IT

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.

Related to