This function fetches external feed data and loads it in to the spreadsheet. We will now use google’s importfeed() external data function. We will use a round about way to get RSS feed to our excel sheet. First Create a new Google Docs – Spreadsheet.So here is a simpler way to read RSS/ATOM/XML feeds from excel sheets.įor this example, let us build an excel sheet that will fetch Amazon Gold box Today’s deals RSS feed show all deal titles and product URLs. But the problem is, the layout is messy, and too confusing. Of course, Excel 2003 (and above) has XML import option using which you can get any XML files (and thus RSS files too) and show them in spreadsheet. So much more, just use your imagination.Watch news, alerts on your company / brand / blog using technorati, google news etc. Prepare a sheet to watch deals on Amazon, Craigslist, Deals2buy and other favorite sites.If you can get the RSS feeds to excel sheet you can do pretty interesting things with it, like: So much that you cannot avoid them in your data processing, analytics or day to day spreadsheet needs.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |