Show RSS Feeds in Excel
Instead of using an RSS reader, you can show items from an RSS feed on an 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 Feed
Instead of using an RSS reader, you can show items from an RSS feed
on an Excel worksheet. 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 the Contextures
blog.
- Go to the Contextures blog, and look for an RSS icon, in the sidebar
at the right.
- Right-click on the RSS icon and click Copy Link Location

Next, you'll use that RSS link to create an XML map in a workbook.
- In Excel, open the workbook where you want to create the RSS feed
table
- On the Ribbon's Developer tab, in the XML group, click Source.

- In the XML Source task pane, click the XML Maps button

- In the dialog box, click Add, to create a new XML map

- Click in the File Name box, and press Ctrl + V, to paste the copied
RSS link.

- Click Open, and then click OK, if a message appears.

- Click OK, to close the XML Map dialog box.
- In the XML Source task pane, find the Item section, and click
on the Item heading, to select it.

- Drag the Item section heading to cell B3 on the worksheet.

- This creates a table on the worksheet, with the headings from
the Item section.

- To see the list items, right-click on a cell below the headings,
and click Refresh

Method 2: Import the RSS Feed
If you have a problem with creating a new XML map (method 1), you can follow the steps below, to import the RSS feed.
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.
- Go to the Contextures blog, and look for an RSS icon, in the sidebar
at the right.
- Right-click on the RSS icon and click Copy Link Location

The RSS feed address on my Contextures blog is: https://contexturesblog.com/feed/
Import the RSS Feed
Next, you'll import that RSS link in an Excel workbook.
- In Excel, open the workbook where you want to create the RSS feed
table
- On the Ribbon's Developer tab, in the XML group, click Import.
- In the window that opens, click in the File Name box, and press Ctrl + V, to paste the copied
RSS link.

- Click Open, and the Import Data window will open.

- Optional - Click the Properties button and set the properties that you want
- Select a location for the data, and click OK, to close the Import Data window.
Format the Imported Data
- On the worksheet, click the Select All button, to the left of the Column A heading button, to select all the cells on the worksheet
- On the Excel Ribbon, click the Home tab, then click the Wrap Text command twice, to turn off the Wrap Text setting.
- Now you should be able to see the data in the table on the worksheet
See the XML Map
- To see the XML Map that was automatically created, go back to the Developer tab, and click the Source button in the XML group.
- The XML Source will appear in a pane on the Excel worksheet.
- Click on an XML Source item that has bold text, and that item will be highlighted in the worksheet table.

Get the Sample File
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.
Related Links
Data Entry Tips
Fill Blank Cells
Convert Text to
Numbers
Increase Numbers
With Paste Special