How do I import data from the web into Excel 2007? You can receive stock quotes and other data from the web by using the "Get External Data" feature in Excel. You can use Existing Connections that will dump data into your Excel worksheet, and can be refreshed from time to time using the Refresh feature. Either way you can only dump data from different websites into or onto one worksheet. In other words, each worksheet can only contain or hold data from one data dump, and so when you refresh that link, you're actually refreshing the whole worksheet to update and include the latest from the imported website. See how to import data from the web with our Excel training videos!

Purchase the training video and you can see this in action for yourself!