Dec 8th, 2011: Transition update
Twapper Keeper’s archiving is now available in HootSuite! As a result, we will be shutting down Twapper Keeper. Existing archives will be kept running until Jan 6, 2012, after which you will not be able to access your archives anymore.
Thanks for using TwapperKeeper – we look forward to seeing you at HootSuite.
Noooo I hear you cry. I know a lot of academic staff use did use the Twitter archiving service TwapperKeeper to archive tweets from events and conferences. Whilst often these archives are usually only used for quick post event summaries I think there is a lot more value to be gained from these resources. They are rich records of ideas and resources, shared within the instant but too often forgotten.
In projects iTitle and TAGSExplorer I’ve been exploring how these archives can be brought back to life so it is a great shame to see that TwapperKeeper will soon be no more. As staff consider new alternatives to keep archives of their events (you might want to consider my Google Spreadsheet solution, it’s free and your to control!) here’s a way to export your existing TwapperKeeper archives.
Inspired by LIBREAS.Library Grab your TwapperKeeper Archive before Shutdown! I’ve developed a Google Spreadsheet to export TwapperKeeper Archives. Here’s how:
- Open this Google Spreadsheet and click File > Make a copy (if this is greyed out you need to be logged in to Google first)
- Enter the archive name, type and the number of results you want to get in cells B9 to B11
- Click the button ‘Get the archive!’
[Note: this solution works for archives of a 15,000 tweets or less]
If you need more archives make more copies of the spreadsheet.
Please share so that we can free the tweet!
Update: Having read Brian Kelly’s post on the Responding to the Forthcoming Demise of TwapperKeeper it occurred to me that some coordination might be required. So if you use this template could you publish a copy (File > Share > Anyone who has the link can view and File > Publish to the web) of the spreadsheet and leave a note of where it is using this form which is embedded below (responses can be seen here):
Join the conversation
Martin, thanks for all your work on managing Tweets, it’s amazing how much you’ve accomplished from archiving to visualizations to backing up Twapperkeeper. I have no idea how I would manage my tweet archives without your tools.
Rescuing Twapperkeeper Archives Before They Vanish « OUseful.Info, the blog…
[…] of the few blogs in my feeds that just keeps on delivering…), Martin Hawksey has popped up a Twapperkeeper archive importer for Google Spreadsheets that will grab up to 15,000 tweets from a Twapperkeeper archive and store them in a Google […]
Responding to the Forthcoming Demise of TwapperKeeper « UK Web Focus
[…] Hawksey has published a post on his MASHe blog which describes how you can Free the tweets! Export TwapperKeeper archives using Google Spreadsheet. Martin’s post also links to a post entitled LIBREAS.Library Grab your TwapperKeeper […]
Free the tweets! Export TwapperKeeper archives using Google Spreadsheet – MASHe | Google Apps Script | Scoop.it
[…] Free the tweets! Export TwapperKeeper archives using Google Spreadsheet – MASHe […]
Twitter Archiving Revisited: Preparing for the demise of Twapperkeeper :: Jennifer M Jones
[…] Tony Hirst’s post on Rescuing Twitter Archives before they Vanish and using Martin Hawksey exporter tool that is build on a google spreadsheet. I’ve already used it to download the archives that […]
JISC Beginner's Guide to Digital Preservation » Blog Archive » 30 Seconds to Comply..
[…] MASHe: Free the tweets! Export TwapperKeeper archives using Google Spreadsheet […]
TwaperKeeper archives | nostuff.org
[…] Martin Hawksey has created a wonderful tool for archiving, ummm, archives before they are gone. The tool is actually a Google Spreadsheet and […]
Twapper Keeper: going, going….. (almost gone) | DMU MashedLibrary
[…] are the alternatives? Martin Hawskey discusses how to Export TwapperKeeper archives using Google Spreadsheet, while Brian Kelly has further advice on selecting and migrating […]
So Long, TwapperKeeper, and Thanks for All the Archives - ProfHacker - The Chronicle of Higher Education
[…] Hawksey has created a Google Spreadsheet that will surreptitiously import up to 15,000 tweets from a TwapperKeeper archive. Note that this […]
Goodbye Twapper Keeper « The Event Amplifier
[…] have used Martin Hawksey’s Google Spreadsheet tool, described in his post: Free the tweets! Export TwapperKeeper Archives Using Google Spreadsheet. I will also take a series of screenshots from Summarizr about each archive to serve as a visual […]
A Tool Chain for Plotting Twitter Archive Retweet Graphs – Py, R, Gephi « OUseful.Info, the blog…
[…] clunky route to a solution that @mhawksey has been working on a far more elegant expression of (eg Free the tweets! Export TwapperKeeper archives using Google Spreadsheet and Twitter: How to archive event hashtags and create an interactive visualization of the […]
Having some difficulty with this. Everything appears to go to plan, but after hitting the Get the Archive button for the second time should the spreadsheet become populated with the archive?
It processes 119 tweets for the example I started with, apparently, but they don’t show. The spreadsheet in question is https://docs.google.com/spreadsheet/ccc?key=0AoSX3DO54lxEdEViLVphMW5UOUh6Q3lKUnJwYkZsUnc&hl=en_GB#gid=13 if that helps
seems to be populating with something now
Thanks Martin, clearly I need to be patient. Will do all my archives and add to the list
Thanks for this! I got the spreadsheet to work and I get the pop up which says it is inserting the required number of rows. However I can’t find the results anywhere! Where are they supposed to appear? On the same spreadsheet? A different file?
Hi Gillian – they should appear on a sheet called Archive (Google can take a couple of seconds to catch up – refreshing the sheet might help things along)
Thanks – found it now!
Thanks for putting this together Martin. Really useful. Still a shame that Twapperkeeper is shutting up shop though!
Thanks Gary! It’s going to be missed by academic community. Makes you think JISC should put the open source version (yourTwapperkeeper) on a server behind federated access. Would that count as a OER Rapid Innovation project?
Didn’t JISC fund it at some point? How does that fit into Hootsuite buying it? Better not go there, hey?
On another note, I was just wondering if your Google spreadsheet/script pulls out the data using exactly the same url format that Twapperkeeper itself uses? I noticed the link next to “Test archive setting” is the same format. If it is, would I be able to enter a date restriction to pull out chunks of large archives – 1 of my archives contains 50,000+ tweets!
If it isn’t possible, no worries, I have a clunky Gary backup plan. 🙂
Thanks – Gary
Free (and rebuild) the tweets! Export TwapperKeeper archives using Google Refine – MASHe
[…] 3, 2012 at 3:42 pm in Google Refine and Twitter. 0 Comments By Martin HawkseyLast month I posted Free the tweets! Export TwapperKeeper archives using Google Spreadsheet, which was a response to the announcement that TwapperKeeper would be removing public access to […]
Noch wenige Stunden mit TwapperKeeper! « LIBREAS.Library Ideas
[…] Free the tweets! Export TwapperKeeper archives using Google Spreadsheet […]
I could not run this Google spreadsheet. Getting error message “could not parse text. (line 19)
TwapperKeeper is now closed, so data can no longer be obtained
British Association for Victorian Studies Annual Conference 2012 | jimmussell.com
[…] Using Martin Hawksey’s excellent Google Spreadsheet (following the instructions posted on his blog), I’ve exported the tweets into Google Docs and shared them […]
Now that Twapperkeeper is closed and I do not want to pay hootsuite to activate an archive. Do you know of any free alternatives?
many thanks! 🙂
yep – http://mashe.hawksey.info/2012/01/twitter-archive-tagsv3/ 😉
» Roger T. Whitson, Ph.D
[…] was lost when the API terms changed. There are other options, like the Archivist, and another from Martin Hawksky which uses Google Docs to archive. But both of these are essentially commercial […]
David F. Flanders
Love your work, using this for #OKFNau 🙂
Comments are closed.