Import contacts to Outlook

Outlook has an Import/Export wizard that makes it easy to import contacts from a CSV file.

  1. At the top of your Outlook 2013 or 2016 ribbon, choose File.

    If your ribbon doesn't have a File option in the top left corner, you're not using Outlook 2016 or 2013. See What version of Outlook do I have? to get to the import instructions for your version of Outlook.

    This is what the ribbon looks like in Outlook 2016.
  2. Choose Open & Export > Import/Export. This starts the wizard!

    To create your Outlook pst file, choose File, choose Open and Export, and then Import/Export

  3. Choose Import from another program or file, and then choose Next.

    import and export wizard - import from another program or file

  4. Choose Comma Separated Values, and then choose Next.

    Outlook Export Wizard - Choose CSV file

  5. In the Import a File box, browse to your contacts file, and then double-click to select it.

    Browse to the contacts csv file and choose how to handle duplicate contacts

  6. Choose one of the following to specify how you want Outlook to handle duplicate contacts:

    • Replace duplicates with items imported   If a contact is already in Outlook and your contacts file, Outlook discards the info it has for that contact and uses the info from your contacts file. You should choose this option if the contact info in your contacts file is more complete or more current than the contact info in Outlook.

    • Allow duplicates to be created   If a contact is in Outlook and your contacts file, Outlook creates duplicate contacts, one with the original Outlook info and one with the info imported from your contacts file. You can combine info for those people later to eliminate duplicate contacts. This is the default option.

    • Do not import duplicate items    If a contact is in Outlook and your contacts file, Outlook keeps the info it has for that contact and discards the info from your contacts file. You should choose this option if the contact info in Outlook is more complete or more current than the info in your contacts file.

  7. Click Next.

  8. In the Select a destination folder box, scroll to the top if needed and select the Contacts folder > Next. If you have multiple email accounts, choose the Contacts folder that's under the email account you want to be associated with the contacts.

    When you import Google Gmail contacts into your Office 365 mailbox, select Contacts as the destination

  9. Choose Finish.

    When you import Gmail contacts to your Office 365 mailbox, click the Finish button to start the migration

    Outlook begins importing your contacts immediately. You'll know it's finished when the Import Progress box closes.

  10. To see your contacts, at the bottom of Outlook, choose the People icon.

    Choose the People icon at the bottom of the page.

If you have an Office 365 mailbox, you can access it over the Internet, just like you sign in to Facebook, Gmail, or Amazon. It looks like this:

What the ribbon looks like when you have Outlook on the web.

To import your contacts to your Office 365 mailbox, you need to use Outlook 2016, 2013, 2010, or 2007. When you launch Outlook, you'll see "File" in the top left corner:

What the ribbon looks like in Outlook 2016

To import contacts to your Office 365 email account:

  1. Export your contacts from your "source" email service:

  2. Add your Office 365 email account to Outlook.

    Outlook will sync with your Office 365 mailbox. After a while, you'll see a copy of your email and contacts in Outlook.

  3. Use the import instructions on this page for Outlook 2016, 2013, or 2010 to import a CSV file or .pst file that has your contacts.

If you don't have Outlook installed on your computer, see How to get Outlook for your desktop.

  1. At the top of your Outlook ribbon, choose the File tab.

    If your ribbon doesn't have a File option in the top left corner, you're not using Outlook 2010. See What version of Outlook do I have? to get to the import instructions for your version of Outlook.

    In Outlook 2010, choose the File tab.

  2. Choose Open > Import. This starts the wizard!

    Choose Open, then choose Import.

  3. In the Import and Export Wizard, click Import from another program or file, and the click Next.

    Choose import from another program or file.

  4. To import a CSV file, choose Comma Separated Values (Windows).

    Choose .pst import

  5. Choose Browse, then choose the .csv file you want to import, and choose Next.

    Notes:  Under Options, if you want the imported information to replace duplicate items already in Outlook, choose that. Otherwise, choose Do not import duplicates.

    Choose the .pst file you want to import

  6. Set the options for importing items. Choose Filter if you want to only import certain emails. Choose the More Choices tab if you want to only import emails that are read or unread.

    The default settings usually don’t need to be changed. The top folder — usually Personal Folders, Outlook Data File, or your email address — is selected automatically.

    Choose Filter if you want to import only certain emails.

  7. Include subfolders is selected by default. All folders under the folder selected will be imported.

  8. The default selection of Import items into the same folder in matches the folders from the imported file to the folders in Outlook. If a folder doesn’t exist in Outlook, it will be created.

  9. Choose Finish. Outlook starts importing your data immediately. You'll know it's finished when the progress box closes.

  10. To view your contacts, at the bottom of the Outlook navigation bar, choose Contacts.

    To see your contacts, choose "Contacts" at the bottom of the Outlook navigation menu.

Didn't work?

See Fix problems importing contacts to Outlook.

See Also

Import and export Outlook email, contacts, and calendar

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×