Released: Twitter Analytics for Excel 2013

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!

Comments

• Anonymous
  March 18, 2013
  This is a really cool app.  Love that it is free, but it is worth paying for.P

• Anonymous
  March 19, 2013
  Was just trying to install it, and ran into the problem described above with 64bit Office 2013. Thanks for the quick solution!

• Anonymous
  April 11, 2013
  I am getting below error during the installThe operating system is not adequate for running Analytics for Twitter 2013OS - Windows Server 2008 R2Office 2013 Professional Plus 2013

• Anonymous
  April 29, 2013
  Thanks! This is awesome.

• Anonymous
  April 29, 2013
  The twitter analytics ribbon has dissapeared and i can't get it to reappear?????????????

• Anonymous
  May 08, 2013
  This is a great tool :)Can we load tweets older than 7 days? can we control the search period?

• Anonymous
  July 02, 2013
  That's great. Exactly what I've been looking for. Thank you Microsoft.

• Anonymous
  July 09, 2013
  Has this been looked at as a SharePoint add-in, and if so, what are the licensing implications with Extended Results?

• Anonymous
  July 09, 2013
  Check out extendedresults.com/.../twitteranalytics. There is a Contact Us link at the  bottom of the page to reach Extended Results.

• Anonymous
  July 27, 2013
  the www.extendedresults.com/.../ertwitterforexcel2013.zip link is a broken link

• Anonymous
  July 29, 2013
  Download link is broken. Please fix it. Thanks

• Anonymous
  July 30, 2013
  www.extendedresults.com/.../twitteranalytics

• Anonymous
  September 26, 2013
  I love this tool! however powerview analysis didn't show up! really want to figure what's the reason?!

• Anonymous
  October 24, 2013
  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

• Anonymous
  November 04, 2013
  You're link is unfortunately broken...

• Anonymous
  November 05, 2013
  Thanks! Link fixed.

• Anonymous
  November 05, 2013
  It is not working anymore... Are you gonna find a workaround to fix the app? Everyone one want to know !Thanks anyway, great job.

• Anonymous
  November 06, 2013
  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

• Anonymous
  November 29, 2013
  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.

• Anonymous
  December 10, 2013
  Extended Result has been bought by Tibco Spotfire! The link goes to Spotfire ...

• Anonymous
  December 11, 2013
  How does one get the addon now that the link routes to Spotfire?

• Anonymous
  December 16, 2013
  Should be fixed now. TechNet has updated the Analytics for Twitter 2013 page and included a new download link.

• Anonymous
  December 16, 2013
  The download link takes me to http://spotfire.tibco.com/ ?

• Anonymous
  December 17, 2013
  Outdated download link removed. Added a reference to go to the TechNet page for an updated download link.

• Anonymous
  March 11, 2014
  can anyone please tell me how do you put in your credentialsregardsAj

• Anonymous
  March 13, 2014
  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?

• Anonymous
  March 18, 2014
  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.

• Anonymous
  March 21, 2014
  HelloWhere can i download analytic for Twitter 2013? this link sends me to spotfire

• Anonymous
  April 14, 2014
  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

• Anonymous
  June 13, 2014
  cannot install it!!!!!!! HELP!!!!!!

• Anonymous
  September 09, 2014
  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!!

• Anonymous
  November 03, 2014
  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?

• Anonymous
  November 27, 2014
  Is there still a possibility to download the file? Can't find it anywhere.

• Anonymous
  December 03, 2014
  looks very cool, but yes , the link is now broken and cannot download

• Anonymous
  February 01, 2015
  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?

• Anonymous
  June 22, 2015
  No use trying to download the software, it is useless since Twitter's modified their API last year.

• Anonymous
  September 12, 2015
  can you please post the download link

• Anonymous
  September 12, 2015
  can you please post a download link