The position will be discarded when we import the file. It features separate First and Last name fields, an email address field, as well as each player’s position. It is dummy data, but made to be similar to something you might receive as a list of players on a sports team. Pictured above is the file with the contacts I would like to import. Then, we will map it and import the contacts. xlsx format so we will first convert it to. Last updated on August 5, 2014.In this article we are going to import contacts to Outlook from an Excel file.
IMPORT CONTACTS TO OUTLOOK CSV FILE FREE
Other Street, Other Street 2, Other Street 3, Other Address PO Box, Other City, Other State, Other Postal Code, Other Country/Region, Profession, Referred ByĪssistant's Phone, Business Fax, Business Phone, Business Phone 2, Callback, Car Phone, Company Main Phone, Home Fax, Home Phone, Home Phone 2, ISDN, Mobile Phone, Other Fax, Other Phone, Pager, Primary Phone, Radio Phone, TTY/TDD Phone, TelexĪccount, Anniversary, Birthday, Spouse, Children, Gender, Hobby, Initials, Categories, Internet Free Busy, Keywords, Language, Location, Notes, Priority, Private, Sensitivity, User 1, User 2, User 3, User 4, Web Page Home Street, Home Street 2, Home Street 3, Home Address PO Box, Home City, Home State, Home Postal Code, Home Country/Region Title, First Name, Middle Name, Last Name, Suffix, E-mail Address, E-mail Type, E-mail Display Name, E-mail 2 Address, E-mail 2 Type, E-mail 2 Display Name, E-mail 3 Address, E-mail 3 Type, E-mail 3 Display NameĬompany, Department, Job Title, Assistant's Name, Business Street, Business Street 2, Business Address PO Box, Business Street 3, Business City, Business State, Business Postal Code, Business Country/Region, Billing Information, Manager's Name, Mileage, Directory Server, Organizational ID Number, Office Location, Government ID Number Not all of the fields may be available to import. Note: this are the field names Outlook exports. When you are done linking the field names, click Ok then click Finish to complete the Import.
![import contacts to outlook csv file import contacts to outlook csv file](https://o365info.com/wp-content/uploads/ngg_featured/Import-Googles-contacts-from-a-CSV-file-using-Outlook-or-OWA-part-1-2.jpg)
Drop it on the highlighted Outlook field name. If a field should have a match in your CSV file but the Mapped From column on the right is blank, locate the field name that your field uses (on the left) and drag it to the Outlook field name on the right. In this screenshot, Company, Department, and Job Title fields are correctly mapped. In the Map Custom Fields dialog, check the field names on the right. On the last page, before clicking Finish, click the Map Custom Fields button. Once you get into the Import/Export wizard, the screens look the same for all versions of Outlook. In Outlook 2007 and older, look for Import/Export on the File menu. In Outlook 2010, It's File, Open, Open and Import. In Outlook 2013, go to File, Open & Export, Import/Export. I recommend using CSV files so you don’t have to mess with named ranges.
![import contacts to outlook csv file import contacts to outlook csv file](https://cdn.ablebits.com/_img-blog/import-contacts/sample-scv-file.png)
If a field or record falls outside of the named range, it won’t import. When you import Excel files (.xls), you need to use named ranges. You have two choices: change the field names in the CSV so they match Outlook's (a list of Outlook field names is at the end) or map your field name to the corresponding field name in Outlook. It's a sure bet that your file does not use ‘E-mail Address’ for the email address field. Open the CSV file in Notepad or Excel and look at the field names at the top of the file. In most cases, if the field names aren't the same as Outlook uses, you need to tell Outlook which fields to match. If it can't match the fields, it won’t import them. When Outlook imports, the fields names in your file need to match Outlook’s field names. That the addresses aren't importing but the names are tells me that Outlook didn't import the addresses because the field names in your CSV don't match with the field names in Outlook. Outlook will import the names, but not the email addresses. I’ve attempted several times to import my address list without any success.