How To - Export Facebook Contacts To Excel

Export Contacts from Facebook to Excel

To export Facebook contacts to Excel with email addresses or CSV/vCard (.vcf) format use this trick.

Facebook contacts to Excel using Yahoo.
Sync phone contacts - export Facebook contacts to Gmail.

Best part? Open your old Yahoo mail account. The other method is explained in a separate article.

Export Facebook Contacts To Excel using Yahoo Mail

FB has option to backup your complete profile data. But does not provide a direct method to export Facebook contacts to Excel (email addresses, phone numbers etc.,). To do this, we have to follow one of the above two indirect methods. Go through these 2 steps to complete to export email addresses from Facebook to your Yahoo Account.

Export Facebook Contacts To Excel Using Yahoo Mail.

Step 1: Sync Facebook Contacts with Yahoo:

1. Login to your Yahoo mail account. 
2. If you don’t have one, sign up for new id & login.
2. Click the Contacts section.
3. Select 'Import Contacts' or 'Facebook' on left side panel.
4. Choose 'Import' under Facebook import section.
5. Approve the Popup Authorization request to get connected to your FB account.

Step 2: Export Yahoo Contacts To Excel:

1. Choose 'Facebook’ on the left side panel.
2. Click on 'Actions' & 'Export'.
3. Select 'Yahoo CSV' format to export.
4. 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.,

Download Facebook Contact To Yahoo - Explained

Now, all the contacts from Facebook account will be synced 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, lets see how to export Yahoo contacts to Excel or .vcf vCard format. 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.