Dynamic Views: Flipcard | Mosaic | Sidebar | Snapshot | Timeslide

Tuesday, November 3, 2009

Add RSS Feeds with Google Spreadsheet

Google Docs

Using Google Spreadsheet , you can easily import any RSS feed into your blog or website.

Using the attached spreadsheet example, the steps are as follows:

1. Enter the RSS URL in cell A3. 
http://feeds.feedburner.com/FreeResourcesForEducation
2. Enter the following formula in cell D3.
=importfeed(A3, "Items title", False, 4)
3. Enter the following formula in cell E3.
=importfeed(A3, "Items URL", False, 4)
4. Enter the following formula in cell C3 and replicate it in the next 3 cells.
=D3
5. Enter the following formula in cell B3 and replicate it in the next 3 cells.
=HyperLink(E3, C3)
6. Select Share, Publish as a web page, Start publishing
7. Select HTML to embed in a page
8. Select Sheet1
9. Enter the cell range.
B2:B6
10. Copy the <iframe> code and select Close
11. Paste the <iframe> code into your blog or website

NB: Set widget=false and add gridlines=false to remove extra unwanted features. Adjust the height and width to suit your site.

Original Spreadsheet:


Resulting RSS feed:


0 comments:

Post a Comment