If you find yourself yearning to view Twitter updates in a worksheet, then this is for you. Seriously, Excel can be a useful tool for viewing Tweets, allowing you to format them to your liking. You can add multiple Twitter feeds to your worksheet and have an inconspicuous viewer to read them.
1. Open Excel and create a new workbook.
2. Open your browser and go to the Twitter Profile page that you wish to follow the updates for (for example http://twitter.com/Varun_Dave).
3. On the Twitter page, go to the column on the right-side of the page. Beneath the Following section, you will see an RSS icon 
and a link for the RSS feed of this page. Right-click the link and copy the link address.
4. Go to your newly created Excel workbook. Select the cell that you wish the Tweets to begin displaying.
5. Go to the Ribbon and select the Data tab.
6. Click Data -> XML -> XML Source.
7. A Open File window will open. Paste the copied url into the textbox and click the Import button.
8. A window will open fetching and opening data from the rss file you specified. Wait till the data is loaded.
9. A message window will appear stating that the specified XML source does not refer to a schema, click the OK button.It will ass for where to save the data.Click OK with the default options.
10. An Import Data window will appear, verify that the desired starting cell is used. Click the OK button. A large amount of columns will appear in your workbook. The main ones you will be interested in are description3 and guid. These will display the Tweet and its URL. Hide the rest of the columns.
11.Go to the Format – Cell. In the Allignment section, click the Wrap Text checkbox so that the entire tweet will be visible. Resize the column to the desired width.
12. Select all cells in both columns. Use the Table Styles section to style the selection.
13. Save the worksheet.
14. When you want to check for new tweets, go to the Data tab on the Ribbon and select the Refresh All button. Any new tweets will be shown in the worksheet.
Popularity: 46% [?]
Did you missed any of these posts ?
Leave a comment