CSV file upload requirements in Recruiter

LinkedIn Recruiter admins can manage users in bulk via the CSV upload feature in the LinkedIn Admin Center under User & license management. The CSV files must include specific column headers and acceptable values in order to upload successfully.

The column headers include user information and license and permission types. The value entered under the user information columns updates the information on user enterprise profiles. This doesn’t affect their personal LinkedIn profile.

The value entered under the license and permissions columns will determine the action taken for each user.

Assigning an Active value means new users will receive an email to activate their license. For existing users, it means their new license and permissions are detected and changed in Recruiter.
Assigning an inactive value means new users means aren’t assigned the specific license or permission. For existing users, it means their license and permissions are removed in Recruiter.

The chart below shows the column headers and the acceptable values you can use. It also provides a quick description of each column.

Here's a tip

The column header description shouldn’t be included in the CSV file.

COLUMN HEADER	COLUMN HEADER DESCRIPTION (DON’T INCLUDE IN CSV FILE)	ACCEPTABLE VALUE	COLUMN REQUIRED ON THE CSV FILE
User Information
invited_email_address	User's work email address	A valid email address (for example “john.doe@test.com”)	Yes
preferred_first_name	User's first name	John	No
preferred_last_name	User's last name	Doe	No
unique_user_id	User’s Employee ID on their enterprise profile in Account Center, it must be unique within the same account	An alphanumeric ID (for example“ID12345”)	No
department_name	Department user is associated to	An alphanumeric value (for example “Finance”)	No
start_date	User’s start date		No
manager_primary_email_address	Manager’s work email address	A valid email address (for example “jane.doe@test.com”)	No
job_function	User’s job function	An alphanumeric value (for example “Accounting”)	No
work_phone_number	User’s work phone number	A valid phone number (for example “650-687-3600")	No
job_level	User’s job level	An alphanumeric value (for example “Associate”)	No
mobile_phone_number	User’s mobile phone number	A valid phone number (for example “650-687-3600")	No
work_title	User’s work title	An alphanumeric value (for example “Accountant”)	No
worker_status	User's working status	active or inactive	No
manager_unique_user_id	Manager’s Employee ID on their enterprise profile in Account Center	An alphanumeric ID (for example“ID123456”)	No
worker_type		An alphanumeric value (for example “full-time”)	No
country_code	User’s country code	An alphanumeric value (for example “US”)	No
profile_description	Allows you to store additonal user details	An alphanumeric value (for example “Member of UK Teach Recruiter Team”)	No
groups	Allows you to add or remove groups	An alphanumeric value (for example “Recruiters, UK Users, Tech Group”)	No
Licenses and Permissions
project_creator_user_license	Gives users the Hiring Project Creator license	active or inactive	No
recruiter_searcher	Gives users the Recruiter Searcher permission	active or inactive	No
account_center_admin	Gives users the Account Center admin permission	active or inactive	No
product_settings_admin	Gives users the Product Settings admin permission	active or inactive	No
public_notes_viewer	Gives users the Public Notes Viewer permission	active or inactive	No

In the following example, John Doe and Jane Doe were assigned Basic User licenses without permissions. The Excel file is saved as Comma Delimited or Comma Separated Value (.csv).

A	B	C	D	F
invited_email_address	preferred_first_name	preferred_last_name	unique_user_id	basic_user_license
john.doe@example.com	John	Doe	ID12345	active
jane.smith@example.com	Jane	Smith	ID12347	active

invited_email_address, preferred_first_name, preferred_last_name, unique_user_id, basic_user_license

john.doe@example.com, John, Doe, ID12345, active

jane.smith@example.com, Jane, Smith, ID12347, active

Recruiter Role	License + permission value to use to assign or edit role
Recruiter Role	project _creator _user _license	collaborator _user _license	account _center _admin	product _settings _admin	recruiter _searcher	public _notes _viewer
Recruiter User	Active	Inactive	Inactive	Inactive	Active	Active
Recruiter Admin	Active	Inactive	Active	Active	Active	Active
Hiring Manager	Inactive	Active	Inactive	Inactive	Inactive	Inactive
Dashboard Manager Admin	Active	Inactive	Active	Active	Inactive	Inactive

CSV file upload requirements in Recruiter

Here's a tip

Related tasks

Learn more