Skip to content


Dumping A Spreadsheet Of Your Most Recent Tweets – TweetCSV.pl

Follow @znbeta To Sign up for Social Media Analytics Research Toolkit Private Beta!

I am releasing the Perl script I run to dump a spreadsheet of my most recent tweets, Contacts.pl, as an open source project, under the Artistic License. This is the same license that Perl uses. I’ve been using this script or variations of it since before the Haiti earthquake, so it’s pretty well tested.

The master repository is on Github at http://github.com/znmeb/TweetCSV. As far as I know, Contacts.pl will run on any modern version of Perl, but I’ve only tested it on Perl 5.10 on openSUSE Linux 11.2, and with ActiveState ActivePerl on Windows. If you have any trouble running it, please feel free to send me a tweet @znmeb.

How does it work? TweetCSV.pl makes Twitter API calls using the Perl Net::Twitter module from CPAN. You get the results in a comma-separated-value (CSV) file, which you can then open in a spreadsheet. Instructions for downloading and running the script are at http://github.com/znmeb/TweetCSV/blob/master/README.

Again, please feel free to send me a tweet if you need help getting this running. And special thanks to Marc Mims (@semifor), who has developed the Net::Twitter Perl module that interfaces with the Twitter API!

  • Twitter
  • Technorati Favorites
  • DZone
  • Share/Bookmark

Posted in Uncategorized.

Tagged with , , , , , , , , , , , , , , , , , , , , , .


9 Responses

Stay in touch with the conversation, subscribe to the RSS feed for comments on this post.

  1. znmeb says

    RT @DZone “Dumping A Spreadsheet Of Your Most Recent Tweets – TweetCSV.pl” http://borasky-research.net/2010/03/07/d...

    • GEOpdx says

      @znmeb Just remembered you asked me about the quality of #osm data in pdx. @geografa might know the answer.

  2. znmeb says

    Dumping A Spreadsheet Of Your Most Recent Tweets – TweetCSV.pl | Borasky Research Journal http://borasky-research.net/2010/03/07/d...

Continuing the Discussion

  1. Ed Borasky linked to this post on 2010/03/07

    RT @DZone "Dumping A Spreadsheet Of Your Most Recent Tweets – TweetCSV.pl" http://dzone.com/Ut5o

  2. Ed Borasky linked to this post on 2010/03/08

    Dumping A Spreadsheet Of Your Most Recent Tweets – TweetCSV.pl | Borasky Research Journal http://meb.tw/bkme3n

  3. Good Causes Portland linked to this post on 2010/03/08

    RT @znmeb: Dumping A Spreadsheet Of Your Most Recent Tweets – TweetCSV.pl | Borasky Research Journal http://meb.tw/bkme3n

  4. Blogging Inside linked to this post on 2010/03/31

    Dumping A Spreadsheet Of Your Most Recent Tweets – TweetCSV.pl http://bit.ly/dxzYoh

  5. Social Media Analytics Research Toolkit (SMART@znmeb) Is Moving Into Private Beta « Borasky Research Journal linked to this post on 2010/03/31

    [...] Tweets for a non-protected user to CSV file [...]



Borasky Research Journal is Digg proof thanks to caching by WP Super Cache