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

Note   You can't export contacts from Outlook for Mac 2016. For more information, see Known issues in Outlook 2016 for Mac.

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.

After you import contacts, here's what they look like in Outlook on the web.

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 2010

Outlook 2007

Outlook for Mac 2011

Note   Outlook for Mac 2016 doesn't support exporting to a .pst file. You can export files in Outlook for Mac (.olm) format, which let's you import them into another instance of Outlook for Mac.

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.

Applies To: Outlook Web App, Outlook Web App for Office 365 operated by 21Vianet, Outlook Web App for Office 365 Small Business, Office 365 End User, Outlook Web App for Office 365, Office 365 Admin, Microsoft Outlook Web App for Office 365 operated by 21Vianet - Small Business, Outlook on the web for Office 365 Business

Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Change language