Export contacts from other email services and programs

You can export contacts from another email service or program such as Gmail, Yahoo!, or Outlook.com (formerly Hotmail), and then use them with your Office 365 or other Exchange-based account. The first step is to export the contacts from the other email service or program to a CSV (comma-separated value) file. A CSV file is a common file format used to store contact information.

After you export your contacts into a CSV file, you can import those contacts into your account by using Outlook Web App (the web browser version of Outlook), or by using a desktop version of Outlook (for example Outlook 2013, Outlook 2010, or Outlook 2011 for Mac). For more information, see Next steps.

In this article


Export contacts from another email service or program

Most email services and programs offer a way to export your contacts to a CSV file on your computer. How you do this depends on the email program you want to get your contacts from. The following sections include the steps for exporting contacts from some of the most common services and programs.

Export your Google Gmail contacts to a CSV file

  1. Log on to your Google Gmail account.
  2. Click Gmail > Contacts.

google gmail - click contacts

  1. At the top of the contacts section, click More > Export.

Google Gmail - Click more, export

  1. Under Which contacts do you want to export, click a contact group or All Contacts.
  2. Under Which export format, click Outlook CSV (for importing into Outlook or another application), and then click Export.

Gmail export contacts dialog box

  1. When prompted to download the export file, click Save As.

google gmail export contacts save as

  1. Click Browse and choose a location on your computer to temporarily save the file. The default file name is google.csv.

After you export your contacts, see Next steps.

Top of Page Top of Page

Export your Yahoo! contacts to a CSV file

  1. Sign in to your Yahoo! account.
  2. Click the Contacts tab.
  3. On the Actions menu, click Export All.
  4. Next to Microsoft Outlook, click Export Now.
  5. Enter the security code, and then click Export Now.
  6. When prompted to download the export file, click Save As.
  7. Click Browse and chose a location on your computer to temporarily save the file. The default file name is yahoo_contacts.

After you export your contacts, see Next steps.

Top of Page Top of Page

Export contacts from Outlook.com (formerly Hotmail) to a CSV file

  1. Sign in to your Outlook.com account.
  2. Click the down-arrow at the upper-left corner of your screen, and then click People.
  3. On the toolbar, click Manage > Export.
  4. When prompted to download the export file, click Save As.
  5. Click Browse and choose a location on your computer to temporarily save the file.

After you export your contacts, see Next steps.

Top of Page Top of Page

Export contacts from Mozilla Thunderbird to a CSV file

  1. Open Mozilla Thunderbird.
  2. Click the Address Book button on the toolbar.
  3. On the Tools menu, click Export.
  4. In the Export Address Book dialog box, choose a location on your computer to temporarily save the file. For example, you may choose to save it to your My documents folder.
  5. In the File name box, type a name for the file.
  6. In the Save as type dropdown, select Comma Separated (*csv).
  7. Click Browse and choose a location on your computer to temporarily save the file.

After you export your contacts, see Next steps.

Top of Page Top of Page

Export contacts from a desktop version of Outlook to a CSV file

The way you export contacts to a CSV file using a desktop version of outlook depends on which Outlook program you are using.

After you export your contacts, see Next steps.

Top of Page Top of Page

Next steps

After you export your contacts into a CSV file, you can import them into your Office 365 or other Exchange-based account using Outlook Web App (the web browser version of Outlook), or by using a desktop version of Outlook.

Import with Outlook Web App   Import contacts using Outlook Web App.

Import with a desktop versions of Outlook:

What if I want to know more?

If you use a desktop version of Outlook, you can export information that is stored in Outlook by using an Outlook data file (.pst). The advantage of exporting and importing by using 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

Outlook 2010

Outlook 2007

Outlook for Mac 2011

If your Exchange-based account is an Office 365 account, see Migrate email and contacts into a new Office 365 account.

Top of Page Top of Page

 
 
Applies to:
Microsoft Outlook Web App for Office 365 operated by 21Vianet - Small Business, Outlook Web App, Outlook Web App for Office 365 Enterprise, Outlook Web App for Office 365 operated by 21Vianet, Outlook Web App for Office 365 Small Business