You probably know how much I love Excel for being an excellent data management tool. I have already done a guide on how to export Google search results to Excel. Today I am sharing another set of tools that will allow you to export Twitter search to Excel for brand management and keyword research.
Note: If you are geeky enough you can do without tools and read Twitter RSS feeds through Excel diy-style, but the following tools will just make your life easier:
1. The Archivist
The Archivist is a nice desktop application (Windows-only) that lets you run any Twitter search and create a self-updated permanent archive. The tool also provides an easy way to export the whole Archive to Excel.
- Username (of the Tweet author);
- Date of the Tweet;
- Time of the Tweet;
- The status message itself
Possible application: that “Time”column should be great to play with to build graphic and heat maps using built-in Excel tools.
Searchtastic is a web-based Twitter search application that allows to export all the search results to Excel in just a second.
- Login (author’s username);
- Name (author’s name)
- Homepage (author’ link)
- Location (author’s location)
- Followers (how many people follow the author)
- Following (how many people the author follows)
- Total Tweets (how many tweets the author has at the time of the update)
- Tweet Date
- In Reply To
Possible application: the extended author information can be very helpful in your brand followers and advocates’ research.
TwapperKeeper is another Twitter archiver (web-based) that allows Excel export. It requires Twitter authentication and takes some time for generating the file but the outcome is well worth it.
The tool allows to set the export options:
- Break the export into several files (fir huge archives);
- Use the preferred delimiter;
- Only export tweets within the specified time span:
Excel file columns:
(Note: you may need to use “Text to column” tool in Excel to break the file into columns using your specified delimiter):
- Update text,
- Recipient username;
- Tweet author;
- Tweet language;
- Date and time of the tweet.
Possible application: This tool is perfect for tracking and exporting huge Twitter search archives.
Subscribe to SEJ
Get our daily newsletter from SEJ's Founder Loren Baker about the latest news in the industry!