Importing Data from the Internet

Have you ever needed data from a website to go into an Excel spreadsheet? Microsoft has a tool for that.

  • Under the data tab, choose “From Web” in the “Get External Data group”.
  • In the small browser that pops up, navigate to the page with your data. In this example. I searched in Wikipedia for the top grossing movies of all time.
  • Click Import, Choose a destination for the data, Wait, and Voila! Your data will be in the spreadsheet.

from_webtop_movies

 

 

 

 

 

For more excel techniques see our Excel Training Class.