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.

Do you want to be awesome in Excel?

Free Excel tips book - joining bonus - Chandoo.org newsletter

Here is a smart way to become awesome in Excel. Just signup for my Excel newsletter. Every week you will receive an Excel tip, tutorial, template or example delivered to your inbox. What more, as a joining bonus, I am giving away a 25 page eBook containing 95 Excel tips & tricks. Please sign-up below:

Your email address is safe with us. Our policies

More awesome tips for you:

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.


  2. Chandoo says:

    @Naga .. thanks man :)

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

  4. Dan says:


    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