Free the tweets! Export TwapperKeeper archives using Google Spreadsheet

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:

  1. Open this Google Spreadsheet and click File > Make a copy (if this is greyed out you need to be logged in to Google first)
  2. Enter the archive name, type and the number of results you want to get in cells B9 to B11
  3. 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):

Responses:

29 thoughts on “Free the tweets! Export TwapperKeeper archives using Google Spreadsheet

  1. Deborah

    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.

    Thank you.

  2. Pingback:

    Rescuing Twapperkeeper Archives Before They Vanish « OUseful.Info, the blog…

  3. Pingback:

    Responding to the Forthcoming Demise of TwapperKeeper « UK Web Focus

  4. Pingback:

    Free the tweets! Export TwapperKeeper archives using Google Spreadsheet – MASHe | Google Apps Script | Scoop.it

  5. Pingback:

    Twitter Archiving Revisited: Preparing for the demise of Twapperkeeper :: Jennifer M Jones

  6. Pingback:

    JISC Beginner's Guide to Digital Preservation » Blog Archive » 30 Seconds to Comply..

  7. Pingback:

    TwaperKeeper archives | nostuff.org

  8. Pingback:

    Twapper Keeper: going, going….. (almost gone) | DMU MashedLibrary

  9. Pingback:

    So Long, TwapperKeeper, and Thanks for All the Archives - ProfHacker - The Chronicle of Higher Education

  10. Pingback:

    Goodbye Twapper Keeper « The Event Amplifier

  11. Pingback:

    A Tool Chain for Plotting Twitter Archive Retweet Graphs – Py, R, Gephi « OUseful.Info, the blog…

  12. Gillian

    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?

    1. Martin Hawksey

      Post author

      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)

  13. Gary Green

    Thanks for putting this together Martin. Really useful. Still a shame that Twapperkeeper is shutting up shop though!

    Gary

    1. Martin Hawksey

      Post author

      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?

      1. Gary Green

        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

  14. Pingback:

    Free (and rebuild) the tweets! Export TwapperKeeper archives using Google Refine – MASHe

  15. Pingback:

    Noch wenige Stunden mit TwapperKeeper! « LIBREAS.Library Ideas

  16. Sarath

    Hi Martin,

    I could not run this Google spreadsheet. Getting error message “could not parse text. (line 19)

    Please advise.

    Thanks,
    Sarath

  17. Pingback:

    British Association for Victorian Studies Annual Conference 2012 | jimmussell.com

  18. Melissa

    Hi Martin,
    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! :)

  19. Pingback:

    » Roger T. Whitson, Ph.D

Comments are closed.