Office 365 (Outlook 2013 | 2010) - Import Contacts

Important: By February 2017, Microsoft will no longer push any updates to Office 2013 suite of applications. Please see the following document for further details: Office 365 - Microsoft Office 2013 path to retirement.

You can use Outlook 2013/2010 to bring contacts from other email accounts (or address books) into your Office 365 account.

Important: If you use Outlook on the web and Outlook 2013, 2011, or 2010, to connect to your Office 365 account, you will only need to import these contacts once using any of these clients. Once imported, they will be available to you in the other clients.

How do I import contacts using Outlook 2013/2010?

  1. Export the contacts from your other email account to a .csv file. Instructions for exporting your contacts from a variety of email clients are available here. Note where you save the .csv file.
  2. Start Outlook.
  3. Click the File tab.
  4. Click Open & Export. For Outlook 2010, click Open.
  5. Click Import/Export. For Outlook 2010, click Import.
  6. Click Import from another program or file, and then click Next.
  7. Under Select the file type to import, click Comma separated values, and then click Next.

    The most common is Comma Separated Values (Windows), also known as a CSV file. If you are importing contacts that were exported from Outlook to an Outlook Data File (.pst), click Outlook Data File (.pst).

  8. Under File to import, click Browse, select the file that you want to import, and then click OK.
  9. In the Import a File dialog box, under Options, click one of the following:
    • Replace duplicates with items imported    If an Outlook contact already exists, it is replaced by the information that you are importing.
    • Allow duplicates to be created    If an Outlook contact exists, the imported contact is created as a second contact.
    • Do not import duplicate items    If an Outlook contact exists, the information for the imported contact is not imported.
  10. Click Next.
  11. In the Import a File dialog box, under Select destination folder, click a folder for the imported contacts, and then click Next.

    This usually is the Contacts folder unless you have multiple accounts, or have created multiple contact folders for an account.

  12. If your contacts were exported from Outlook, click Finish. If they were exported from another client, like Thunderbird, see the instructions below:

    • Map Custom Fields
      • Before clicking Finish, select Map Custom Fields...

        You will now see a screen similar to the image below. The "Values" column on the left side displays the items that you are importing. The right side has two columns. The "Field" column represents fields in your Outlook address book, and the "Mapped from" column shows which data will fill each field. For example, if the field E-mail 1 is mapped from the value Business E-mail, your contact's business email address will show up in the first email address field once it's imported to Outlook.

        01-MapCustomFields

        To make sure your contacts import correctly, make sure that the items in the "Mapped from" column are consistent with items in the "Field" Column. You will have to click on the plus sign (plus_icon) icons to expand items in the "Field" column. To designate a field for a given value, simply drag the item from the "Value" column to the "Field" column.

        In the example below, The name fields do not have anything in the "Mapped from" column. If these contacts were imported as is, none of the contacts would have names in the Outlook address book.

        02-Mappedfromvs.Field

        After dragging the values Title, First Name, Middle Name, and Last Name to the right hand side, the names will import correctly. This process should be repeated for email addresses, and any other piece of contact information that you want imported.

        03-Dragvalues

See Also:




Keywords:microsoft office365 o365 importing exporting contacts address book outlook 2010 2013 email o365 thunderbird map mapping custom fields addressbook addresses imported   Doc ID:35410
Owner:Ara M.Group:Office 365
Created:2013-11-20 16:30 CDTUpdated:2016-08-23 10:44 CDT
Sites:DoIT Help Desk, DoIT Tech Store, Office 365
Feedback:  9   33