Download Facebook Friends Email List
To export Facebook email addresses to Excel, CSV or vCard (.vcf) format use this trick.
FB has option to backup your complete profile data. But does not provide a direct method to export only contacts (email addresses, phone numbers etc.,). To do this, we have to follow one of these two indirect methods.
- Using Yahoo Mail.
- Using Sync phone contacts.
In this article we are going to see only on how to export Facebook contacts list with Yahoo email. The other method is explained in a separate article.
Export Facebook Contacts List to Excel using Yahoo Mail
You have to go through 2 steps to complete this process. First step is to import contacts from FB to your Yahoo Account using these steps.
(a) Sync Facebook Contacts with Yahoo
- Login to your Yahoo mail account. (If you don’t have one, sign up for new id & login)
- Click the Contacts section.
- Select “Import Contacts” or “Facebook” on left side panel.
- Choose “Import” under Facebook import section.
- Approve the Popup Authorization request to get connected to your FB account.
Now, all the contacts from Facebook account will be synched with Yahoo contacts. This option will auto enable the daily update. I.e., Yahoo will update the new contacts added to your FB to its contacts. There is no need to schedule sync Facebook contacts manually.
Also it will download Facebook email addresses of your friends to its contacts page. Now, let see how to export Yahoo contacts to Excel or .vcf vCard format.
(b) Export Facebook Email Addresses in Yahoo to Excel
- Choose ‘Facebook’ on the left side panel.
- Click on “Actions” & “Export”.
- Select “Yahoo CSV” format to export.
- Click Ok and initiate contacts export process.
The contacts will be saved in ‘Yahoo_contacts.csv” in the path you have chosen during download. Browse to the download path and open the exported contact csv file in Excel. You can see all your FB contacts are exported to CSV along with their Name, Email Id, Messenger ID etc.,
This is also a very good trick to download Facebook Friends email list into Excel. It is sometimes useful to send Marketing & promotional emails.
Convert FB Contacts list to vCard Format
If not csv, you can choose to export it to vCard .vcf file format. This format can be directly imported to your smartphone (Android, iPhone , Windows) and other email clients like MS Outlook.
Using the same steps, we can also download contacts from Gmail, Outlook.com. As an additional feature, Yahoo mail & Gmail both have the option now to remove duplicate contact details. So, we can even use this feature instead of downloading & using a separate app to do this task.
Export Facebook Email Addresses to Excel