TechSutra

View Twitter Updates in Excel and Google Docs Spreadsheet

After seeing SpreadTweet which is a twitter client disguised to look like an excel spreadsheet, I was wondering whether you can actually use Excel or Google Docs to see your twitter updates. Turns out you can!. The caveat is that your updates should be public and in the case of google docs, there may be a delay in updating the statuses.

First, you need the RSS and XML feed links for your updates. The format is

http://twitter.com/statuses/user_timeline/username.rss and  http://twitter.com/statuses/user_timeline/username.xml. For example for example http://twitter.com/statuses/user_timeline/boundlessdreamz.rss and for example http://twitter.com/statuses/user_timeline/boundlessdreamz.rss

Using Google Docs SpreadSheet

Using Excel

Screenshots

excel-tool-bar

excel-web-query-window

twitter-in-excel

blog comments powered by Disqus