Now all we have to do is go to Contacts and you can see the new contacts you’ve created from your Excel spreadsheet!Ĭlick here to watch this video on YouTube.Once you’re done mapping, just click OK > Finish and your contact import will be complete. 1 - From Control Panel Regional Settings -> change your region to any country that uses a comma as a list separator (i.e.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. Outlook can only import data from an Excel file(xls) from a named range so we select A1:C5 in this example (with the header row) and use the shortcut Ctrl F3 to. ![]() See screenshot: Note: If you are using Outlook 2010, please click File > Open > Import. ![]() The key to importing is saving the list in the right format. Then enable Outlook, click File > Open & Export > Import/Export in Outlook 20.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.
0 Comments
Leave a Reply. |