Download Facebook Email Addresses to Excel
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 Facebook contacts to csv (email addresses, phone numbers etc.,). To do this, we have to follow one of these two indirect methods.
- Yahoo mail Facebook contacts.
- Sync phone contacts – export Facebook contacts to Gmail.
In this article we are going to see only on how to export email addresses from Facebook to Yahoo email. The other method is explained in a separate article.
Export Facebook Contacts To Excel using Yahoo Mail
You have to go through 2 steps to complete this process. First step is to export email addresses from Facebook to your Yahoo Account using these steps.
(a) Sync Yahoo Mail Facebook Contacts
- 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 Contacts to CSV from Yahoo mail
- 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.
Facebook Export 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.
This is how we can Export Facebook contacts to Gmail, Outlook or any email using Yahoo mail as an interface or even convert it to VCF to support in any smartphone app.
How To – Export Facebook Contacts To Excel – using Yahoo mail?