How to Transfer Your Facebook Friends to Twitter & Other Networks [Bookmarklet]


One of the most popular articles on my blog has been “How to Migrate your Facebook Friends to Twitter, Google+ and LinkedIn“. It showed a way to export your Facebook friends to other social networks such as Twitter, Google+, LinkedIn and Pinterest.

Unfortunately, as I mentioned in my previous post, Facebook doesn’t have a good history of making it easy for you to export your data. Yes, Facebook does had an export data tool for a while now, but it doesn’t allow you to get your hands on your friends’ email addresses, even if they are visible to you. Your and everyone else’s data is incredibly precious to Facebook. It’s what makes Facebook so valuable, because with it they can make a huge amount of money from targeted advertising.

The Problems

In my article, I highlighted a way to export your friends to Twitter by first exporting them to Yahoo! Mail, before then exporting them to Twitter. Although it was a bit of a pain, it worked brilliantly for many months, until it stopped without warning.

Firstly there were issues with the Yahoo! tool to migrate your Facebook contacts into Yahoo! Mail. Apparently, Yahoo! were aware of this as stated in this help article, but certainly from my experience, it does seem to work now.

Secondly, not all contacts were being imported from Yahoo! to Twitter. My post was awash with comments saying that it didn’t work. After many weeks trying to figure out what the problem was, Yahoo released a “help” article on the subject- Why can’t I export my Facebook contacts?. So now, Yahoo tags each contact that it has imported from Facebook so that you are then not able to export it. How ridiculous! Call me cynical, but I expect this has happened due to Facebook breathing down their neck.

A Solution?

So, what do we do now? How do we export our friends from Facebook to Twitter, or indeed any other social network? Well, all is not lost- I have found a way for you! Unfortunately it does still involve Yahoo! Mail, and is more involved. However, I have gone out my way to make this as simple as possible for you!

How to Export Your Facebook Friends to a CSV file

Like in my previous article, it is important to be aware that this only exports your Facebook personal profile friends- not your Facebook page’s friends. I’m hoping that Adam Loving will update his Facebook Page Hack for this! (Any update on this, Adam?!)

Also, it will only export friends who have shared their email address with you, and they will obviously need to have a Twitter account!

Please note, the bookmarklet only works in Google Chrome. You can try this in other browsers but you may encounter problems.

STEP 1: Get a Yahoo! Mail Account (Or Sign in if you already have one)

Head on down to Yahoo! Mail and create an account or sign in if you’ve already got an account.

STEP 2: Import Your Facebook Contacts

Sometimes the Yahoo! Mail Facebook importer can be a bit temperamental. If it fails, try it again. In my experience it does work, but you have to be a bit patient.

a) Click on the Contacts tab at the top, and then click the button “import contacts” on the right. (If you’ve just signed up for a new Yahoo! Mail account, you’ll get this option as soon as you create the account.)

Yahoo Mail Importerb) Click on the Facebook icon to proceed. (if you have an Adblocker on your browser you may need to disable it to see the Facebook icon)

Facebook permissionsc) You’ll get a Facebook permissions box. Click OK to say that you are happy for your contacts information to be shared with Yahoo!.

Getting stuff from Facebookd) Yahoo! Mail will then try to retrieve your Facebook friends’ contact information from Facebook.

Facebook Export done e) Congratulations, your Facebook contacts have been imported! Click the Done button.

Step 3: Convert your Facebook Contacts to a CSV File

So now we have all our friends contacts in Yahoo! Mail, but they are all tagged with that nasty Facebook tag. We could edit each contact individually to remove the tag, but if you have a lot of contacts, that is going to take a LONG time.

With the help of a rather wonderful StackExchange user, biziclop, the process has been made much easier- with the help of a bookmarklet. A bookmarklet is a piece of javascript code that you can drag on to your browser’s bookmark bar. You can run the code on any web page by clicking the bookmarklet.

This special Bookmarklet converts all your Yahoo contacts into a CSV file. A CSV file is a very versatile file format and can be opened in Excel, Outlook, Apple Mail, Thunderbird and many webmail services. Just in case you didn’t know (and care), CSV stands for comma separated values- because, each value in the file is, well, separated by commas…!

The Bookmarklet.

First of all, drag the following button to your browser’s bookmark bar:

Yahoo to CSV

Make sure you are doing this in Google Chrome for PC. If you are having problems, then it’s probably because your browser hasn’t stored the bookmarklet properly. To do this, copy the contents of this javascript file to your clipboard. Then edit the bookmarklet, delete anything in the URL field paste the code into the field. Your bookmarklet should work. Please let me know how you get on in the comments below. Thanks to Alex Hall in the comments for help here.

Once you’ve done this, you’ll need to go to Print View in Yahoo! Mail

Facebook Print All a) Select Print All from the actions button in Yahoo Contacts.

Facebook printing preferences b) Select the Facebook category and Basic View.

c) Once you’ve got the screen of all your contacts, click the Yahoo to CSV bookmarklet in your browser. You’ll see a window pop up with all your contacts highlighted. Copy this and paste it into your favourite text editor (for example Notepad). Save this file as contacts.csv. You may need to change “save as type” to “all files” so you can set the correct file extension.

Save as CSV

So now, you have all your Facebook’s contacts as a CSV file! This will enable you to import them into many other social networks such as Google+ and Twitter.

Unfortunately, you can’t just upload your CSV file into Twitter, you have to import them into either Yahoo! Mail (again!) or I’d recommend Google Mail.

Thanks again to biziclop who made this hack possible. Please do leave a comment on the StackExchange page.

Import to Twitter

So now that you have your glorious CSV file, how do you get the thing into Twitter? These things are never easy, for reasons that escape me and many others, Twitter doesn’t allow a way for you to upload a CSV file. This is just annoying, because it assumes we all use a webmail service such as Yahoo! or GMail for our contacts. Although I do have a Yahoo and GMail account, I use Thunderbird and Outlook for my email and contacts.

The easiest way for you to import your CSV file into Twitter (and so your Facebook friends) is to import your CSV file into either Yahoo! Mail or GMail. I know this sounds silly, since we’ve only just exported them from a webmail service, but this is very easy to do. I’m going to go through the steps for GMail since that is the service I recommend.

  1. Log into GMail and go to your contacts (click on the “GMail” dropdown on the left column and select contacts)
  2. google-contactsClick on the “More” dropdown and then click on “Import”
  3. Import Contacts GMailSelect the CSV file you saved before and upload by clicking the import button. Your contacts will be imported straight away.
  4. Twitter Importer Now you need to head on down to the Twitter importer. You can find this by clicking on the previous link, or by clicking on Discover then Find Friends on the left navigation. Click on the Search Contacts button by the Yahoo! Mail option.
  5. Yahoo! Mail PermissionsOnce the Yahoo! Mail permissions window loads, click on the Agree button. This gives Twitter permission to import your Yahoo! Mail contacts.
  6. Twitter Import CompleteImport Complete! Congratulations, you have successfully migrated your Facebook friends to Twitter.

Adding your Facebook Friends to Google+

google+Another cool thing you can do is migrate your Facebook friends to Google+. It works in a very similar way. Firstly, import your Facebook friends into Yahoo! Mail as shown above, then go to your circles page on Google+ and link your Yahoo! contacts. You can then drag all your FB friends to a circle of your choice. The advantage here is that your Facebook contacts don’t have to be Google+ users. You’ll have the option of sending posts to their email address instead.

Adding your Facebook Friends to LinkedIn


LinkedIn make it easy for you, there is an app for that. Check out the LinkedIn app to import your Facebook friends to LinkedIn.

Adding your Facebook Friends to Pinterest

pinterest contact importAs Pinterest naturally connects to your Facebook friends, it’s very easy to do this. Just make sure you connect your Facebook account with Pinterest and then click on “Find Friends from Facebook”. Obviously none of my Facebook friends are Pinterest users though, so this wasn’t very helpful to me!

Final Word

Well, I hope that helps. I know it is far more complicated than it should be, but at least you should only ever have to do this once. Let me know what you think in the comments!


Want in on the latest tools, tips, hacks & techniques?

Get the Seriously Social Newsletter for Free!

You will receive an email no more than once a week.


About Ian Anderson Gray

Ian is a speaker, coach, social media consultant, web developer & Partner of Select Performers. In real life he is a husband, dad and geek and is rather partial to tea, coffee & Indian cooking. Find out more



The Seriously Social Community

What do you think? Join the fun & Let me know below...

Leave a Reply

91 Comments on "How to Transfer Your Facebook Friends to Twitter & Other Networks [Bookmarklet]"

avatar

Sort by:   newest | oldest | most voted
Nathan
Guest
5 months 28 days ago

For anyone having problems converting the PRINT page to a CSV, use this: http://tabgraf.com/demo/import-contacts/friend-list-to-csv/index.php

You simply copy and paste the data you get when you try to print and it automatically sorts it for you. You then copy what you get into a text file and save it as a CSV and import into your program of choice. Just did it and was having problems with all of the other solutions and this was fast and painless.

Asia
Guest
1 month 2 days ago

Great! Thanks! Worked for me.

Darpan Das
Member
Darpan Das
6 months 11 days ago

I have got a very simple trick to transfer the Facebook contacts into the Twitter account… It worked for me… Click on my Twitter link below… Reply if it works for you & also don’t forget to Retweet or Like my Tweet…
https://mobile.twitter.com/DarpanDas/status/710904773248217088

RUI
Guest
RUI
6 months 15 days ago

I’m trying to import contacts from facebook. I connect with my facebook page, after that the page is redirect do Yahoo again without importing the contacts. Anyone have a solution?

Anne
Guest
Anne
1 year 4 months ago

There is a much easier way that skips the whole CSV step: Important Facebook contacts into Yahoo, import Yahoo contacts into Twitter via Twitter’s “find your friends” feature.

platy
Member
platy
10 months 11 days ago

it doesn’t work like that… at least not for me

Usman
Guest
Usman
1 year 4 months ago

The script is not working now, chrome blocks it and unblocking it makes the page blank. Nor is there an option of choosing facebook only, but we can print ALL the contacts.
Now the SOLUTION: When you are in the print page, select all the contacts roughly with the mouse and paste it in excel. All names and emails will be mixed in a column (Column A). Now, go to next column and type =IF(ISNUMBER(SEARCH(“@”,A2)), A2, “”)
This will show only email addresses in the new column. Now copy the column in an online text editor and replace newline with a comma, and then paste the result in a text file and save that file as a csv. That file can now be imported in LinkedIn 🙂

Chris McCall
Guest
Chris McCall
1 year 5 months ago

No facebook option comes up on the print step

Steven J Fromm & Associates
Guest
1 year 5 months ago

What about the other way around? Taking for instance your Twitter friends and getting them to be part of your Facebook likes?

Jaber
Guest
Jaber
1 year 10 months ago

Hi, I didn’t see anything coming out when I click on the bookmark-let. If I save the contacts as html, and open the html page and run your script again, this happens:

adamloving
Guest
adamloving
1 year 10 months ago

Great detailed post! Thanks for mentioning me. Sadly, I haven’t seen any updates from FB on exporting fans, or updated my script in a long time.

Shira
Guest
Shira
1 year 10 months ago

I imported my Facebook contacts to my Yahoo! mail account following the instructions above. Then I went to Twitter, #Discover, Find Friends, import contacts from Yahoo!. That was it.

I didn’t need to make the .csv file or sign in to any additional accounts. I didn’t even need to sign in to Yahoo! through Twitter, since I was logged in on a different tab. My Twitter had not previously been linked with my Yahoo! account. Rather, Twitter thinks my email address is @aol.

Ron
Guest
Ron
2 years 7 months ago

I found a workaround for the security issue and modified the JavaScript code so that it works with the new printable format. First, you will need to save the printable Yahoo contacts page to your local disk. Next, you will need to update the bookmarklet using the script that I have posted here: http://pastebin.com/zkYm6n06. To use this new script, you will need to navigate to the HTML file on the disk containing the Yahoo contacts.

A fan
Guest
A fan
2 years 5 months ago

^^This rocks!! Thank you so much for the repair!!

trackback

[…] How to Transfer Your Facebook Contacts to Twitter […]

Eric
Guest
Eric
2 years 7 months ago

Bookmarklet doesn’t work.

Xerone
Guest
Xerone
2 years 8 months ago

Hi. I have the same problem. When I click the bookmark there is nothing happening. I tried the bookmark on other tabs and it works. I’m not a IT tech guy but i think it has to do with the address bar? When i click print, the address bar shows about:blank. Might this be the reason?

rareohs
Guest
rareohs
2 years 8 months ago

doesn’t work for me either. Mac, chrome. I copied and pasted all the code from http://pastebin.com/raw.php?i=H8ZDDdU6 into the “Yahoo to CSV” bookmarklet, and when I click it, still, nothing happens…

Fred
Guest
Fred
2 years 8 months ago

Ian can you confirm that the html formatting has changed or is different than what the script is trying to parse? Yahoo no longer has “Display for Printing” when selecting Print All. There is just a Print button that will open Chrome’s print window, if you cancel the printing you can see the list of contacts, but it is not html, the script does not open any window if run then. I use Chrome Developer tools to “inspect elements”, manually copy the html, copy it to a text editor and save as .html file. If I then open that html file in Chrome and run the script, it does open a window but there are no names or emails listed. I think yahoo changed the formatting of the html produced so the script is failing to parse it (the script is looking for the old format). Ian can you confirm that the html formatting has changed or is different than what the script is trying to parse?

coreyg
Guest
coreyg
2 years 8 months ago

When I go to print them, there is no facebook catagory… though there is one in my email.

tidalsearch
Guest
tidalsearch
2 years 9 months ago

i can’t see a Facebook category when I go to the Print All feature in yahoo contacts. can you help?

Cristofer
Guest
Cristofer
2 years 9 months ago

oh and i think u mistakenly put “click on export” when ur asking people to *import* contacts from CSV to gmail

Cristofer
Guest
Cristofer
2 years 9 months ago

hope this helps people having issues. If people are having trouble with the bookmarklet thingy, they can also make a CSV file from FB much more easily via this method, although this fails to say that if u dont have an APPLE computer, u have to paste into a NOTEPAD and save as CSV, as the microsoft excel doesnt have the comma pasting thing:
http://www.youtube.com/watch?v=ioXDUPNtHjc

Khotso Shomang
Guest
2 years 2 months ago

This is great, thanks Cristofer

Amber
Guest
Amber
2 years 11 months ago

thanks. it worked.

Ryan Anderson
Guest
3 years 1 month ago

This post is fantastic!! I’m using firefox so I did have to add in the javascript manually but it was simple enough. I have been trying to import my FB contacts for weeks and having no luck at all. I randomly came to this post and 5 min later problem solved. Thank you so much!!

Jelena Baric
Guest
Jelena Baric
3 years 1 month ago

It worked for me, thanks so much!

Tracy Rasmussen Enos
Guest
Tracy Rasmussen Enos
3 years 3 months ago

I may be a little late asking this, but now Yahoo exports an empty CSV file. I have tried both Chrome and Firefox. Are they no longer allowing this feature?

adamloving
Guest
adamloving
3 years 9 months ago

Stil no update on the Facebook fan export front, I’m afraid. I *have* been working on exporting people that comment. http://linksy.me/social-media-marketing

Zohra
Guest
Zohra
3 years 9 months ago

Thank you for this article, super helpful!

Mark
Guest
Mark
3 years 10 months ago

—Incase someone didnt really understand what to do after the cvs file part—
after you get your cvs saved full of contacts most likely in a notepad on your desktop..you have to import it back to the yahoo account..to do that you need to delete all the contacts from the yahoo account..then import the cvs file using the yahoo account..finally all should be fine using twitter and the yahoo account! Hope this helped

Alex Hall
Guest
Alex Hall
3 years 10 months ago
Ian, This bookmarklet can work in Firefox with a few more steps. If you right-click the bookmarklet in Firefox (after you have dragged it to the bookmark toolbar), click “properties”, then select and delete all the text in the “Location” field, and paste in the javascript code which you’ve shared at this pastebin link– http://pastebin.com/raw.php?i=H8ZDDdU6 — and click “save”, then follow all the other steps you give here to ready a printout screen of the contacts, and click the bookmarlet, *it works!* It pops up a window of csv-formatted text, and you can select all the text, copy it, and paste into a text file and save it on your computer. It seems to me that somehow the bookmarklet code can become mangled when dragged to a toolbar (I found that it was mangled in Chrome, and had to follow this procedure in Chrome (per your suggestions in comments) to get the bookmarklet working, which led me to wonder if that’s what’s happening in Firefox, which I found it is, which led to this fix). I don’t know how that’s getting mangled. I suggest you update the post with a note about the possibility the bookmarklet code can be mangled,… Read more »
Aaron James
Guest
3 years 10 months ago

I got it to work on Mac OSX Google Chrome by copy & pasting the Java script to the bookmarklet. It does not save correctly on Mac. You must edit the bookmarklet, copy the new script into the URL field first. Then make sure you print using the Basic View. Then and only then, when you click on the bookmarklet, it will work. Works like a charm though.

Tara Pattenden
Guest
Tara Pattenden
1 year 11 months ago

Hi I can’t seem to drag the bookmarklet to my bookmark bar. I’m using chrome on os x. any help would be great
thanks

Alice Debois-Frogé
Guest
3 years 11 months ago

Hello there! Thanks for such an helpful post. However, like other Mac users, nothing happens when I click on the bookmarklet, even though I am using Chrome. Any ideas on how to make it work? Or is using a PC the way to go? Please advise! Thank you!

Cathryn
Guest
Cathryn
4 years 18 days ago

Thank you for taking the time to write this post. I’m also having issues with the bookmarklet. I have imported my contacts into Yahoo and have followed the instructions to the Print View in Basic Mode, but when I click on the bookmarklet there is no popup window. I’ve attemped using both Safari and Firefox. Is there something else I can try?

mark
Guest
mark
3 years 10 months ago

you have to manually save the url in the bookmark

r0cb0y
Guest
r0cb0y
4 years 1 month ago

whenever i would click on bookmarklet nothing happens? why is that?

r0cb0y
Guest
r0cb0y
4 years 1 month ago

i mean on yahoo to csv on my bookmarks bar

trackback
4 years 2 months ago

Why won’t Yahoo mail export contacts to .csv file?…

Well it’s an open source python script. I found this other method here http://iag.me/socialmedia/how-to-transfer-your-facebook-friends-to-twitter-and-other-networks-an-update/. That may be easier. You can’t really trust an exe other than I promise it…

Rachel Bonness
Guest
Rachel Bonness
4 years 2 months ago

I exported my contacts from yahoo to a CSV file and put them into my gmail account and I can see my contacts in there but when I go onto Twitter and try to add them it says no one found in my address book for Yahoo and for Gmail, Arghhhh!

Jonathan Camp
Guest
Jonathan Camp
4 years 2 months ago

It’s funny because I was solving this same issue at the same time as you and I didn’t even know it. I wrote a python script on July 3rd, and I think your scriptlet looks like it was written the same day. Anyway, it’s not as clean as a scriptlet, but if you want to check it out, I wrote a blog post on this too. 
http://campkludge.org/?q=yahoocontactexport.

Glad you were able to figure out the same thing.

ross smith
Guest
3 years 11 months ago

thanks Jonathan Camp Ilike a few in these comments have been having trouble with the bookmarklet on chrome in windows 7 but your script did it for me. thanks for the post Ian Anderson Gray I am sure it has been working for you and others. 5 more being followed on twitter now. One step closer to maybe shutting down my facebook.

Shaun O'Reilly
Guest
Shaun O'Reilly
4 years 2 months ago

For those web developers out there, all you have to do is compose a new message, click on the “to:” button, and get the html of the UL element listing all those contacts (make sure you scroll to the bottom), and use something like Google Chrome tool to copy the html of the UL element. 

Then use some jQuery like in this example, to generate a list:http://jsfiddle.net/webwarrior/ZP5MA/1/ 

You could replace the html in this example with your own list, to test it.

Sandra Martins
Guest
Sandra Martins
1 year 11 months ago

I’m not being able to select them, they just select the contact, do you know how I can do that??

trackback
4 years 2 months ago

How to find my Facebook friends on Twitter?…

Yahoo recently started tagging contacts that were imported from Facebook so that you couldn’t export them. Luckily you can convert Yahoo contacts to a CSV file using another method- http://iag.me/socialmedia/how-to-transfer-your-facebook-friends-to-tw

trackback
4 years 2 months ago

Why won’t Yahoo mail export contacts to .csv file?…

As others have mentioned, Yahoo tag each contact that has been imported from Facebook so that you can’t export it. You could manually edit each contact, but with the help of a bookmarklet it’s very easy to convert Yahoo contacts including Facebook on…

wpDiscuz