RSS Feeds in Excel

This article will demonstrate how to link an RSS feed to Excel

 

 

To link an RSS Fed to Excel you have two options:

1. Add an XML Map
2. Link the feed to Excel.

Add an XML Map

To add an XML map to your Excel sheet, follow these steps:

1. Have a workbook open where you want the data to be displayed and then, in the Ribbon, select Developer > XML > Source.

 

 

Note if the Developer Ribbon is not showing, you can enable the ribbon by following the instructions here.

1. Then, in the XML Source Pane that appears on the right hand side of your screen, click the XML Maps button.

2. Click the Add button.

3. Type in the path for the rss feed and click Open.

4. An rss_Map will appear in the XML Maps list.

5. Click OK to display it in the XML Source pane.

6. Now scroll down until you find the item folder and then click on that folder.   It will select all the headings underneath that folder.   Click and drag the folder to the desired position in your worksheet.

 

 

7. The headings under the item folder will appear as headings in your worksheet.

 

8. Right click in the row underneath the headings and click Refresh.

9. The RSS Feed will then appear in your worksheet.

Link the RSS Feed to Excel

1. Have a workbook open where you wish to link your feed to and then, in the Ribbon, select Developer > XML > Import.

2. Type the URL for your RSS feed into the File Name box and then click Open.

3. Select the location to import the data to, and then click OK.

4. A table will be created with the RSS Feed.   The first 11 or so columns will be identical.

5. Scroll to the right of the table to see the additional columns to show you the individual items in the RSS Feed.