About Microsoft Excel

Get External Data from the Web

Home Back Next

The web can be a great source for different kinds of interesting data and therefore let's learn how to get external data from the web into MS Excel.
  • Click on the Data tab
  • From the command group 'Get External Data' we'll click on 'From Web'
  • We'll go the website http://www.google.com/finance
  • Here we'll navigate to the area where you can see a black arrow with yellow background next to 'Dow Jones' . The arrow indicates that we can click on it and then perform an import of data
  • Click the arrow - Dow Jones S & P 500 and Nasdaq are selected
  • Click on the Import button below
  • A new window opens with the the title 'Import Data'. Below that you can read - where do you want to put the data? The option Existing Worksheet is selected and in the text below is written =$A$1
  • Since we have data in cell A1 we select cell A3
  • We can click on properties and set some interesting parameters like the time to refresh the data. We could refresh it every ten minutes
  • We click on OK
  • Data is imported into the Excel worksheet starting at cell A3 as specified by us
You can go to other interesting websites like payscale.com and import data that you may find interesting for data analysis. Not all websites allow import of data.

Home Back Next