I need to be able to incorporate some sort of updating news feed into a report. I want to know if anybody knows how to put an RSS feed into a spreadsheet which will remain formatted how I want it etc. and update everytime the spreadsheet is opened.

I have searched a lot on this and using google spreadsheets seems to be the only way but I can't get my head around the formulae.

Any help would be much appreciated,