Tools · Twitter

3 Tools to Export Twitter Search Results to Excel

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.

Columns:

  • Username (of the Tweet author);
  • Date of the Tweet;
  • Time of the Tweet;
  • The status message itself

excel twitter 01 3 Tools to Export Twitter Search Results to Excel

Possible application: that “Time”column should be great to play with to build graphic and heat maps using built-in Excel tools.

2. Searchtastic

Searchtastic is a web-based Twitter search application that allows to export all the search results to Excel in just a second.

Columns:

  • 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
  • Tweet
  • In Reply To

excel twitter 02 3 Tools to Export Twitter Search Results to Excel

Possible application: the extended author information can be very helpful in your brand followers and advocates’ research.

3. TwapperKeeper

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 twitter 03 3 Tools to Export Twitter Search Results to Excel

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.

excel twitter 04 3 Tools to Export Twitter Search Results to Excel

Possible application: This tool is perfect for tracking and exporting huge Twitter search archives.

f8d69258525dec38624a29eb3d570d8c 64 3 Tools to Export Twitter Search Results to Excel
Ann Smarty is the blogger and community manager at Internet Marketing Ninjas. Ann's expertise in blogging and tools serve as a base for her writing, tutorials and her guest blogging project, MyBlogGuest.com.
f8d69258525dec38624a29eb3d570d8c 64 3 Tools to Export Twitter Search Results to Excel

You Might Also Like

Comments are closed.

6 thoughts on “3 Tools to Export Twitter Search Results to Excel

  1. Hi Guys,

    I am actually building new tool to do just those but a bit different, I will update you guys with a link once its completed if this is not perceived as a spam as I dont intend to :)

    Thanks