It is often necessary to collect data from web-based sources due to updates and other modifications. An example of a web-based data list would be a list of currency conversion amounts. It is possible to go to the Web, find the currency that you need and to record the information manually; however, due to daily updates and multiple currency conversions, the process can be costly and time-consuming.
In this recipe, you will learn how to import data from the Web. While the steps used to perform this data import are native to Excel, this recipe has been included within the building on section due to the external use of data and the new functionality of this process within Excel 2007 and Excel 2010.