Home > Skills > Data Entry > RSS Show RSS Feeds in ExcelInstead 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. |
Method 1: Add XML Map to Show RSS FeedRSS (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 WorksheetThe 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 MapNext, 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 WorksheetAfter the map has been created, follow these steps to add it to the worksheet, and see the data.
Modify the XML TableHere are a few things you can do to modify the XML table, so it's easier to read. Cell Alignment
Delete ColumnsThe XML table has columns that you might not need, so follow these steps to delete them
|
Method 2: Import the RSS FeedIf 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 AddressThe 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 FeedNext, you'll import that RSS link in an Excel workbook.
|
Format the Imported Data
See the XML Map
|
Get the Sample FileTo 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. Related Links |
Last updated: January 8, 2023 4:00 PM