Importing Candidate Lists
Importing a list of candidates from a previous or current ATS is quickly done in PivotCX. We've created a 5 step process to help break it down. Importing candidates makes it easier to engage with candidates as soon as possible.
Here are several reasons you may want to start importing lists of previous candidates to Pivot CX.
Lists can help you re-engage with previously interested candidates
In PivotCX, you can engage with candidates through texting which has an eight times higher open rate than email.
Lists are an excellent way to keep a constant flow of candidate interaction.
How to Import a List
Create an Excel sheet of candidates with the appropriate fields and headers.
Column | Required | Example | Type | Notes |
first_name | | Joe | text | |
middle_name | | | text | |
last_name | ✓ | Jobseeker | text | Last name or full name is required |
full_name | | text | You can optionally provide a full name and Pivot will seperate the name into the correct fields when we import it. |
phone | ✓ | +15552223333 | phone number | Must be a valid phone number format. We recommend using e164 format: +13171231234. |
opt_in | ✓ | TRUE | true/false | Phone Opt In as provided by contact. |
email | ✓ | joe@jobseeker.com | text | Email must be valid. |
update_existing | | TRUE | true/false | Update exsiting contacts. |
create_new | | TRUE | true/false | Create a new contact if this one does not exist. |
street | | 555 Main Street | text | Contact street address |
city | | Indianapolis | text | Contact city |
state | | IN | text | Contact state |
country | | USA | text | Contact country |
postal_code | | 46077 | text | Contact postal code |
source | | Indeed | text | The specific place/website from which your candidate came. |
medium | | Job Board | text | The medium of the source. E.g. Job Board, web, print, direct mail, ATS, CRM, etc... |
content | | Awesome Sales Job | text | Position name on the requisition. |
campaign | | 2023 Job Boards | text | Name given to your import for easier sorting later on within PivotCX. |
location | | Lubbock, TX USA | text | Location of the job or attribution. Locations can be corrected to ensure consistency. |
external_contact_id | | 1123 | text | ID from your ATS or crm for a contact |
external_job_id | | | text | Job id, if different than requisition ID |
req_id | | C1000 | text | Job requisition ID |
attribution_type | | | Choices | The type of attribution: <blank> for job apply lead form keyword text import enhancement signup other api user |
contact_list_id | | 1322 | number | ID of PivotCX list you'd like to add the candidate to. Used for curated lists only. |
notes | | Ten years of experience in manufacturing. Only Part-time | long text | Additional information included in the import. |
Save this excel sheet as an xlsx file.
On the dashboard, click on the Candidates/Contacts tab.
Access the Candidates Tab from the Main Menu on the left-hand sideClick on the Import button in the top right hand corner of the Candidates Tab.
Import Candidates with the button at the top right-hand corner.
Click import and drop your xlsx file in the box

The Importing Tool supports smaller lists of candidates. If you need assistance with a more sizeable import, don't hesitate to contact our support team via email at
help@pivotcx.io, and we can assist you in adding your list.
Related Articles
Adding Filtered Candidates to a List
After applying filters to select candidates you want to segment out, click on Actions on the top left of the grid to “Add filtered Candidates to list.” Don’t forget to give your new list a new name and click “Add.” You’ll automatically move to the ...
Error: Problem creating contact list when importing spreadsheet
If you get a "problem creating contact list" when importing a spreadsheet, it usually means that there is a problem with the spreadsheet. Here is how to check your spreadsheet for problems: Check the headings. If you have an extra heading on one ...
Filtering the Candidates Tab in PivotCX
PivotCX's Candidate tab provides a snapshot of your past candidates' contact information and info from the applications they have submitted for your jobs. One of the most powerful ways to leverage PivotCX is by creating remarketing blasts or ...
Bulk Assign Candidates
You may already be familiar with our ^assign feature to assign a candidate's conversation to a member of your PivotCX team or yourself. Assigning helps organize conversations and distribute the workload to different resources. While this feature is ...
How to Open a Conversation
There are multiple ways to go to a specific conversation to start chatting with a candidate: When you are viewing the Deliveries Tab, Messages Tab, Candidates Tab, or Conversation Tab, clicking on a Chat Bubble next to a contact's phone number or ...