Web Page Monitor using Google Docs

Posted on September 16th, 2008 in ideas , Learn Excel , technology - 4 comments

using-xpath-google-docsMy guest post on monitoring web page changes using google docs is posted in Digital Inspiration – one of the most popular technology blogs. Do read it to learn a little bit about using XPATH, RSS Feeds, Google Spreadsheet import() functions.

Here is a summary of the technique:

  • First go to the web page which you are planning to track using spreadsheets
  • For each item on the web page that needs to be tracked, findout its XPATH (learn more about XPATH)
  • Create a importXML() formulas for each of this elements in your Google spreadsheets.
  • Finally, save the spreadsheet and subscribe to its RSS Feed to keep track of the web page you are aiming to monitor.

If you are looking for a way to access RSS feeds from your Excel sheet, read this.

Your email address is safe with us. Our policies

Written by Chandoo
Tags: , , , , , , ,
Home: Chandoo.org Main Page
? Doubt: Ask an Excel Question

4 Responses to “Web Page Monitor using Google Docs”

  1. Naga says:

    Hi Chandoo,

    The site is really interested with focus towards effective selected topics. All the Best.

    Regards
    Naga

  2. Chandoo says:

    @Naga .. thanks man :)

  3. [...] Findout when that iPod is available for cheap. Learn xpath and track almost everything [...]

  4. Dan says:

    Hi,

    I am trying to link excel and web. But when I go through the steps then I get an error, “File cannot be opened because:Use of default namespace declaration attribute in DTD not supported. Line 4, Position 7.

    How can I fix this issue

Leave a Reply