How to use Actionetics

How to Import Contacts to Microsoft Outlook From Microsoft Excel

The article intends to explain the process of importing contacts from Microsoft Excel to Microsoft Outlook using easy instructions. Although we have attempted to compile the simple and reliable data in this guide, it is still suggested that you follow the instructions carefully to avoid facing any problem.

Users frequently use their Microsoft Outlook to store and further use substantial amount of private data such as emails, contacts etc.. Importing is just one of those practices that consumers perform to transfer data into Outlook for additional use. You might choose to import your Excel sheet contacts into Outlook for a range of factors. But, it isn't feasible to directly import contacts from Excel into Outlook. You'll need to do a little workaround to do the importing. Sounding hard? Thinking of contacting Microsoft technical assistance for help? Don't worry. You don't need to get in touch with your Microsoft technical support as we have brought you this step-by-step guide that can help you 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 using these simple instructions. If your Excel sheet(s) comprises data into different columns such as Name, Phone number, Email address etc.), then click on the File menu at the top and click the Save As option. When the Save As window comes up, select a folder from the dropdown menu near your Save box, provide a name to the file such as 'excel contacts' (or a name of your choice) from the File name box, pick CSV (Comma delimited) from the dropdown menu of Save type box, and click on the Save button. Now you're done exporting Excel contacts into a CSV file.

If your Excel sheet doesn't include column-divided information, then it is strongly suggested that you do so. To do so, add a blank cell to the Excel sheet and split data into different columns such as Name, address etc.. As soon as you are finished doing so, follow the same process to export the information 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 on the File menu at the top, and then choose Import and Export. When the Import and Export wizard window opens, select Import from another program or document, and then click on the Next button. Beneath the Import a File window, then click on Comma Separated Values (Windows), and click on Next. If you find that the file displayed in the File to import box will be the file the correct document (in this case 'excel contacts' that we created while exporting), click on the Next button (let the copies to be created if you are unsure by choosing one of the 3 options on precisely the same window before clicking on the Next button), click the Finish button to close the window. If you find that the document isn't the desired one, then click on the Browse button to find the file, double click on it to open (like 'excel contacts'), pick Allow duplicates choice (if you want to), and click on 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 trying to import contacts to some other folder rather than into the present folder, then make a new folder. Open Outlook, right click on the Contacts folder, and choose New Folder. Give a title to the folder and then click the OK button to close the window. Now follow the identical method to access the Import and Export wizard and begin importing.