After Google introduced its own rival social network Google+, many of us wanted to import our Facebook friends to Google so that we can invite our Facebook friends to Google+ to have them and add them to circles. Since then, as Google plus was the direct competitor to Facebook, Facebook made it harder to get your friends to Google+ in bulk. Eventually they also blocked developer API to get access to friend list along with Email addresses even they are visible to you. Right after, Google also blocked Facebook from being able to export Google contacts to Facebook, and said to Facebook authority that, they won’t allow it unless Facebook does reciprocity. Though other than contacts, Facebook is allowing to sync Facebook birthdays and events with google calendar and other services.
Then folks made an easy workaround where, you first import your Facebook friend contacts to Yahoo and then export yahoo contacts to CSV file or directly to Google. Because Facebook is allowing yahoo users to export contacts. Though this trick was working for a while, Yahoo then started to prevent exporting contacts that are taken from Facebook ( they have collaboration with Facebook). Also, Yahoo doesn’t allow importing Facebook contacts neither to Twitter or LinkedIn. Even though you will find an option to import yahoo contacts in Gmail, Facebook imported yahoo contacts will never be imported to Google nor in CSV file.
Then the folks on web have been rushing here and there to find a way to do that and hopefully there’s still an easy way to accomplish this. Just because Yahoo lets you export Facebook contacts and just because Yahoo lets you print them all! Here we will use two key methods – Yahoo’s print contacts feature and a simple JavaScript. Don’t get worried if you aren’t an expert. Because the JavaScript is ready-made and all you have to do is just follow my guide. I have presented all this visually that is actually ‘noob proof‘. Please don’t be in hurry. Follow my all steps to avoid any error or problem.
Requirements
- An Yahoo Account.
- Google Chrome (JavaScript is enabled by default, you shouldn’t disable it).
- A simple text editor like notepad.
- An automated JavaScript that provided here.
- No technical knowledge (I presented all things in screenshot).
How to Export Facebook Friends/Contacts to CSV File
1. First, we need to import all Facebook contacts to our yahoo account. Log-in to mail.yahoo.com (if you are not going to use these contacts for Yahoo purpose, it’s better to create a new yahoo account to keep freshness everywhere). Click on Contacts icon from the top left-hand side.
2. In the contacts page, click Import Contacts button.
3. Then click on Import under Facebook label.
4. You will be presented a window where it may ask you for Facebook authentication. Proceed and it will start to import all contacts of your Facebook friends to your Yahoo mail account.
5. Soon after, the prompted window will show that “*** contacts successfully imported from Facebook” or like that. So now you have finished first step – all of your Facebook contacts are now possessed by your Yahoo account. Give Yahoo one or two minutes to let you view the contacts as it may take a while to present imported contacts.
6. Now go back to Contacts page in Yahoo mail and click on Facebook tab from left-hand side. Choose all contacts and click Print All under Actions drop-down menu.
7. Choose Basic view under layout and hit Print.
8. You should be presented with a prompted print-view in new tab (you must be using Chrome as I tested it in Chrome). Click Cancel to bring normal address book page.
9. Now that we have the normal print view page of the address-book. Now we need to save this as contacts.html file and reload it to chrome. To do that, go ahead.
10. While in this page, press F12 from your keyboard (or alternatively use Chrome’s inspect element from right-mouse-click menu). It will bring the sour code view.
11. Now we need to copy the whole source code. To do that, click on the first arrow of the code right before <html>. It should collapse the code in one line.
12. Right-click on the line and choose Edit as HTML.
13. Now select all by pressing Ctrl+A and copy the whole HTML code from the field.
14. Now on your desktop (or in any place on your hard drive) create a new text document (Mac and Linux users do it using your OS way).
15. Paste the copied code in this text file.
16. Now from toolbar, click File then Save As.
17. In Save As windows, its important to make all things as I did. Choose All Files (*.*) under Save as type, change the file extension from .txt to .html, Choose Unicode in encoding type. The click save. You can save it as contacts.html file for easier recognition.
18. Now we need to save a JavaScript code as bookmark in chrome browser. This JavaScript will be used to retrieve contacts from our saved contacts.html file and store them to a csv file so we can import it to Google or else other. For your information, the first JavaScript file I found, was authored by IAGDOTME (http://pastebin.com/H8ZDDdU6) which is no more working. Later many others (http://goo.gl/qndkem) corrected and forked many scripts. I have tested many scripts and the only script that is working for me right now is written by Ron whom I found as a commenter at iag.me, as the earlier script mentioned by iag.me is no more working.
So now, head to http://pastebin.com/zkYm6n06 (thanks to Ron) and copy the code.
19. Now, to properly save the JS code in chrome bookmark, go to a new tab and click on the star icon in Chrome’s address bar. The click Edit.
20. In the Bookmarklet editor, give it a name (I have given the name “Yahoo to CSV“), in URL section (most important part), remove any previous link and paste the JavaScript code you copied from pastebin. Select the folder “Bookmark Bar” for easier access later. Then click save.
20. Now go to desktop or the location on hard-drive where you saved contacts.html. Open the file contacts.html using chrome.
22. It should open the page normally as previous print-view(with the file location mentioning in address-bar).
23. Now while in this page, click on the bookmark “Yahoo to CSV“. At this time, the JavaScript will execute.
24. Right after you should see a field containing all contacts that was in contacts.html. Now press Ctrl+A using your keyboard, copy all these.
Note (Update): If you are not getting any output after clicking on the JavaScript on Chrome, Try Firefox. On Firefox, you won’t have to do the steps from 10-22. Here’s output on Firefox:
Firefox troubleshooting: If still you don’t get output on Firefox, try reloading the print page or include the steps from 10 -22 for Firefox too.
25. Now on your hard-drive/desktop create a new text document and then paste them in the new text document. The go to File then Save as.
26. In save as window, do as I did. Choose Encoding: Unicode, Save as type: All files (*.*), Change the file extension from txt to csv. Then click save.
27. Hurrah! You have done exporting your Facebook friends/contacts to csv file (backup of contacts). Here’s my imported contacts of Facebook friends.
Now you can use this CSV file to import Facebook contacts anywhere you wish including Google+, Gmail etc.
Note: These contacts only contain name and email addresses. Don’t expect to have phone numbers here.
How to import Facebook contacts to Google, Gmail, Google+, Twitter, LinkedIn, etc
Note: If you are able to import these contacts to Google, you can import them to all other social networks using their “Import from Gmail” feature. Or it can be done with the CSV file.
1. First we need to import the contacts to Google. To do that, navigate to google.com/contacts. Then click Import under More drop-down menu.
2. In import contacts window, click on Choose File. Then choose the contacts.csv file that you imported from Yahoo. Then click Import button.
3. Right after, within a few seconds you will be able to see newly imported contacts in a label named Imported with date at left-hand side under My contacts.
4. Hurrah! You have done all steps about importing Facebook friends to Google. Having contacts in Google contacts also means that you can also have them in Gmail and Google plus.
5. To invite these imported friends to Google+ and add them to circles, head to plus.google.com/people/contacts. You can also send them email my typing their name in Gmail’s to: address bar. This also helps you sync Facebook contacts on Android phone using Google account without Facebook app.
6. To follow Facebook friends in Twitter, head to twitter.com/who_to_follow/import and click Find Friends under Gmail category.
7. To Connect Facebook friends in LinkedIn, head to linkedin.com/fetch/importAndInviteEntry, choose Gmail and enter your Gmail address and then click Continue.
Note: This doesn’t sync Facebook contacts with Google, Google+ or any other. To keep it in sync, you need to repeat the process.
So now you can import both Facebook friends birthdays and email address to Google.
There is another method of Exporting Yahoo contacts to csv file using python made by Joincamp. This method is a lot harder compared to this process.
You should have done with what you have been looking for. Sorry to make the post very lengthy. I wanted to make sure every type of readers can do it smoothly without any confusion. So I used too much visually to make every step clear.
I have taken a lot of time to prepare and craft this post. So do let me know if it worked for you. Also let others know it by sharing the post if possible. If you have any other problem regarding this, post your comment.
View Comments (186)
Woow !! impressive work, I'll try it in a few days and hope it works fine :-)
I recently tried many methods but none gave me name + emails. Only names and not important informations (date of birth, fb account name...)
Hope you will succeed!
Yes it worked, but actually I used another method from point 9 of yours.
Because on my computer the copy/paste html was very slow. So I tried to simply select the displayed text on the print page and paste it into my text-editor.
So I got something like that (where "LF" is the "invisible character for a new line/carriage return):
"John Brown LF
LF
john@brown.com LF
LF
LF
LF
LF
James Brown LF
LF
james@brown.com LF
LF
LF
LF
LF
blablabla LF
LF
blabla@bla.com... and so on"
The exactly same scheme was constantly repeated > name + (2 x LF) + email + (5 x LF).
With a simple routine of search & replace I restored the list in 5mn.
If the JS didn't work in a few times, this method could be another alternative :-)
you are the real MVP!!!
No kidding :D
I don't have COPY AS HTML as an option when I right click...any thoughts? I have EDIT AS HTML and COPY CSS PATH....
CLick Edit. then press Ctrl+A and then Ctrl+C?
Updated the post to match with latest version of Chrome.
When we get to step 20, 21 The contacts names are there, but no email addresses? Any suggestions?
To clarify its when we run the javascript we get just usernames, no email. But now the javascript wont run...
I'm having the same issue!
Thank you guys for informing me! I have updated the post with working methods. Let me know if you find any problem. And sorry for my delay.
Hi - The import of contacts from Facebook to Yahoo (Step 4) has been running for 15 minutes, but I have not yet received the "Success!" notice. The status cursor is still circling, and the screen says, "Importing contacts from Facebook. You can continue using Mail now." You said this part should only take a couple of minutes. Should I be concerned that it is taking so long? No other downloads or uploads are happening. Thanks.
I also noticed it to take time sometimes. You can close the window and re-import.
Thanks for this. I am running Mac 10.10.1, so in step 14, I had pasted the html code into a TextEdit document, and saved it as .html. When I open the html file using Chrome (step 20), I do not get the Print view -- I see only html code. When I click the "Yahoo to CSV" tab that I created using the JavaScript, I get a box inside the browser window that is blank except for the words "Name, Email" in the upper left corner (see attached photo). I tried pasting the text in both the upper window and the lower window ("Raw paste data") of http://pastebin.com/zkYm6n06. I have tried three different times to make sure I am not copying it incorrectly. What am I doing wrong?
Can you use Firefox? On Firefox, you just click Print button on Yahoo. Then run the Javascript in the Printview page. Nothing complicated.
ALFR, the key to fixing this is going into your textedit preference and making sure you have "plain text" and "wrap to page" checked off. You can find this in TextEdit > Preferences > New Document. I also changed opening files under to open in Unicode UTF-8 -- TextEdit > Preferences > Open and Save. When saving, make sure you save as the unicode with a .html extension.
You are amazing. After changing textedit prefs it worked like a charm. Thanks you SO much good sir!!
I saved the script as a bookmark following the steps in Chrome and nothing happens when I click it - no white box, nothing. So I imported my Chrome bookmarks to Firefox, loaded the Contacts.html file into a new window, clicked the bookmark for Yahoo to CSV. Still nothing. Very recent versions of FF (downloaded today) and Chrome (3 months ago) running on Windows 7 PC.
Working on latest Firefox for me. Check out how to use Firefox method at step 24.
Try a fresh start. You are doing somewhere wrong!
Guys.... just use this website.
http://www.friendstogmail.com/about
This is not letting users export their friends' email addresses!
I was getting the same thing, in Firefox at least: "Read code.jquery.com". But I noticed that the webpage was still connecting (i.e. on the tab at the top the circle was spinning around and it said "Connecting..."). So I clicked the "x" at the end of the address bar to stop the load, and the JS result finally popped up.
Thanks for letting me know that it worked for you :)