Nov 03 2009
Add RSS Feeds with Google Spreadsheet
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:
Create a free edublog to get your own comment avatar (and more!)
Patricia Donaghy
[...] This post was mentioned on Twitter by pdonaghy, Matthias Heil and Tamas Lorincz, Melissa Lim. Melissa Lim said: RT @tamaslorincz: Add RSS Feeds with Google Spreadsheet http://bit.ly/MYMYQ ||Brilliant indeed. [...]