CSV file format for CSV data provider

This document will describe the CSV format, expected by the CSV data provider. The exact same format is used for the CSV file upload feature. 

The format is flexible: 

• The first row must contain the column headers
• Column headers are case insensitive
• Columns can appear in any order
• The "Email" column is mandatory
• Unknown columns can appear and will be ignored
• Rows that cannot be parsed are ignored
• The fields can be separated with a number of predefined separators
• The field "Keywords" can contain a list of keywords. These must be separated by another separator than the one used for the columns in the CSV file
• The field "Skills" can contain a list of alternating skill names and skill proficiencies. The skill proficiency must be a number from 1 to 10. These must be separated by another separator than the one used for the columns in the CSV file 

Fields/Columns 

Any field can be empty. Empty fields are treated as if the value is not set. Importing CSV data with empty fields will not overwrite existing data with blank. 

In below table, the "Edit field name" column shows the respective name of the input field on the Configuration Manager user edit page and the section, the field is found in. Example: "Home address / Postal code" refers to section "Home address" and input field "Postal code".

Field name	Description	Edit field name
DisplayName	Display name e.g. Mogens Lykketoft	Display name
FirstName	First name e.g. Mogens	First name
LastName	Last name e.g. Lykketoft	Last name
Email	Persons's email address e.g. [e-mail]	Email
Initials	Person's initials e.g. ML	Initials
Alias	Alias of the person	Alias
Title	Job title e.g. CEO.	Job title
OfficeNumber	Office phone number	Endpoints / Office phone number
HomeNumber	Home phone number	Endpoints / Home phone number
MobileNumber	Mobile phone number	Endpoints / Mobile phone number
MicrosoftTeamsNumber	Microsoft Teams number	Endpoints / Microsoft Teams number
MicrosoftTeamsUri	Microsoft Teams URI	Endpoints / Microsoft Teams SIP URI
ShortNumber	Short number	Endpoints / Short phone number
CompanyName	Company name	Company address / Company name
OfficeName	Office name	Company address / Office name
CompanyOrganization	Organization name	Company address / Organization
CompanyStreetAddress	Company street name and number	Company address / Street address
CompanyPostalCode	Company postal code	Company address / Postal code
CompanyCity	Company city	Company address / City
CompanyCountry	Company country	Company address / Country
CompanyRegion	Company country's region	Company address / Region
CompanyStateProvince	Company state or province	Company address / State/province
Department	Department name e.g. Product Management	Company address / Department
Description	A description of the person	Description
Info	Additional information	Info
Keywords	A separated string of keywords (tags). Could e.g. be 'impatient person; Bad hearing'	Keywords
Note	Note on element	Note
ManagerFullName	Full name of element's manager	Company address / Manager's full name
ManagerEmail	Email of element's manager	Company address / Manager's email
AlternativePersonFullName	Full name of element's alternative person	Company address / Alternative persons full name
AlternativePersonEmail	Email of element's alternative person	Company address / Alternative persons email
HomeStreetAddress	Home street name and number	Home address / Street address
HomePostalCode	Home postal code	Home address / Postal code
HomeCity	Home city	Home address / City
HomeCountry	Home country	Home address / Country
HomeRegion	Home country's region	Home address / Region
HomeStateProvince	Home state or province	Home address / State/province
Skills	A separated string of alternating skill name and skill proficiency. Could e.g. be 'English;1;Greek;5'	Skills