Excel 2007 Web Data Add-In

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.

Office Blogs Comments

Comments: (7) Collapse

  • with EXCEL 2007 open, using VISTA ... the add-in will not install ... it says "requires EXCEL 2007 to be installed"

    Is this a Vista problem?

    Thanks.

  • How is this different from Web Query which has been in Excel for years?

  • @doug churchill

    Hi Doug --

    Thanks for trying to install the add-in. That message is probably unrelated to Vista. It only appears if the detect Excel 2007 launch condition fails in setup, specifically, if the value "Excel.Application.12" does not appear in the regkey "hkey_classes_root\excel.application\curVer." If you don't have that value in your registry, I'd suspect an install issue for Office or you're running a non 2007 release. To follow up on this issue please contact us via email by reaching us on the contact form of our blog (see above post for link). Thanks!

  • Hi Dave,

    Must be about time I ask for the technology roadmap again?  Come on Dave, you know you want to let all us Excel developers know the Microsoft roadmap for developers - should we write XLLs, .xlas, COM addins, .net addins etc etc.  Tell all!!

    Cheers,

    John

  • is the book online somewhere to see online in stead of buying it?

  • Hi John - it is our our list.

  • Hi,

    this application is indeed helpful. But may I know how do I prevent the updated data to save over the old data?

    I would like to keep a list of the old data also.

    Thanks

Comments: (loading) Collapse