How to Export Tweets from Twitter to Excel

You might want to export tweets from Twitter to Excel if:

  1. you wanted to include tweets as part of your administrative record for a project or
  2. if you wanted to track what folks were saying in general about a roadway or an area on Twitter (i.e. Twitter search for I-35, an interstate in Texas).

Quick & Dirty Method for Exporting Tweets from Twitter to Excel

Here's how I extracted the tweets sent during the American Planning Association's 2010 conference, which you can read here http://www.cubitplanning.com/blog/2010/04/tweets-from-apa-2010-conference/. I used a free program called the Archivist. The Archivist is a Windows application that “allows you to archive tweets for later data-mining and analysis for a given search. The Archivist allows you to start a search and will get as many results as it can on the initial search.  If you leave The Archivist open, it will update with the latest results every 10 minutes.  You can also close The Archivist and open it later. The Archivist will save the tweets and get all the tweets it can since that search. The Archivist will display a chart that shows the number of tweets per day for a given search, so that you can quickly assess traffic for a given search. For more comprehensive data analysis, The Archivist lets you export Tweets to Excel.”

  1. Download the Archivist here:  http://www.flotzam.com/archivist/
  2. Open the Archivist. In the search for box, enter your search term (I used #apa2010, the hashtag for the APA2010 conference). Click Get Latest.
  3. Bonus Points: While you're here, click on View and check out your Tweets as a Pie Chart and as a Line Chart. An example of a Line Chart of the #apa2010 tweets is below.
  4. Click on Export to Excel. Your tweets will be saved as a .txt file.
  5. Open the .txt file in Excel. Handy tip: if the data doesn't display nicely in columns in Excel, use the Text to Column feature in Excel to split the data out into columns.
Planners Tweeting at the APA 2010 Conference

Planners Tweeting at the APA 2010 Conference

But The Above Method Won't Work for an Administrative Record

Yes, you are correct! The above method worked perfectly for me when extracting tweets from the APA's 2010 conference; because I ran the search three days after the conference was over, and the conference only lasted a few days. I wasn’t worried about capturing tweets over a long period of time like the months or years it could take an EIS to be completed. Currently, Twitter stores your tweets for less than a month. The Twitter folks say that timeframe will be shrinking as the number of tweets per day continues to grow. If you want to include tweets about your project as part of the administrative record, you'll need to back them up.

How to Back Up Tweets to Include as Part of the Administrative Record

If you want to back up and save tweets to include as part of the Administrative Record, check out ReadWriteWeb's 10 Ways to Archive Your Tweets.

  • If you don't consider yourself to be tech savy, I'd suggest going with option #8. Twitterback up tools. I've got a BackupMyTweets account.
  • If you do consider yourself to be tech savy, I'd suggest #7. RSS Feeds and setting up a separate Google reader.

Let me know if you’ve got any questions about this process or if you’ve used any of these tools to successfully include tweets as part of your administrative record.

No TweetBacks yet. (Be the first to Tweet this post)

5 Responses to How to Export Tweets from Twitter to Excel

  1. Genis July 27, 2011 at 7:04 pm #

    awesome! thanks !

  2. Timolino July 29, 2012 at 7:33 am #

    You can use Timelinetweets.com to export a text file of your retweets or favorites. This file is importable in Excel.

  3. Oscar October 2, 2012 at 7:14 am #

    Export tweets to Access (MDB) , mysql and TXT

    http://www.palentino.es/blog/comienza-a-almacenar-en-tu-ordenador-los-tweets-personales-y-favoritos-en-access-mysql-y-txt/

Trackbacks/Pingbacks

  1. Export tweets from Twitter - May 12, 2010

    […] over at Cubit Planning just posted a very helpful set of instructions on how to export Tweets from Twitter.  This is great for planning organizations who may require an administrative record of comments as […]

  2. Welcome Seattle NTI class! « P2 Exchange - June 15, 2010

    […] of NEPA projects using social media. A couple of posts from the blog at cubitplanning.com provide tips on archiving tweets for an administrative record and examples of NEPA projects using Facebook. There will be much to […]

Powered by WordPress. Designed by WooThemes