Click on the Data Tab.
In the Get & Transform Group, select From Web .
Type the URL.
In this example - we want to get the "List of highest-grossing films" from Wikipedia.
Select the Table you need from the left pane.
In our case, we select the Table Highest-grossing films.
Then click on Load.
A new sheet is created.
The Table contains the data that we want.
To Refresh the data from the website, simply Right Click on any cell within the Table.
Then click Refresh.
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.
GET SAMPLE FILE AND SOLUTION
Send an email at: