How to import gmail or yahoo contacts to twitter

Stage 1:
Import facebook contacts to yahoomail!

http://www.ehow.com/how_6960454_import-facebook-friends-twitter.html

(rewriting the part about importing facebook contacts to yahoo mentioned in above link)
Import Email Addresses from Facebook to Yahoo! Mail

Step1
Create a yahoo account or log in to one if you already have one.

Step2
Log in to your Facebook account.

Step3
Type in “Address.yahoo.com” in your browser’s address bar and click “Enter.”

Step4
Click the Facebook icon on the next page.

Step5
Click “OK” in the pop-up window that reads, “Do you want to share your contacts with Yahoo?”

Step6
Click “Done” on the page that tells you how many email addresses you have successfully imported.

Stage 2: Importing from yahoo to twitter!

Step 1: Sign in Yahoo. Click on Contacts on the left Tab. Select Tools List Box-> Export.Now click Yahoo! CSV: Export Now

Step 2: Open the file with notepad and save it as a Text File.

Step 3: Open the file in Notepad. Perform Replace of “”, with space. Again perform replace of “” with space. Now you should see records of each contact on a single line with First Name, Last Name and email address.

Step 4: Delete the first line which says “First Name”, “Last Name”, etc.

Step 5: Now browse the text file and cut the records which dont have @email.com after the email id. For example “myyahooid@yahoo.com” will appear as only “myyahooid” in the text file. Cut and paste these records in a different file.

Step 6: Check for Irregularities in the file like blank line, etc. It should be very uniformly distrubuted. This is an important step.

For example each line should be like this

“firstname”,”lastname”,”emailid@gmail.com”,
Step 7: open Microsoft Excel Sheet. Select Date Tab -> get external data FROM TEXT and select the above text file.

Step 8: Press Next on Step 1 of Wizard. In Step 2 check box saying Comma . Say next and finish. Press OK.

Step 9: Delete the first two columns of first name and last name

Step 10: Copy the whole column of email address and paste in a notepad file. Now you should simply have a list of email address. Next we need to separate the ids with a comma.

Step 11: Find Replace “.com” with “.com,” (without the double quotes)

Step 12: Additionally find replace any other domains like “.in” with “.in,”

Step 13: In Twitter goto Find People-> Invite by email. And paste the email addresses(not more than 50 at a time) and say invite.

Now only thing remaining is the list of yahoo ids. I think you can figure them out yourself! 🙂

Have a nice day!

Leave a comment