Applies ToOutlook for Microsoft 365 Outlook for Microsoft 365 for Mac Outlook 2024 Outlook 2024 for Mac Outlook 2021 Outlook 2021 for Mac Outlook 2019 Outlook 2016

This article explains how to get your vCard (.vcf file) into CSV format so you can import your contacts into Outlook.

IMPORTANT: Make sure you've exported all of your contacts from iCloud! The most common mistake we see customers make is they export only 1 contact from iCloud when they intended to export all of them. For instructions on exporting all of your contacts from iCloud, see Export your iCloud contacts to a vCard (.vcf) file.

To import contacts in a vCard file to Outlook on a PC, you need to convert them from a .vcf file format to a .csv file format. This involves importing them to Windows, and then exporting them to the CSV file. If you have more than 50 or so contacts, this is a tedious process because you have to press OK for each contact you want to import to the csv file. Unfortunately, there's no way to do a global OK and import all of them to the csv file at the same time.

If you'd like to request that bulk import from a vCard file be supported in Outlook, visit the Outlook Suggestion Box to leave your feedback in the Outlook 2016 group. The Outlook Mail and Calendar team is actively monitoring this forum.

To convert a .vcf file to .csv, import them to Windows and then export them to a .csv file. Here's how to do that:

  1. On your PC, open File Explorer (or Windows Explorer if you are using an earlier version of Windows).

  2. Go to your Contacts folder:

    C:\Users\<username>\Contacts

  3. At the top of the page, choose Import.

    Navigate to the Contacts folder, then choose Import.

  4. Choose vCard (VCF file) > Import.

    Choose vCard, then choose Import.

  5. Navigate to and choose the .vcf file that you exported from iCloud, then choose Open.

    Choose your vCard file you want to import to .csv.

  6. For each contact you want to import to the .csv file, choose OK.

    Choose OK for each contact you want to import to the csv file.

  7. When you're finished, choose Close.

  8. At the top of the File Explorer page, choose Export.

  9. Choose CSV file > Export.

    Choose CSV and then choose Export.

  10. Choose Browse to name your csv file.

    Choose Browse to name your file.

  11. In the File name box, type a name for your .cvs file. In this example, I named my file "my contacts from iCloud."

    Type a name for your csv file and then choose Save.

  12. Choose the fields you want to export into the .csv file and then choose Finish. It's recommended that you accept the defaults for now. You can always create another csv file if you want other fields.

    Choose the fields you want to export to your csv file and choose Finish.

  13. You'll get this final message that your contacts have been exported to a .csv file.

    You'll see a final message that your contacts have been exported to a csv file.

  14. You can use Excel to open your .csv file to see what's there. You can add more info to the csv file if you want, but be sure not to change the top row of headings. For more info about working with the .csv file, see Manually create your list of contacts in a csv file.

  15. Now that your contacts are in .csv format, you can import them to Outlook. See Import contacts from a .csv file

See Also

Import and export Outlook email, contacts, and calendar

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.