Can I import multiple candidates from a .csv file?

JobScore supports the ability to bulk-import candidates into your account from a .csv file.  This interface is essentially the same as bulk importing resumes, but instead of selecting a folder of compressed, zipped-up resumes, you select a .csv file.

When importing candidates from .csv files a first name and last name must be present for each row. If no name is found the entire row will be skipped.

JobScore does not support .xls or .xlsx files.  If your file is in one of these formats please open it in Microsoft Excel or Google Sheets and save it in the .csv format.

JobScore recognizes 3 .csv formats:

LinkedIn Connections Export:

This is the format created when individuals export their own connections from LinkedIn. 

Zoominfo Contacts Export:

This is the file format created when contacts are exported from ZoomInfo.

JobScore Import Format:

This is a JobScore-specific format used to import candidates from any other source. Download a sample file here (or use the link at the bottom of this article).  Once your data is structured correctly, save it in the .csv format to load it into JobScore.  Here's how this format works:

The following columns are required, if you remove or change these columns the import will fail:

• First Name
• Last Name
• Email

The format supports the following additional columns:

• Phone
• Mobile Phone
• Work Email
• Address 1
• Address 2
• City
• State or Region
• Country
• Postal Code
• LinkedIn URL
• Personal Website
• Current Employer
• Current Job Title
• Tags (comma-separated)

All of the supported fields are included in the sample file. To import additional fields other than first name, last name, and email the first row of each column must have the exact matching text to be recognized and imported. 

So, for instance, if you have a column with "Address" or "Street Address" it won't work, only "Address 1" and "Address 2" will be recognized and imported.

We recommend starting with your original file, deleting any columns you won't need, and renaming the column headers (first row) to match the JobScore labels.

If you plan to load a large list of candidates, we strongly recommend running a small test import of 1-5 candidates to ensure everything looks right before importing a large list of candidates.

JobScore supports .csv files with up to 10,000 rows. If you need to load more than 10,000 candidates you will need to break your .csv up into multiple files and upload them separately.

When loading candidates you can only assign them to 1 job, 1 set of tags, and 1 source.  If you need to decorate candidates with different jobs, tags, and sources, please separate your data into multiple .csv files and perform multiple uploads.

Duplicate Detection & Resolution

When loading candidates by .csv duplicates are detected based on an exact match of an email or LinkedIn URL.  When duplicates are detected:

• All contact information about the candidate is updated to use the values in your .csv file.  This means that existing information on the candidate’s record will be overwritten. Overwritten data is stored in a “Candidate Edited” Event in the history if you need to access it later (so there is no data loss).
• If an employer and job title are present, they are added to the candidate's work experience with the "present" end date.
• The candidate is assigned to the selected job (if they are not already assigned)
• Tags are added (if they are not already present)
• The candidate's source is NOT updated