STEP 1

Click on the Data Tab.

In the Get & Transform Group, select From Web .

001.png

STEP 2

Type the URL.
In this example - we want to get the "List of highest-grossing films" from Wikipedia.

002.png

STEP 3

Select the Table you need from the left pane.
In our case, we select the Table Highest-grossing films[13].
Then click on Load.

003.png

STEP 4

A new sheet is created.
The Table contains the data that we want.

004.png

STEP 5

To Refresh the data from the website, simply Right Click on any cell within the Table.
Then click Refresh.

005.png

STEP 6

To set up Automatic Refresh, click Query Tab, then Properties.
In the Dialog Box, choose the minutes. Default is 60 minutes. Minimum is 1 minute.

006.png
007.png

GET SAMPLE FILE AND SOLUTION

Send an email at:

havish@havishmconsulting.com 

  • LinkedIn
  • YouTube
  • Instagram

©2020 by HAVISH M. CONSULTING. Proudly created with Wix.com