List of Import Contact Field Names for Outlook.com Using CSV
When importing a file into Outlook.com via the Outlook.com web interface, you do not have the option to select which fields to import or map fields contained in the CSV file against corresponding fields in an Outlook.com contact item. The field names used in the CSV file are required to be labeled according to what the web import function expects.
The following is a complete list of contact field names exported from an Outlook.com and are the names that are required when importing Outlook.com “People” (contact) data. However, it should be noted that just because a field is included, does not mean that the field either exists or data is either exported or imported for it. The list is provided here in its entirety purely for information purposes since changes can occur over time in terms of what fields may appear in the Outlook.com web interface
The first (header) row in the CSV file
“Title”,”First Name”,”Middle Name”,”Last Name”,”Suffix”,”Company”,”Department”,”Job Title”,”Business Street”,”Business City”,”Business State”,”Business Postal Code”,”Business Country”,”Home Street”,”Home City”,”Home State”,”Home Postal Code”,”Home Country”,”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”,”Account”,”Anniversary”,”Assistant’s Name”,”Billing Information”,”Birthday”,”Business Address PO Box”,”Categories”,”Children”,”Company Yomi”,”Directory Server”,”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”,”Gender”,”Given Yomi”,”Government ID Number”,”Hobby”,”Home Address PO Box”,”Initials”,”Internet Free Busy”,”Keywords”,”Language”,”Location”,”Manager’s Name”,”Mileage”,”Notes”,”Office Location”,”Organizational ID Number”,”Other Address PO Box”,”Priority”,”Private”,”Profession”,”Referred By”,”Sensitivity”,”Spouse”,”Surname Yomi”,”User 1″,”User 2″,”Web Page”
The fields from the above row listed individually for easier reference
Title
First Name
Middle Name
Last Name
Suffix
Company
Department
Job Title
Business Street
Business City
Business State
Business Postal Code
Business Country
Home Street
Home City
Home State
Home Postal Code
Home Country
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
Account
Anniversary
Assistant’s Name
Billing Information
Birthday
Business Address PO Box
Categories
Children
Company Yomi
Directory Server
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
Gender
Given Yomi
Government ID Number
Hobby
Home Address PO Box
Initials
Internet
Free Busy
Keywords
Language
Location
Manager’s Name
Mileage
Notes
Office Location
Organizational ID Number
Other Address PO Box
Priority
Private
Profession
Referred By
Sensitivity
Spouse
Surname Yomi
User 1
User 2
Web Page
Category: Import/Export
