As the #edchat archivist, the one question I receive the most is “How do you archive all of those tweets?” The answer is actually pretty simple, I use an application called The Archivist and Google Drive.
The Archivist is an extremely easy to use application with one caveat, it is PC only. Unfortunately, if you’re a Mac user, there does not appear to be a desktop-based application that does something similar. After installing the app, run it and type in your search term. The Archivist will pull down the last 1500 tweets for your search term, then continue to pull down new tweets until you close the program. For #edchat, I also use the export functionality to export all of those tweets to a .csv file which I open up in Microsoft Excel to clean it up a bit. The file is saved as a .xls file and is then uploaded to Google Drive.
After uploading and converting the .xls file to Google Drive, it needs to be published to the web in order to get the embed code which is used to embed the spreadsheet in the Edchat wiki located at http://edchat.pbworks.com. To do this, click on File, select Publish to the Web.
In the “Get a link to the published data” section, select “HTML to embed in a page.” Copy this embed code. This is the code that allows the Google Docs Spreadsheet to be visible on any blog, website, wiki, or anything you can embed anything in to. This embed code can then be pasted into anything.
That’s it! Using these steps you can archive any twitter search. Your search does not need to be limited to hashtags. Your search can be anything. Imagine the possibilities for use in the classroom. What better way to give your kids real-time information on events and happening from around the world.
Google Drive Image source: http://www1.pcmag.com/media/images/340225-google-drive.jpg?thumb=