Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

How to import contacts into Outlook from excel?

If you have an excel spreadsheet that contains contact information. This contact information file can be imported into Outlook contacts. The following instruction will help you import your contact file from excel into Outlook.

Import contact into Outlook from excel

Office Tab - Enable Tabbed Editing and Browsing in Office, and Make Work Much Easier...
Kutools for Outlook - Brings 100 Powerful Advanced Features to Microsoft Outlook
  • Auto CC/BCC by rules when sending email; Auto Forward Multiple Emails by rules; Auto Reply without exchange server, and more automatic features...
  • BCC Warning - show message when you try to reply all if your mail address is in the BCC list; Remind When Missing Attachments, and more remind features...
  • Reply (All) With All Attachments in the mail conversation; Reply Many Emails at once; Auto Add Greeting when reply; Auto Add Date&Time into subject...
  • Attachment Tools: Auto Detach, Compress All, Rename All, Auto Save All... Quick Report, Count Selected Mails, Remove Duplicate Mails and Contacts...
  • More than 100 advanced features will solve most of your problems in Outlook 2010-2019 and 365. Full features 60-day free trial.

arrow blue right bubble Import contact into Outlook from excel

1. Launch your outlook 2013 or 2010, click File > Open > Import. See screenshot:

2. Under Choose an action to perform, select Import from another program or file, and then click Next to continue.

3. In the following popup window, under Select file type to import from, select Microsoft Excel 97-2003, and then click Next button.

4. Click Browse button to locate the file that you wish to import from.

5. Find your file and select it, and click OK.

6. It turns to the previous window. Under the Options, there are three options for you, you can choose your desired one, then click Next.

7. Select your destination folder to save the file content. Click Next button.

8. In the popup dialog, click Finish button to finish the whole import settings.

Note: if you don’t want to follow up the default settings of Outlook Contacts, you can click on the top right corner button “Map Custom Fields” to choose your own settings. And click on the “Change Destination” button to reselect your destination folder.


Kutools for Outlook - Brings 100 Advanced Features to Outlook, and Make Work Much Easier!

  • Auto CC/BCC by rules when sending email; Auto Forward Multiple Emails by custom; Auto Reply without exchange server, and more automatic features...
  • BCC Warning - show message when you try to reply all if your mail address is in the BCC list; Remind When Missing Attachments, and more remind features...
  • Reply (All) With All Attachments in the mail conversation; Reply Many Emails in seconds; Auto Add Greeting when reply; Add Date into subject...
  • Attachment Tools: Manage All Attachments in All Mails, Auto Detach, Compress All, Rename All, Save All... Quick Report, Count Selected Mails...
  • Powerful Junk Emails by custom; Remove Duplicate Mails and Contacts... Enable you to do smarter, faster and better in Outlook.
shot kutools outlook kutools tab 1180x121
shot kutools outlook kutools plus tab 1180x121
 
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    Hank Bradley · 3 years ago
    There's no option presented for selecting Excel files as suggested in Step 3 above. And the mapping option is greyed-out, the box is inactive. No success.
  • To post as a guest, your comment is unpublished.
    Bnordin · 4 years ago
    In the select file type to import menu, my options are only 'Comma Seperated' and 'pst' files. Any way to add an option for Excel? I'm running Office 2013.
  • To post as a guest, your comment is unpublished.
    llrobins · 4 years ago
    At step #3, I only am given the options for the comma separated files. I do not get the option of an excel file or the others listed. What do I need to change to allow excel files as an option.
    • To post as a guest, your comment is unpublished.
      Bnordin · 4 years ago
      Same as mine. I'm running 2013 Office and Excel.
  • To post as a guest, your comment is unpublished.
    Roxie · 5 years ago
    I received the same error message "service provider does not support". Is there a fix?
  • To post as a guest, your comment is unpublished.
    Garnett Satterfield · 6 years ago
    Went through the procedures to import contacts into Outlook. It could not finish because "service provider does not support". What does this mean?
    • To post as a guest, your comment is unpublished.
      Jay Chivo · 6 years ago
      [quote name="Garnett Satterfield"]Went through the procedures to import contacts into Outlook. It could not finish because "service provider does not support". What does this mean?[/quote]

      Have you encountered the error when you applying the exact steps of the article?

      Please be more specific about your problem. :-)