As you’ve heard, Google Reader will be disappearing in a few months <sigh>, and we’ll have to find other ways to follow our favourite blogs. I’m looking for a replacement, but haven’t found anything perfect yet. How about you?
In the meantime, I can at least list a few RSS feeds in Excel, by using some built-in tools. In the video below, you can see how I created a list of articles from this blog, using an XML map.
Create the RSS Feed List
It’s easy to create an RSS feed list on a worksheet, as long as you have the link for the RS feed. In this blog, there is an orange RSS icon in the right sidebar, near the bottom. Just right-click on that button, and copy the Link Location.
Then, in Excel, create and XML map, using the tools on the Developer tab.
Watch the Excel RSS Feed Video
To see the steps for creating an RSS feed list on a worksheet, please watch this short video tutorial.
Download the Sample File
For written instructions, and to download the sample file, you can visit my Contextures website: Excel RSS Feeds