My 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.
3 Responses to “Top 5 Excel Skills you need to be a Successful Data Analyst in 2023 (podcast)”
Thanks Chandoo, some great helpful tips here. I'm quite good at Excel (mainly thanks to you!) but I'm always learning. I love the link you gave above to Dynamic Arrays & Spill Ranges, I understand them a bit more now, and can see some uses for them.
I am glad you enjoyed the show Dermot.
Great to see you back! Enjoyed when you first started the podcast and super excited to start listening to you again!