How to Import data from Web in Excel

I was exploring something by which I could get the frequently changing data from web and create my own dashboard or use that data. I found one solution of it in Excel.

Excel provides wonderful feature to import web site’s data into Excel sheet and one can refresh that data when needed.

So here are the steps for it:

1. Open Excel, go to Data tab
2. Click on From Web

   

3. Enter the URL of the web site, from which you want to extract the data
4. Now traverse through the site and enter credentials if required
5. Select the yellow box area to Import data
6. Click on Import
7. Excel will start importing the data from web site mentioned by you
8. It will ask you for the starting cell location to copy the text data from site
9. You will find your data is here.
10. You can edit the URL or settings by selection Edit Query option in Context Menu

    

11.  Refresh the data, by clicking on the starting cell on which data is imported from web and then click on Refresh All button on the top menu.
12. Get dynamic data from web in your excel and create updated documents. no need to keep track of the updated data for your calculations in excel 🙂