Skip to main content

How to import contacts into Outlook from excel?

Author: Siluvia Last Modified: 2013-06-03

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 Microsoft Office, Making Work a Breeze
Unlock Kutools for Outlook's free version now and enjoy over 70 features with unlimited access forever
Boost your Outlook 2021 - 2010 or Outlook 365 with these advanced features. Enjoy 70+ powerful features and elevate your email experience!

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.


Best Office Productivity Tools

Breaking News: Kutools for Outlook Launches Free Version!

Experience the all-new Kutools for Outlook FREE version with 70+ incredible features, yours to use FOREVER! Click to download now!

🤖 Kutools AI : Instant pro emails with AI magic--one-click to genius replies, perfect tone, multilingual mastery. Transform emailing effortlessly! ...

📧 Email Automation: Auto Reply (Available for POP and IMAP)  /  Schedule Send Emails  /  Auto CC/BCC by Rules When Sending Email  /  Auto Forward (Advanced Rules)   /  Auto Add Greeting   /  Automatically Split Multi-Recipient Emails into Individual Messages ...

📨 Email Management: Recall Emails  /  Block Scam Emails by Subjects and Others  /  Delete Duplicate Emails  /  Advanced Search  /  Consolidate Folders ...

📁 Attachments ProBatch Save  /  Batch Detach  /  Batch Compress  /  Auto Save   /  Auto Detach  /  Auto Compress ...

🌟 Interface Magic: 😊More Pretty and Cool Emojis   /  Remind you when important emails come  /  Minimize Outlook Instead of Closing ...

👍 One-click Wonders: Reply All with Incoming Attachments  /   Anti-Phishing Emails  /  🕘Show Sender's Time Zone ...

👩🏼‍🤝‍👩🏻 Contacts & Calendar: Batch Add Contacts From Selected Emails  /  Split a Contact Group to Individual Groups  /  Remove Birthday Reminders ...

Instantly unlock Kutools for Outlook with a single click—permanently free. Don't wait, download now and boost your efficiency!

kutools for outlook features1 kutools for outlook features2
 

 

 

Comments (7)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
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.
This comment was minimized by the moderator on the site
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.
This comment was minimized by the moderator on the site
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.
This comment was minimized by the moderator on the site
Same as mine. I'm running 2013 Office and Excel.
This comment was minimized by the moderator on the site
I received the same error message "service provider does not support". Is there a fix?
This comment was minimized by the moderator on the site
Went through the procedures to import contacts into Outlook. It could not finish because "service provider does not support". What does this mean?
This comment was minimized by the moderator on the site
[quote]Went through the procedures to import contacts into Outlook. It could not finish because "service provider does not support". What does this mean?By Garnett Satterfield[/quote] Have you encountered the error when you applying the exact steps of the article? Please be more specific about your problem. :-)
There are no comments posted here yet
Leave your comments
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations