How to Easily Export a Twitter Search to Excel

I was recently looking for a cheap and easy way to export a twitter hashtag to an Excel file. I wanted to be able to easily sort through all the users that had tweeted the hashtag and manipulate the data in Excel.

Below is the example. I wanted to have a nice Excel list of all the tweets with #messiahbusiness.

twitter search

This is the final product that was pretty easy to get to. Check out the method below or download the sample spreadsheet template.

Twitter ExcelMethod 1

  1. Do a simple select, copy, and past to Excel from your Twitter list (paste special as text only).
  2. Find where the @ character is used in the username
    1. =FIND(“@”,A3)
  3. Return all text after the twitter name (where B3 points to step 2 above and 20 is just a large number of characters to return so the entire twitter name is included)
    1. =MID(A3,B3,20)
  4. Find where the space is located after the twitter name (where C3 points to step 3 above)
    1. =FIND(” “,C3)
  5. Return the cleaned up username (where C3 points to step 3 and D3 points to step 4)
    1. =MID(C3,1,D3)

Method 2

  1. Method 1 can be condensed into one formula
    1. =MID(MID(A3,FIND(“@”,A3),20),1,FIND(” “,MID(A3,FIND(“@”,A3),20)))

Finishing Touches

  1. Make another formula to reference the tweet content to get everything on the same line
    1. =A5
  2. Copy the columns with the cleaned up username and tweet content and paste special as values to another set of columns (this keeps the values and gets rid of all the formulas and references).
  3. Filter the newly created two columns to only show the twitternames and tweet content.

That’s it, feel free to download the sample spreadsheet template and use it for yourself.

Advertisements

2 thoughts on “How to Easily Export a Twitter Search to Excel

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s