Some folks at Microsoft Research have developed an add in that makes it easy to use a Web page as a data source in Excel. Here is a brief description:
The Excel 2007 Web Data Add-In provides an intuitive user interface for importing textual data from any given webpage via a userâ€™s selections of interest, such as stock quotes, weather temperature, ect, into a spreadsheet and keeping that data â€œup-to-dateâ€. That is, if the webpage data changes, the spreadsheet can be updated by a click of the data â€œRefreshâ€ button. Also note that the add-in can automatically learn from a userâ€™s selection and optionally select similar items to help save time.
Please note that this add-in is a research beta and is unsupported by Microsoft. Feedback and bugs can be sent via the add-in itself (under the itâ€™s help menu) or the add-inâ€™s blog comments.
The add-in is available here. Please feel free to give the Research team feedback.