IT Knowledgebase
< All Topics
Print

Import contacts from a .csv to Outlook 2013 or 2016

A .csv file is a Comma Separated Values file.

  1. At the top of your Outlook 2013 or 2016 ribbon, choose File. This is what the ribbon looks like in Outlook 2016.
  2. Choose Open & Export > Import/Export. 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.

Credit:  https://support.office.com/en-US/article/Import-contacts-to-Outlook-bb796340-b58a-46c1-90c7-b549b8f3c5f8

Messenger