Back in 2011, we released a great PowerPivot sample application to query Twitter and analyze tweets within Excel 2010. This was a joint venture between Microsoft and ISV Gold BI partner Extended Results, and the great news is that Extended Results has finished an updated version that now also works in Excel 2013! For all the details, including a Quick Start Guide and some details about the Twitter Search Query Syntax, see the “Analytics for Twitter 2013” page on Microsoft TechNet.
The new Twitter Analytics for Excel tool provides a number of improved features, including:
- Better UI control to apply new styling and drive better insights.
- Better integration of PowerPivot so you don’t have to go behind the screens to refresh.
- Several features for in-application development allow for better control with integration with Web services like Twitter and pulling all kinds of data content.
- An application dialog showing the data/content as it’s being pulled.
Note that you might run into an installation issue because the Analytics for Twitter 2013 installer expects to find an Office15 folder in your Program Files (x86) directory. If such a folder doesn’t exist (and most likely it doesn’t because it is called Microsoft Office 15 or you have installed the 64bit version of Office), the installation will fail with an error that “Microsoft Office 2013 or greater needs to be installed for this installation to continue.”
This issue is easily fixed. Just create an empty Office15 folder under Program Files (x86). You can find a download link on the “Analytics for Twitter 2013” page on Microsoft TechNet. Happy Tweeting and Analyzing!
This is a really cool app. Love that it is free, but it is worth paying for.
P
Was just trying to install it, and ran into the problem described above with 64bit Office 2013. Thanks for the quick solution!
I am getting below error during the install
The operating system is not adequate for running Analytics for Twitter 2013
OS – Windows Server 2008 R2
Office 2013 Professional Plus 2013
Thanks! This is awesome.
The twitter analytics ribbon has dissapeared and i can't get it to reappear?????????????
This is a great tool 🙂
Can we load tweets older than 7 days? can we control the search period?
That's great. Exactly what I've been looking for. Thank you Microsoft.
Has this been looked at as a SharePoint add-in, and if so, what are the licensing implications with Extended Results?
Check out extendedresults.com/…/twitteranalytics. There is a Contact Us link at the bottom of the page to reach Extended Results.
the http://www.extendedresults.com/…/ertwitterforexcel2013.zip link is a broken link
Download link is broken. Please fix it. Thanks
http://www.extendedresults.com/…/twitteranalytics
I love this tool! however powerview analysis didn't show up! really want to figure what's the reason?!
Whoa! I love this tool. I was wondering how to build something like this in Tableau but why bother when all the heavy lifting has been done for me? Sheesh!?! Way to go Microsoft! Now can you do the same for facebook and all the other social media sites? ahhahaha
You're link is unfortunately broken…
Thanks! Link fixed.
It is not working anymore… Are you gonna find a workaround to fix the app? Everyone one want to know !
Thanks anyway, great job.
Hi Louis,
The AS team doesn't maintain this app. It would be up to Extended Results to fix it. This here was just an announcement that it was available. Have you contacted Extended Results?
Cheers,
Kay
I've contacted Extended Results and apparently there have been some recent changes to the Twitter API which means this may not work correctly anymore.
Extended Result has been bought by Tibco Spotfire! The link goes to Spotfire …
How does one get the addon now that the link routes to Spotfire?
Should be fixed now. TechNet has updated the Analytics for Twitter 2013 page and included a new download link.
The download link takes me to http://spotfire.tibco.com/ ?
Outdated download link removed. Added a reference to go to the TechNet page for an updated download link.
can anyone please tell me how do you put in your credentials
regards
Aj
Good morning. It is impossible to me to download Analytics for Twitter 2013, I cannot see the place to click and to download it. What can I do? Could you help me?
I get the message "Pin validation fail" when i try to authorize Analytics for Twitter in Excel 2013?
Tried both on work network and home network.
Hello
Where can i download analytic for Twitter 2013? this link sends me to spotfire
Any chance anyone can send me the original download zip file of Twiiter for Excel 2013 (ertwitterforexcel2013.zip)? I’d like to give it a go please. Email is asehmi at oxordeconomics dot com.
Many thanks,
Arvindra
cannot install it!!!!!!! HELP!!!!!!
Extended Results is taken over by TIBCO Spotfire.. Is there a link where we can download the installer for twitter analytics.. I am unable to find it.. Pls help!!
I am trying to use the excel plug, my query was very simple "#microsoft" but it gives me this error
"An exception occur while requesting a new query. If the problem persists, please visit us at the wiki page at tinyurl.com/AnalyticsforTwitter2013 and post feedback for new issues."
Any help please?
Is there still a possibility to download the file? Can't find it anywhere.
looks very cool, but yes , the link is now broken and cannot download
I was following the links and ended up at http://www.PlusOneSocial.com. Tried to download and nortons says it was a medium threat. is there another place I can get this information?
No use trying to download the software, it is useless since Twitter's modified their API last year.
can you please post the download link
can you please post a download link