How do I add multiple / import many candidates?

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

There are two options for adding multiple candidates at once

1) Email

Attach resumes to an email to lead@hire.lever.co or applicant@hire.lever.co. For detailed instructions, go to Adding candidates via email. The limit is 15 resumes per email message.

 

2) CSV Request

Create a spreadsheet using this template, shoot us a message with your spreadsheet (saved in a CSV format), and we’ll help you with the import!

Please note: CSV files must meet the following format requirements:
  1. CSV files must be provided in a comma-delimited format. Semi-colon and other delimiters are not acceptable
  2. File names must be provided without spaces or special characters. Allowed characters are: a-z, 0-9, underscores (_) and dashes (-)
  3. Files must be limited to 55,000 rows

Please note: We recommend filling out the following columns:

  • Full name (Required)
  • Email
  • Lever Posting URL (if assigning the candidate to a posting)
  • Stage
  • Sources
  • Origin (choose one from this fixed list: Applied, Sourced, Referred, University, Internal, Agency)

A couple of other items to note:

  • Each new row will create a new candidate opportunity in Lever.
  • Preserve all column headings.
  • If you’d like resumes attached to the profiles, send a zip file with the PDF and Word files along with the spreadsheet.
  • Separate multiple links with a comma followed by a space.
  • Separate multiple email addresses with a comma, no space.
  • Separate multiple tags with a comma, no space.
  • Separate multiple sources with a comma, no space.
  • Be sure to name things exactly. For example:
    1. “New Lead” for Stage, not “Lead”
    2. “JohnSmith_Resume.pdf” for Resume Filename, not “John Smith resume”
  • Lever relies on email addresses to catch duplicate profiles. Make sure the Email column is accurate, so the CSV uploader can check against existing profiles.
  • Not sure what the difference is between sources and origin? Check out this help article.
  • Want to mark a note secret? In the "IsSecretNote" column, write “yes”. Keep it lowercase and don’t use spaces.

Here is a breakdown of all the columns included in our CSV template:

Lever Profile ID The ID can be located in the URL when viewing a candidate. Add the ID if you wish to merge this data with an existing profile
Full Name Specify the First and Last name in one column.
Email Specify the candidate's email and add commas between email if there is more than one.
Date Added Specify when the candidate profile was created. The format must be a string representing an RFC2822 or ISO 8601 date or an EPOCH timestamp of milliseconds. The year for all dates must be greater than 1980. Note: If no data is passed in or if the data is invalid, the date added will be set to the current time of the import.
Stage Specify a stage name that matches a stage which already exists in your pipeline.
Archive Reason Specify an archive reason name that matches an archive reason which already exists in your account. The candidate will be archived from the “New Lead” stage if the stage field is blank.
Archive Date Specify when the profile was archived. The format must be a string representing an RFC2822 or ISO 8601 date or an EPOCH timestamp of milliseconds. The year for all dates must be greater than 1980. *Note: If no data is passed in and there is an associated archive reason or if the data is invalid, the date added will be set to the current time of the import.
Sources Specify a list of source names which are separated by commas. If the source name does not exist in the account, it will be created with the specified capitalization. Note: Capitalization matters and new sources will be created if capitalization differs from the existing source. A list of your sources can be seen in your settings here: https://hire.lever.co/settings/mergeTagsSources
Origin Specify an origin of either Applied, Sourced, Referred, Agency, University. The default origin is Sourced if none is added.
Tags Specify a list of tag names which are separated by commas. If the tag name does not exist in the account, it will be created with the specified capitalization. Note: Capitalization does matter and new tags will be created if capitalization differs from the existing tag. Your existing tags can be seen in your settings here: https://hire.lever.co/settings/mergeTagsSources
Phone Specify a list of the candidate's phone numbers which can be separated by commas. Phone number formatting is irrelevant.
Location Specify a single location for the candidate.
Links Specify a list of links which are separated by a comma and a space. Do not leave a comma after the last link. These links are usually for LinkedIn profiles, Portfolios, ect.
Referrer Specify the full name of the referrer of the full referrer of the user which should own the profile. If none is set, the importer will look at any job posting being applied to the profile and use that as the owner, if one exists on the job posting. *Note: Capitalization does not matter and extra spaces before or after the email address are removed.
Resume Filename This column should only be used if you will be performing a corresponding resumes import. Specify a list of filenames of the resume, separated by commas if multiple; resumes nested within several folders are supported. For a nested resume, the folder should be denoted by a forward slash `/` followed by the folder name (i.e. /resumes2014/SadkaResume.pdf).
Company Specify a list of previous companies the candidate worked at separated by spaces. If left blank, the associated resume data might be parsed here.
Owner Specify the full name or email address of the Lever user which should own the profile. If none is set, the importer will look at any job posting being applied to the profile and use that as the owner, if one exists on the job posting.
Lever Posting URL Specify the URL of the desired posting. The importer can recognize internal and external postings, as well as active or closed postings. Note: For situations where you have candidates tied to multiple job postings, you would have to have a separate line for each posting, with the candidate name/email the same
Posting Owner Specify the full name or email address of the Lever user which should own the application being added to the profile. If none is set, the importer will set the existing owner of the posting as the owner of the application.
Posting Hiring Manager Specify the full name or email address of the Lever user which should be the hiring manager of the application being added to the profile. If none is set, the importer will set the existing hiring manager of the posting as the hiring manager of the application.
Consent Status Specify if the candidate has provided or revoked consent through the application for those covered under GDPR. The values can either be "provided" or "revoked".
Consent Updated At Specify the date when candidate's provided consent was last updated. The format must be a string representing an RFC2822 or ISO 8601 date or an EPOCH timestamp of milliseconds. The year for all dates must be greater than 1980.
Consent Expires At Specify the date for when candidate's provided consent expires. The format must be a string representing an RFC2822 or ISO 8601 date or an EPOCH timestamp of milliseconds. The year for all dates must be greater than 1980.
DateNote-0 Specify the timestamp on the date. The format must be a string representing an RFC2822 or ISO 8601 date or an EPOCH timestamp of milliseconds. The year for all dates must be greater than 1980.
UserNote-0 Specify the full name or email address of the user who wrote the note. If none is set, the user will appear on the note without a name and a grayed-out avatar. *Note: Capitalization does not matter and extra spaces before or after the email address or name are removed.
IsSecretNote-0 Specify `yes` if the note should be marked as secret. You can learn more about secret notes here: https://help.lever.co/hc/en-us/articles/115004755143-How-do-I-add-a-secret-note-to-a-candidate-s-profile-
Note-0 Any content added in the notes column will be added to the candidate profile as a note.
Was this article helpful?
3 out of 6 found this helpful