Search Contextures Sites
Instead of using an RSS reader, you can show items from an RSS feed on an Excel worksheet.
- Video: Show RSS feed on a Worksheet
- Show RSS feed on a Worksheet
- Download the Sample File
- More Excel Tips and Tutorials
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.
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.
First, 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
To see the RSS feeds for the Contextures Blog and the Contextures website, please download the sample file: Excel RSS Feeds Sample File
Contextures Inc., Copyright ©2016
All rights reserved.
Last updated: May 30, 2016 10:52 AM