Export contacts from Outlook and other email services and programs
Do you want to export contacts from Outlook on the web? See these instructions.
You can export contacts from Outlook on Windows (this is the version of Outlook on your desk). You can also export your contacts from Gmail, Yahoo!, Outlook.com (formerly Hotmail), and other email hosters.
Use the following links to find the instructions for exporting your contacts to a CSV file. Or, you can manually create a list of contacts using our sample CSV file.
Export contacts from a desktop version of Outlook to a CSV file
Export and import for Mac users moving to Outlook for Windows or Outlook on the web
Do you want to export contacts from Mac 2011 and import them into Outlook on the web? These instructions explain how to get your Mac 2011 contacts into csv format
If someone has sent you a .vcf file and you have Outlook desktop, you can import the contacts into your Outlook desktop, and then export them as a CSV file.
Export contacts from other email services to a CSV file
Next step: Import contacts to Outlook
After you export your contacts into a CSV file, you can import them to your Office 365 mailbox, or to another Exchange-based email program.
Manually create your list of contacts in a CSV file
If you can't or don't want to export your list of contacts, you can manually create a CSV file with the information you want to import. Download this sample CSV file, open it in Excel, and use it as a starting point for creating your list of contacts. There are a few things to remember when working with this sample CSV file:
Outlook Web App requires the column headings in the first row so don’t replace them with something else.
Save the file with a new name as a CSV file type (.csv). If you use Excel to work in the file, when you save it, Excel will prompt you a few times with "are you sure you want to save it in CSV format?" Always choose Yes. If you choose No, the file will get messed up and you'll need to start over with a fresh sample template.
Practice importing your CSV file with a few contacts to make sure you like the results. Afterwards, you can delete the imported contacts, add more to your CSV file, and import it again.
Here's what it looks in Outlook Web App like when you import the contacts in the sample CSV file.
What if I want to know more?
If you use a desktop version of Outlook, you can also export information to an Outlook data file (.pst). The advantage of exporting and importing to an Outlook data file rather than a CSV file is that an Outlook data file lets you export and import email, contacts, calendar items, and more. For details, see the following articles.
Outlook 2013 or 2016
Outlook for Mac 2011
If you are using Office 365 for business, see Migrate email and contacts to Office 365 for business for information about migrating contacts for multiple mailboxes at the same time.