Chat with us, powered by LiveChat

Import Contacts into Outlook

How to Import Contacts in Outlook

Import Contacts into Outlook

If you already have a contact list created outside of Outlook, such as an Excel file, you can import it into Outlook instead of reentering information.

  1. Click the File tab.

    Import Contacts

    Outlook appears in Backstage view.

    1. Select Open & Export.
    2. Click Import/Export.
      Import Contacts

      The Import and Export Wizard appears.

    3. Select Import from Another Program or File.
    4. Click Next.

      Import Contacts

      The Import A File dialog box appears.

    5. Select Comma Separated Values.

      If you’re importing from Excel, or another database, you’ll need to save the file as a CSV, meaning the values are separated by commas.

    6. Click Next.
      Import Contacts
    7. Click Browse, select the file, and click OK.
      Import Contacts

      If you haven’t added any contacts to Outlook yet, don’t worry about duplicates. But if you know you have duplicates, you’ll want to select the “Do not import duplicate items” option.

    8. Click Next.
    9. With Contacts selected as the destination folder, click Next.
      Import Contacts

      If your CSV file has a lot of fields and you want to make sure they map to the correct Outlook fields, click Map Custom Fields.

    10. Click Finish.
      Import Contacts

      Outlook begins importing the contacts from the selected file. This process may take a moment, but once it completes, the contacts will appear alongside your existing contacts.

FREE Quick Reference

Click to Download