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

Kutools for Outlook: 100+ New Advanced Tools for Outlook.
Office Tab: Enable Tabbed Editing and Browsing in Office, Just Like Chrome, Firefox, IE 8/9/10.
Classic Menu: Bring Old Menus and Toolbars Back to Office 2007, 2010, 2013, 2016 and 2019.

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.

 

Recommended Productivity Tools

shot kutools outlook kutools tab 1180x121
shot kutools outlook kutools plus tab 1180x121

Kutools for Outlook - More than 100 Advanced Functions for Outlook, Improve 70% Efficiency For you

  • Complicated and repeated operations can be done a one-time processing in seconds.
  • Forward multiple emails individually with one-click, and auto forward by rules.
  • Auto CC/BCC every sending email and easy for customizing rules, and auto reply without requiring exchange server.
  • Powerful junk emails filter, remove duplicate emails, reply with attachment, bunch of one-click operations, and so on...
  • 60-day unlimited free trial. 60-day money back guarantee. 2 years free upgrade and support. Buy once, use forever.
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 · 3 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 · 3 years ago
      Same as mine. I'm running 2013 Office and Excel.
  • To post as a guest, your comment is unpublished.
    Roxie · 4 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 · 5 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 · 5 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. :-)