![import csv contacts into outlook 2007 import csv contacts into outlook 2007](https://support.content.office.net/en-us/media/1d801468-80ca-4ccd-b205-605b3b9d58c5.png)
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 csv contacts into outlook 2007 import csv contacts into outlook 2007](https://cdn.ablebits.com/_img-blog/import-contacts/outlook-import-export.png)
If a field or record falls outside of the named range, it won’t import.
![import csv contacts into outlook 2007 import csv contacts into outlook 2007](https://www.isunshare.com/images/article/office/csv-contacts-import-or-export-in-outlook-2007-2016/save-exported-file-outlook-2013.png)
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.