Microsoft has just posted a small application to their Download Center that gives you the ability to analyze Twitter results within Excel 2010. The 2.0 MB download can be found at the Microsoft Analytics for Twitter download page.
Now the ability to research a trend or topic on Twitter is in our hands for free!
Here is the description from Microsoft:
Microsoft Analytics for Twitter allows users to search Twitter and get dashboard views on Tweet statistics inside Microsoft® Office Excel 2010.
With this FREE add-in, you can:
Perform up to 5 parallel Twitter Searches (limited to 1500 results per query per day).
Drive ad-hoc analysis of tweets by day, by hour, by tweeters, by #hashtags and @mentions.
Customize your views (using slicers, DAX formulas or reference tables).
Please note, that, after Installation, Microsoft Analytics for Twitter will manifest itself as a Microsoft® Excel 2010 file called "Microsoft Analytics for Twitter.xlsx" on your desktop.
Please note that Microsoft Analytics for Twitter works only with the latest versions of Microsoft® Excel 2010 and of Microsoft® PowerPivot for Excel 2010. To download Microsoft® PowerPivot for Excel 2010, please go to www.PowerPivot.com.
Please note that Microsoft Analytics for Twitter takes advantage of Twitter Search (http://search.twitter.com/). During periods of high traffic volume Twitter Search does not always return search results. Please be patient and try your search again.
Here is the page that explains how to use the tool and formatting for search queries.
And finally here are some screenshots of the tool in action on a quick query I ran to try it out for the #NASATweetup Twitter hashtag.