Search Contextures Sites
Custom Search

 

 

 

Learn how to create Excel dashboards.

 

 

 

Your worksheet formulas can create traffic-light charts, highlight chart elements, assign number formats, and more.

 

 

 

30 Excel Functions in 30 Days

 

 

Learn how to create Excel dashboards.

 

 

Live-link your Excel dashboards to nearly any web data.

 

 

Learn how to create Excel dashboards.

 

 

Excel RSS Feeds

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

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
  3. 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.
  3. rss link

  4. In the XML Source task pane, click the XML Maps button
  5. rss link

  6. In the dialog box, click Add, to create a new XML map
  7. rss link

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

  10. Click Open, and then click OK, if a message appears.
  11. rss link

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

  15. Drag the Item section heading to cell B3 on the worksheet.
  16. rss link

  17. This creates a table on the worksheet, with the headings from the Item section.
  18. rss link

  19. 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

More Excel Tips and Tutorials

1. Excel Data Entry Tips
2. Excel Data Entry -- Fill Blank Cells
3. Excel Data Entry -- Convert Text to Numbers
4. Excel Data Entry -- Increase Numbers With Paste Special

 

Privacy Policy

 

Contextures Inc., Copyright 2016
All rights reserved.

 

Last updated: May 30, 2016 10:52 AM