Free Cool Tools: Microsoft Analytics for Twitter
Analytics for Twitter allows users to query Twitter directly in Microsoft® Office Excel 2010. Utilizing the free PowerPivot Excel Add-in users can perform their own analysis such as who are the top Tweeters, what #hashtags are they using and do they have a positive or negative tweet tone.
Download Analytics tools from here.....
https://www.microsoft.com/download/en/details.aspx?id=26213
You need Power Pivot.....
https://www.microsoft.com/download/en/details.aspx?displaylang=en&id=7609