Now you can Microsoft Excel to read your Twitter Tweets and your own updates from within Excel. All that’s required to set it the feed and link it to the Excel spreadsheet. No other downloads are required.
To view your Twitter messages sent to you:
1. Login to Twitter
2. In the right-hand column look for the ‘RSS feed’ link
3. Copy the link, e.g. http://twitter.com/statuses/friends_timeline/123456.rss
4. Open a blank worksheet in Excel
5. Open the Data tab and click on the ‘from Web’ button.
6. Paste the link into the web address field.
Excel recognizes the RSS feed as an XML file. Let Excel choose the feed.
7. Click Import. Next.
Excel will tell you that “the XML source does not refer to a schema”.
8. Click OK.
9. Place the results where you wish, for example, in a new worksheet.
10. Choose ‘Wrap Text’ so you can see an entire tweet.
Need help with your web writing? Click here for a Free Quote
Comments on this entry are closed.