• Blog
  • Excel Downloads
    • Audit Tickmark Toolbar
  • Courses
    • Power BI
  • Contact
  • Checkout

Excel Zoom

...because it's more than just a calculator


10 Excel Tips For Increased Productivity

July 4, 2014 by Mark 4 Comments

Excel Tip #10: Use Excel as an RSS Feed Reader

If you don’t like using any of the available RSS feed readers to get updates from your favorite blogs and websites, you can use an Excel spreadsheet to generate an RSS feed.

To create an RSS feed in your spreadsheet:

  1. Go to your favorite website and look for the RSS icon or link. Usually this is an orange icon with three semi-circles forming what looks like a cone. Right click the link, and select Copy Link location.
  2. Open Excel, and on the Developer tab, click the Source button in the XML group.
  3. Click the XML Maps… button at the bottom of the XML Source window.
  4. Click the Add… button in the XML Maps window.
  5. Paste the RSS feed link you copied from the website earlier into the File name box, and click Open.
  6. If a message appears regarding the XML source not referring to a schema, click OK.
  7. Click OK to close the XML Map window.
  8. In the XML Source window, find the Item folder and click on it to select it.
  9. Drag the Item heading to a cell in your worksheet. This will create a table with the headings from the Item section in the XML Source window.
  10. To populate the RSS Feed, right click on a cell below the headings and click Refresh.

What other Excel tips can you think of?

Pages: 1 2 3 4 5 6 7 8 9 10 11

Filed Under: Tips Tagged With: Automatic, Cell, Formats, Shortcuts, Tips

Looking For More Help?

Contact us with any specific questions or feedback. We love to hear from you!

Recommend a new product and EARN! Contact us here for info

Need to level up your career? See our amazing Excel Courses here

Looking for the Excel Audit Tickmark Toolbar? Click Here, NOW ONLY $97!

Subscribe to our mailing list
  • Facebook
  • Twitter

Search this site…

Power BI Webinar
Power BI Course
Free Excel Dashboard Webinar

Copyright © 2025 · Magazine Pro Theme on Genesis Framework

Login Form

Lost your password?