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.
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”.
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.
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.
Now you will see the usual “Import and Export Wizard” screen. Select the “Import from another program or file” and click the “Next” button.
On this screen, select “Comma Separated Values (DOS)” and click the “Next” button
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.
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.
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.