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.
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.
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
- 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.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
To post as a guest, your comment is unpublished.· 3 years agoThere'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.· 3 years agoIn 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.· 4 years agoAt 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.· 4 years agoI received the same error message "service provider does not support". Is there a fix?
To post as a guest, your comment is unpublished.· 5 years agoWent 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.· 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. :-)