How to Import Contacts to Microsoft Outlook From Microsoft Excel

The article intends to explain the process of importing contacts from Microsoft Excel into Microsoft Outlook using easy instructions. Though we have attempted to compile the simple and reliable information in this guide, it's still suggested that you follow the instructions carefully to avoid facing any issue.

Users often use their Microsoft Outlook to store and further use large amount of personal data including emails, contacts etc.. Importing is just one of those practices that consumers perform to transfer data into Outlook for further use. You may choose to import your Excel sheet contacts into Outlook for any range of factors. But, it isn't possible to directly import contacts from Excel into Outlook. You'll need to perform a small workaround to do the importing. Sounding difficult? Thinking of contacting Microsoft technical assistance for assistance? Don't worry. You don't need to get in touch with your Microsoft technical help as we have brought you this step-by-step guide that can allow you to import your Excel contacts in to Microsoft Outlook painlessly.

Instructions:

Export from Excel:

First of all, you would need to export the contacts from Excel spreadsheet to a CSV (comma separated value) file with these basic directions. If your Excel sheet(s) comprises data into various columns such as Name, Phone number, Email address etc., then click the File menu on top and click the Save As option. When the Save As window pops up, pick a folder in the dropdown menu next to your Save box, provide a name to the file such as 'excel contacts' (or a title of your choice) from the File name box, then pick CSV (Comma delimited) from the dropdown menu of Save type box, also click the Save button. Now you are done exporting Excel contacts to a CSV file.

Click here to watch the video

If your Excel sheet does not include column-divided information, then it is strongly suggested you do so. To accomplish this, put in a blank cell to the Excel sheet and split data into various columns such as Name, address etc.. Once you are finished doing so, follow the exact same procedure to export the data to a CSV file format.

Import into Outlook:

If you're importing Excel contacts in to the present Contacts folder in Outlook, then utilize this method. Open Outlook, Click the File menu at the top, and choose Import and Export. When the Import and Export wizard window opens up, select Import from another program or file, and click the Next button. Under the Import a File window, then click on Comma Separated Values (Windows), and click on Next. If you realize that the file shown in the File to import box will be the document the correct document (in this case 'excel contacts' we created while exporting), click on the Next button (let the copies to be created if you're in doubt by selecting one of the three options on the exact same window before clicking on the Next button), then click the Finish button to close the window. If you find that the document is not the desired one, then click on the Browse button to find the document, double click it to start (like 'excel contacts'), select Allow duplicates option (if you would like to), then click the Next button. If you doubt that the columns in Excel spreadsheet will not properly map to the Outlook fields, then select Map custom fields choice before clicking on the Finish button.

If you're attempting to import contacts to a new folder rather than into the existing folder, then create a new folder. Open Outlook, right Click the Contacts folder, and choose New Folder. Give a name to your folder and then click on the OK button to close the window. Now follow the identical method to access the Import and Export wizard and begin importing.