How to Import Candidates from CSV

Import candidate data from spreadsheets into 100Hires with column mapping and error checking.

How to import

1. Click Add Candidates in the header
2. Select Import from CSV File from the dropdown
3. Drag and drop your CSV file

Direct link: Import from CSV

Import steps

Step 1: map columns

Match your CSV columns to 100Hires profile fields:

1. Select the 100Hires field for each CSV column
2. Skip columns you don't want to import
3. Standard fields: First name, Last name, Email, Phone
4. Custom profile fields are also available

Step 2: review errors

The Errors tab shows:

• Missing required information
• Invalid email formats
• Duplicate entries
• Other data issues

Fix errors in your CSV and re-upload, or proceed with valid rows only.

Step 3: review changes

If your CSV contains 100Hires candidate IDs:

• The Changes tab shows what will be updated
• Review proposed changes before confirming
• Useful for updating existing candidates in bulk

Step 4: assign to job

Optionally assign imported candidates to a job:

1. Select a job from the dropdown
2. Choose a pipeline stage
3. The system automatically assigns all imported candidates

Step 5: complete import

Click Finish to create the candidates.

CSV format tips

• Include a header row with column names
• Use UTF-8 encoding for special characters
• Use comma as delimiter
• Wrap text containing commas in quotes

Example CSV structure

First Name,Last Name,Email,Phone,LinkedIn
John,Smith,john@example.com,555-1234,linkedin.com/in/johnsmith
Jane,Doe,jane@example.com,555-5678,linkedin.com/in/janedoe

Adding source tags

During import, add a source to track where candidates came from:

1. Complete the import
2. Select all imported candidates
3. Use the Sources bulk action to add a source tag

Updated on: 19/12/2025