Since Facebook removed address book integration for your Facebook friends in 2017, it has been a challenge to for those of us who use Facebook for business to find a way to export your Facebook friends list and import them into your contacts. If you use Yahoo for our contacts, this is the guide for you.
NOTE: Yahoo does not allow importing contacts via a .csv so the workaround in the post will require you to create a temporary, free Google account as an intermediary step. You will then import those contacts to Yahoo directly from Google.
This post will give you the step-by-step instructions to export your full list of Facebook Friends and then import some or all of them into your Google Contacts
Exporting From Facebook
1. In your browser, go to Facebook.com and at the top right, click the down arrow:
2. In the dropdown list that appears, select Settings:
3. In the Settings menu, select “Your Facebook Information”:
4. In the next menu, go to the “Download Your Information” line and click “View”:
5. In the Download Your Information Menu, you will change the Format from HTML to JSON.
6. In that same menu, click on “Deselect All” and then check only the box next to “Friends”:
7. Now, click on “Create File”
8. As soon as you do so, Facebook will notify you that it’s processing the request:
9. As soon as the file is ready for download, you will get a notification within Facebook. If you don’t get it within 20-30 minutes, you can cancel and repeat steps 1-8. Click on the notification.
10. On the Download page, click on the download button. You will be asked to re-enter you password, and then this will trigger your data to download into a .zip file.
11. Open the .zip file. It will open a folder called “Friends”, with a selection of .json files inside.
13. Under Step One, select Choose File:
14. Navigate to the folder you just downloaded from Facebook (most likely in your “Downloads” folder, and select the friends.json file
15. You can Ignore Step 2. On Step 3, select “Convert JSON to CSV”:
16. After the conversion occurs, you’ll see your results populate below. Below the box, under “Save Your Result” you can give the file a custom name if you choose, and then click “Download Result”.
17. You will now have downloaded your data in a .csv file with three columns: the name, the date you became friends, and contact info. Most of your friends will not have contact info but a few will.
18. Click this link to download a Google Sheets template to migrate your data from Facebook to Google Contacts.
19. When you click, you will log in with your Google Account and then give you a button to make a personal copy of the template:
20. Once the Sheet opens, you will see two tabs. Confirm you are on the “IMPORT FACEBOOK CSV HERE” tab:
21. In the Sheet, click on File > Import
22. In the Import menu, click on “Upload” and then select the .csv file you created in step 16.
23. Once you select your file, select “Replace data at selected sell”, and then click “Import Data”.
24. Once your data imports into the tab, click and drag from cell A2 (the first name in your list) down to the very bottom, and then copy it (Edit > Copy, or use a keyboard shortcut).
25. Once you have copied the names, click on the “Google Contacts Upload Template Tab”
26. Paste the data into cell A2 in the “Google Contacts Upload Template” tab.
27. Repeat this process, copying the data starting in cell C2 of the “IMPORT FACEBOOK CSV HERE” tab and pasting into cell AE2 (all the way on the far right of the table) in the “Google Contacts Upload Template” tab. Note: most of your contacts will NOT have an email address included - this is normal.
28. If you would like, you can add a label for what type of email address it is in column AD of the “Google Contacts Upload Template” tab. This is optional - if you leave it blank Google will still be able to import it.
29. If you would like, you can now edit your list of friends to delete ones that you do not wish to import as contacts. Any you wish to remove, you will click to highlight the whole row, and then right click and Delete the Row:
30. Once you have finished pasting your data, from the “Google Contacts Upload Template” tab, go to File > Download As > Comma-separated values (.csv, current sheet):
33. On the left hand menu bar, select “Import”:
34. Click on Select File, and then choose the file you just downloaded from your Google Sheet (should be in your Downloads folder). After selecting the file, click import:
35. Google will import your Contacts and place them into a Label called “Imported on Month/Day. To the left of the first name in the list, if you hover your mouse a checkbox will appear.
36. Click to check the box next to the contact. Then above a new menu will appear with a drop down to Select All. Click “All”
37. Once you have selected all, click the button just to the right to add these contacts to your Google Contacts list:
38. Now, it’s time to handle any duplicates that were created in your contacts during this process. On the left side, click “Duplicates”.
NOTE: this likely will not apply because you were starting with a brand new Google account but we include it just in case.
39. Google will give you the option to review each duplicate one by one to make sure that they are indeed the same person:
For each accurate duplicate, click merge...if they are incorrect, click dismiss. Google does offer you an option to Merge all, but do this at your own risk as it can’t be undone.
40. Now you are ready to import these contacts from Google to Yahoo. Go to mail.yahoo.com and make sure you are logged into the account you wish to log into. On the right hand side, click the button to view your contacts:
41. Click on the ••• button, and then select “Import”:
42. Next to Gmail, select “Import”:
43. You will see a list of your Google accounts to select which one to import from. Choose your newly created temporary account:
44. Google will prompt you to grant access for Yahoo to import the contacts. Click “Allow”:
45. You will see a message that Yahoo is importing your contacts. This may take a few minutes. Once it completes, you will see the contacts appear in your Yahoo contacts list.
46. In our experience, Yahoo will auto-merge any Facebook friends who are already in your address book with the corresponding contact. However, if you notice duplicates you can resolve that here.
47. You’re all set! You have now imported your Facebook Friends into your Yahoo Contacts. Once these new contacts sync to your phone via your Yahoo account, you will see them appear in Contact Mapping.
48. Note: Contact Mapping will recognize these as “new contacts” and create a large number of unlogged interactions for you to create notes against. You can feel free to ignore those, the badge in the app will disappear within 24 hours.