martedì, agosto 04, 2009

Get external data from a Web page using Excel

You don’t hear me rave about Microsoft that often, but this feature is awesome! Ever wished you could get tabular data from a web page into Excel? Try the following:

  1. In Office Excel, on the Data tab, in the Get External Data group, click From Web. The New Web Query dialog box appears.
  2. In the New Web Query dialog box, enter the URL for the Web page from which you want to get data.
  3. Click Go.

Here’s an article on this topic at Microsoft Office Online.