How to Import Contacts to Outlook 2013 from Excel 2013

 

Microsoft Outlook 2013 has been introduced with new and improved features and file format support is one of them. The latest Outlook version (2013) now only supports CSV (comma/character separated value) and PST (Personal Storage Table) file formats and no other type like its predecessors. So if you have an Excel contacts file whose contacts you want to save to your Outlook 2013, you can do so by using any of these file formats. For now we’ll stick to the CSV format as the PST format is used only when you want to back your entire Outlook data. So here you go with those instructions to import your Excel 2013 contacts to your Outlook 2013. Before you go ahead, let me remind you that you cannot import workbooks having multiple worksheets but an individual sheet can.

 

Step 1

You will need to save your Excel 2013 workbook, which has contacts, in the CSV file format in order to let Outlook 2013 import it. To do so, open your Excel sheet and then from the “File” menu, select “Save As”.
import contacts to outlook
On the “Save As” window, select “CSV (Comma delimited)” from the drop-down menu beside “Save as type”. Select a desired location viz. “Documents” or “Desktop” etc. to save your Excel contacts sheet. Click the “Save” button and move on to the next step.

documents library in outlook

 

Step 2

Now that your Excel file is saved in the CSV format you can begin to import the contacts from it to your Outlook. Open Outlook 2013 and click the “File” sub-menu under the “Menus” tab and then select “Import & Export” from the list of options.

import export in outlook

 

Step 3

Now you will see the usual “Import and Export Wizard” screen. Select the “Import from another program or file” and click the “Next” button.

import and export wizard

On this screen, select “Comma Separated Values (DOS)” and click the “Next” button

expert file in outlook

On the next screen, click the “Browse” button and locate your Excel 2013 contacts file. Double click the file to open up and then click the “Next” button. Before you click “Next”, you can select under “Options” whether to replace duplicates or not or import or not.

import file in outlook

 

Step 4

Now select in which Outlook folder you want to save these Excel contacts to. Select the “Contacts” folder if it’s not already selected. Click the “Next” button.

import contact in outlook

On the next screen, make sure that the “Import “My Contacts.csv”” checkbox is selected. Now check the button beside “Map Custom Fields”. Outlook 2013 will need to map your contacts so that it can import them. Make sure that the contacts from the CSV file appears under the “To” field of Microsoft Office Outlook Contacts. If there are contacts under a column which don’t appear in Microsoft Outlook or vice-versa you may have to manually map them. When you are done mapping the contacts, click the “Finish” button.

 
Keylogger Removal Online Tech Support
Should you face any errors or problems while or after importing contacts from Excel 2013 to your Outlook 2013, call us at +1-877-907-4935 and get an expert to help you.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s