Instead of using an RSS reader, you can show items from an RSS feed on a Microsoft Excel worksheet. Get the free workbook with an example. Two methods are shown -- add an XML Map, or import the feed.
RSS (Real Simple Syndication) feeds provide details on website content updates, in a structured format. You can use an RSS reader (news aggregator), to find new content from your favourite blogs and websites, using software, a mobile app, or on a web browser.
Or, instead of using an RSS feed reader, you can show items from an RSS feed on an Excel spreadsheet. See the steps in this video tutorial. The written instructions are below the video.
Show RSS feed on a Worksheet
The first step is to find the link for the RSS feed that you want to show on the worksheet. In this example, we'll use the RSS feed for new articles from the Contextures Excel blog.
To get the link from the Contextures blog, follow these steps:
Create XML Map
Next, you'll use that RSS link to create an XML map in a workbook.
Message: "The specified XML source does not refer to a schema. Excel will create a schema based on the XML source data."
After you add the map, it should appear in the XML Maps in this Workbook list
Add XML Map to Worksheet
After the map has been created, follow these steps to add it to the worksheet, and see the data.
Modify the XML Table
Here are a few things you can do to modify the XML table, so it's easier to read.
The XML table has columns that you might not need, so follow these steps to delete them
If you have a problem with creating a new XML map (method 1), you can follow the steps below, to import the RSS feed into Excel sheets.
Get the RSS Feed Address
The first step is to find the link for the RSS feed that you want to show on the worksheet. In this example, we'll use the RSS feed for the Contextures blog.
Import the RSS Feed
Next, you'll import that RSS link in an Excel workbook.
Format the Imported Data
See the XML Map
To see the RSS feeds for the Contextures Blog and the Contextures website, you can get the sample file: Excel RSS Feeds Sample File. This was created with Method 1 -- Add XML Map.
Last updated: December 6, 2023 2:31 PM