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.
Show RSS Feed on a Worksheet
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
- 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
- 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
- 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
Download the Sample File
To see the RSS feeds for the Contextures Blog and the Contextures
website, please download the sample file: Excel
RSS Feeds Sample File
Data Entry Tips
Fill Blank Cells
Convert Text to
With Paste Special