Contextures

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.

Video: 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

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.

  1. Go to the Contextures blog, and look for an RSS icon, in the sidebar at the right.
  2. Right-click on the RSS icon and click Copy Link Location

    rss link

Next, you'll use that RSS link to create an XML map in a workbook.

  1. In Excel, open the workbook where you want to create the RSS feed table
  2. On the Ribbon's Developer tab, in the XML group, click Source.

    rss link

  3. In the XML Source task pane, click the XML Maps button

    rss link

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

    rss link

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

    rss link

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

    rss link

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

    rss link

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

    rss link

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

    rss link

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

    rss link

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

Related Links

Data Entry Tips

Fill Blank Cells

Convert Text to Numbers

Increase Numbers With Paste Special

Search Contextures Sites

 

Excel Tools Add-in

 

Free Pivot Table Tools

 

 

excel chart tools by peltier tech

 

 

 

Pivot Power Premium

 

Excel Data Entry Popup List

 

Excel UserForms for Data Entry

 

Last updated: October 25, 2016 7:48 PM
Contextures RSS Feed