Adding multiple candidates to Lever in bulk via CSV import

Follow
Available for User roles Super Admins and Admins or
Users with a Super Admin or Admin cc'ed on the request
Packages Select Lever packages

If you have a repository of candidates that you need to add into Lever, there are two methods for bulking importing candidate profiles - email forwarding and CSV import. This article will cover how to add candidates in bulk via the CSV import method. For instructions on how to bulk import candidates using the email forwarding method, refer to the following support article:

This method requires you to fill out a templated CSV spreadsheet that you then send to our Support team for import. As long as the information on the spreadsheet is formatted correctly, the corresponding candidate profiles will be generated in your organization's Lever environment upon import. 

Steps for adding multiple candidates to Lever via CSV import

To start, download the templated CSV spreadsheet attached at the bottom of this article.

Next, open the spreadsheet. Before getting started, read the following important considerations and keep them in mind as you fill out the spreadsheet:

  • Do not change the file format of the spreadsheet. The CSV file that you provide must be in a comma-delimited format. 
  • The file name must be composed solely of letters,  numbers, underscores (_) and/or dashes (-). Do not include any spaces or special characters in the file name.
  • Do not add, remove or modify any of the column headings in the spreadsheet.
  • Each row in the spreadsheet will generate a new candidate Opportunity in Lever. The number of rows in the spreadsheet must not exceed 5000.

 

If you wish to attach resumes to the candidate Opportunities being imported to Lever, include them in a .zip file along with the CSV spreadsheet. Resumes must be in either a Word or PDF file format.

In the table that follows, you will find a description of the fields corresponding to each column in the spreadsheet. Please read this chart carefully, so you understand how the values in each cell must be formatted in order to import correctly into Lever. 

Column Header Field Description

Lever Opportunity ID

This is a string of characters that is visible at the end of the URL when viewing a candidate's Opportunity in Lever. It serves as a unique identifier for each Opportunity. Only input an ID to this field if you wish to add an Opportunity to an existing candidate in Lever.
Full Name Input the candidate's first and last name. This field is required for all candidates being added via CSV import.
Email Input the candidate's email address. If the candidate has multiple email addresses, separate them using commas with no spaces in between. Be sure that the email address that you enter is accurate, as Lever cross-references email addresses to catch duplicate profiles.
Date Added Input a creation date for the Opportunity. Only dates after 1980 can be accepted. The date must be formatted as Unix time in milliseconds (click here to jump to instructions on how to make this conversion).
Stage If you would like the generated Opportunity to enter your pipeline at a specific stage, specify the stage in this field. Only input the names of stages that exist in your pipeline and ensure the name matches exactly. If the stage is left blank on the spreadsheet, the generated Opportunity will be added to the New Lead stage of the pipeline.
Archive Reason If you are adding an Opportunity that that has already been disqualified (for historical and/or reporting purposes), add them to your archive by specifying an archive reason in this field. Only input archive reasons that currently exist in your archive and make sure the name matches exactly. If you input an Archive Reason but leave the Stage field blank, the generated Opportunity will be archived from the New Lead stage upon import.
Archive Date If you are adding an Opportunity that that has already been disqualified (for historical and/or reporting purposes), specify the archive date in this field. Only dates after 1980 can be accepted. The date must be formatted as Unix time in milliseconds (click here to jump to instructions on how to make this conversion). If you input an Archive Reason but leave this field blank, the Archive Date will be set as the time of import.
Sources Sources specify where an Opportunity came from, such as LinkedIn, Indeed, or a job fair. If you are adding multiple sources for an Opportunity, separate them using commas with no spaces in between. If a specified source does not match any of the sources you already have listed in Lever, the source will be added upon import. Note that source-matching is case sensitive (e.g. "LinkedIn" and "linkedin" would be marked as different sources). To see the list of sources you currently have in Lever, navigate to Settings > Sources and tags.
Origin The origin of an Opportunity specifies how it was obtained. Input one of six pre-defined Origins in Lever: Sourced, Applied, Referred, University, Internal, or Agency. At this time, it is not possible to add custom Origins to Lever. If this field is left blank, the generated Opportunity will be listed with an origin of "Sourced" upon import.
Tags Tags are pieces of metadata that you can associate with an Opportunity so you can easily find and/or report on it later using search filters. If you are adding multiple tags to an Opportunity, separate them using commas with no spaces in between. If a specified tag does not match any of the tags you already have listed in Lever, the tag will be added upon import. Note that tag-matching is case sensitive (e.g. "Google" and "google" would be marked as different tags). To see the list of tags you currently have in Lever, navigate to Settings > Sources and tags.
Phone Input the candidate's phone number. If adding multiple phone numbers, separate them using commas.
Location Input a single location for the candidate.
Links Input links to additional web pages that you wish to associate with the candidate's Opportunity such as their LinkedIn profile or a digital portfolio of their work. If adding multiple links, separate them using commas with spaces in between. Do not leave a comma after the last link.
Referrer Input the full name of the referrer that should be associated with the Opportunity. 
Resume File Only fill in this field if you are performing a bulk resume import import in conjunction with the CSV import. Specify the exact file name of the resume that you wish to associate with the Opportunity. For resumes nested within folders in the .zip file, include the folder name before the file name, preceded and followed by a forward slash (e.g. /resumes2021/SadkaResume.pdf). If you wish to attach multiple resumes to a candidate, separate the file names using commas.
Company Input previous companies the candidate worked at, separated using spaces. If this field is left blank, previous companies listed on the candidate's resume may be parsed into the candidate profile upon import.
Owner Input the full name or email address of the Lever user that should be the owner of the Opportunity. This field is not case sensitive. Extra spaces preceding or following an email address will be removed. If this field is left blank, the owner of the associated job posting (see below) will be added by default upon import.
Lever Posting URL Input the URL for the job posting you wish to associate with the Opportunity. Lever will automatically identify whether the posting is external, internal, active, or closed. Candidates associated with multiple postings need to be added as a separate row (or rows) on the spreadsheet (one row per associated posting), keeping their full name and email address the same on the added rows. 
Posting Owner Input the full name or email address of the Lever user that owns the associated posting. This field is not case sensitive. Extra spaces preceding or following an email address will be removed.
Posting Hiring Manager Input the full name or email address of the Lever user that is the hiring manager for the associated posting. This field is not case sensitive. Extra spaces preceding or following an email address will be removed.
Consent Status Only fill out this cell if the Opportunity being added pertains to a candidate that is covered by GDPR. If the candidate has granted their consent to the use of their data, type "provided" into this field. If the candidate has not provided consent, type "revoked" into this field.
Consent Updated At Only fill out this cell if the Opportunity being added pertains to a candidate that is covered by GDPR. Input the date that the candidate's consent status was last updated. Only dates after 1980 can be accepted. The date must be formatted as Unix time in milliseconds (click here to jump to instructions on how to make this conversion). RFC 2822 and ISO 8601 date formats are also accepted for this field.
Consent Expires At Only fill out this cell if the Opportunity being added pertains to a candidate that is covered by GDPR. Input the date that the candidate's consent status expires. Only dates after 1980 can be accepted. The date must be formatted as Unix time in milliseconds (click here to jump to instructions on how to make this conversion). RFC 2822 and ISO 8601 date formats are also accepted for this field.
DateNote-0 Input a creation date for the Note. Only dates after 1980 can be accepted. The date must be formatted as Unix time in milliseconds (click here to jump to instructions on how to make this conversion). RFC 2822 and ISO 8601 date formats are also accepted for this field.
UserNote-0 Input the full name or email address of the Lever user that authored the Note. If this field is left blank, the author of the Note will appears as unlisted with a greyed out avatar upon import.
IsSecretNote-0 If you wish for the Note to be marked as secret, type "yes" into this field (all lowercase, no spaces). To learn more about secret notes, click here.
Note-0 Input the content of the Note.

 

Although these fields appear as separate columns on the spreadsheet, they appear as a single Note on a candidate's Opportunity upon import to Lever. To add multiple Notes to an Opportunity, fill out the corresponding group of cells. The number appended to the end of each column header indicates which Note the field will correspond to (e.g. the values in cells from the columns with "-0" will compose one Note, those in cells from columns with "-1" another Note).

Generating a Unix timestamp

To generate the timestamp for a specific date, click here to open a Unix converter. Input the date you wish to convert into the appropriate fields, click Human date to Timestamp and copy the value next to Timestamp in milliseconds:

Example of a date and time converted to a Unix timestamp in milliseconds

Was this article helpful?
5 out of 9 found this helpful