How To Transform Email List Into Twitter Contacts

Filed under: Social Networking 

Here’s a quick outline of how to turn a client’s email list into twitter contacts.

It does work, but not always perfectly.  If you have a problem, let me know.

To turn an email list into Twitter contacts, you need:

  1. An email list in an Excel Spreadsheet format
  2. A temporary Gmail or Yahoo! email account
  3. Access to your Twitter account

When you get an email list, open it in Excel.  If you can’t open it in Excel, this procedure won’t work for you.

 

Save the file as a CSV (Comma Separated File) to a location where you can find it again.

Open your internet browser

In Gmail or Yahoo! mail, create a new account just for importing contacts.  If you import into your personal email, you’ll find getting rid of these temporary contacts to be difficult.  You will be able to use this account over and over to find Twitter users, so make sure you remember the password.

Once the account is created, go into the contacts panel and select Import.

Browse to the CSV file you saved from Excel and select it, then Import.

If all goes well, the email addresses will be imported into the account.

Now, switch to Twitter.com and login.

From the top menu, click on Find People.

Click on Find Friends.

Select the email provider from your temporary account.


Enter the login and password for the email account.  Twitter will search for email addresses of its users, and present you with a list of those that match.  Click on the Follow All button to have your  Twitter account follow everyone that has Twitter accounts.

Thanks to Michael Bay (@sherpambay) for the tip!

If you enjoyed this post, make sure you subscribe to my RSS feed!

Did You Miss These?

Comments

View Comments on How To Transform Email List Into Twitter Contacts

  1. Susie Blackmon on Wed, 10th Feb 2010 5:36 am

    2. RT @kdrewien: How To Transform Email List Into Twitter Contacts http://bit.ly/b5dXke

  2. James Ball on Wed, 10th Feb 2010 10:33 pm

    3. How To Transform Email List Into Twitter Contacts http://bit.ly/bdNjqm @smallbiztwit @kdrewien it is a nice post y'all!

  3. Mark Nielsen on Thu, 11th Feb 2010 11:51 am

    4. How To Transform Email List Into Twitter Contacts http://bit.ly/dgw2Dn

  4. Charity Hisle on Sun, 14th Feb 2010 4:27 pm

    5. RT @kdrewien: How To Transform Email List Into Twitter Contacts http://bit.ly/b5dXke (Great job @sherpambay)

  5. Michelle Porter on Thu, 18th Feb 2010 7:02 pm

    6. RT @kdrewien: How To Transform Email List Into Twitter Contacts http://bit.ly/b5dXke

I'm always open to your thoughts...





blog comments powered by Disqus