how to import contacts into outlook fom excel

Once you’re done mapping, just click OK > Finish and your contact import will be complete.

For instance, what we labeled our “Landline” column is equivalent to what Outlook calls “Home phone numbers.” So we’ll drag it over here to “Home Phone.”

For anything that doesn’t match up exactly, you can make sure that your information is going where you intended it to by dragging and dropping values where you want them mapped to within Outlook.

If we open up the “Name” field, we see First Name and Last Name have successfully mapped over. You’ll see that some of the headers have automatically mapped.

When it asks you to select a Destination Folder, select your Contacts folder.In Outlook, click on File > Open & Export > Import/Export > Import from another program or file > Next > Comma Separated Values > Next > Navigate to your file and import it.The key to importing is saving the list in the right format.Here’s our example contact list that we’ve set up in Excel.This trick makes moving contacts between accounts, employees, or different pieces of software super easy. An interesting feature you might not know about is how to import contacts from an Excel spreadsheet into Outlook.

How to import contacts into outlook fom excel