can you import contacts to outlook with an excel files

You can directly Copy & Paste contacts straight from Excel worksheet to Microsoft Outlook if you just need them for one-time use. Once you have all the contacts imported from an Excel spreadsheet to your Outlook contacts, you can easily follow this link to add contacts in an Outlook Contact Group. Import Email Addresses from Excel to Outlook Distribution List You can go to the people section on the Navigation panel and see all your contacts imported in the Contact list of Microsoft Outlook. It will take some time to process the request and sync done. It will show the assigned values in the rightmost section of the box. Drag ‘Email’ field from the left to the ‘Email’ field in the right section. For an Example, drag ‘Name’ from left to the ‘Name’ in the right box. Drag and drop the values from the left-hand side box to the right-hand side box on the destination field. It will open another window with parallel boxes to match ‘From’ and ‘To’ fields. Click on the ‘Map Custom Fields’ on the top right of the box. It is essential to have a standard format and get everything the right way.

Ensure that you have the checkbox checked on the next screen before you click on the ‘Finish’ button. If it is not the case, scroll up or down and select ‘Contacts’ from the destination list. Click on the ‘Next’ button and it will ask for the destination folder where you wish to save you contacts. Under the options, you can keep ‘Allow Duplicates to be Created’. On the next screen, browse for the CSV file location from the destination you saved it. Click on ‘Comma Separated Values’ and go ‘Next’. Select ‘Import from another program or file’ option from the available list in the wizard. A new window will open with ‘Import and Export Wizard’. Click on the ‘Open & Export’ option and select ‘Import/Export’ from the options.

Open Microsoft Outlook and go to the ‘File’ menu.

Now that we have our file ready, it’s time to import contacts from Excel to Outlook. You can click on ‘Okay’ and ‘Don’t show again’ to move ahead.Īlso Read: How to lock Cells In Excel To protect Data Import Contacts from Excel Microsoft Excel will give you some notifications while saving the CSV file format however that can be ignored. Choose the destination folder location and under ‘Save as Type’ box, choose ‘CSV (Comma delimited) (*.csv)’ format and click on the ‘Save’ button.

Can you import contacts to outlook with an excel files