Skip to main content
All CollectionsThe Leads TabAdd Candidates
Add Candidates through CSV Import
Add Candidates through CSV Import

How to add candidates using a CSV file

Perry Santiago avatar
Written by Perry Santiago
Updated over a month ago

If you need to add a batch of hundreds or even thousands of candidates to a campaign, the best option for you is to use the Import CSV feature. Compared to the Manual Add option, this method of adding candidates is more helpful when uploading candidates in bulk, as you’ll be able to add candidates to a folder inside a campaign with just one file.

Here's a quick video guide by Perry to help you with adding candidates via CSV Import.

To use this feature, start setting up your CSV by downloading the template inside Talkpush. A CSV is a delimited text file that uses a comma to separate values. Any other character (ex., semicolon) will cause an error with the uploading.

You can add additional columns to include Candidate Attributes and delete the unnecessary columns you will not need in their profile. These candidate attributes will be added to the profile and should fill in the existing custom candidate attributes that were previously added to the campaign.

Make sure columns are in the right format. Remove unnecessary formatting. Avoid extra spaces, special characters, and typos. Make sure the following are in the right format:

Moreover, note that you need to use these specific row headers for the following candidate information:

  • First Name

  • Last Name

  • Name (for candidate's whole name)

  • Email

  • Country Code

  • Phone Number

  • Location

The column title in the CSV must match the “Key” of the candidate attribute you want to upload.

For example:

Key: Date_of_Birth.
Column title: Date of birth.

Here’s how to start importing these leads inside the CRM:

1. Click the Leads Tab drop-down button and select Add Candidates, then Import CSV.

2. Select the Campaign, specify the source and then choose the CSV file to Upload; then click Continue.

💡Note that recording uniform sources for your candidates will help track your records and for analytics.

3. Confirm the import by clicking on Yes.

🚀 Make sure to upload the CSV file successfully by reading through the complete instructions available on the Import CSV page.


Q: My CSV import has Failed. What should I do?

A: Open and clean your CSV file by doing the following:

a. Check if it has the correct header names.

b. Remove special characters like ñ, ^, $, +, and ;

c. Delete empty columns.

d. Make sure all candidates have first and last name values.

e. Check if each column has the correct values (e.g., email and phone numbers do not interchange).

Q: The import has been in progress for several hours. What can I do to speed up the upload?

A: You can cancel the import, open your CSV file, and make the above recommendations. Then, try to upload the file again. Note that larger files take some time to upload.

If cleaning the CSV file did not improve the waiting time, you may contact us through our live chat support.

Q: Can I upload my second CSV file even though the first file is still in progress?

A: Yes, you can. The second CSV file will remain in Queued status until the first file has been processed.

Q: How can I ensure to upload the correct format?

A: We suggest that you use Google Sheets to save the CSV file that you will upload. This will less likely encounter errors as the CSV file of Google Sheets can detect symbols (such as ñ and any other symbols), unlike Excel, which does not.

Here are the steps you can follow when using Google Sheets to create a CSV file:

  1. Download the CSV template from Talkpush

  2. Open Google Sheets > click File > click Open > and upload the CSV template

  3. Fill the cells under each column with the necessary data (you may select which column to include)

  4. Then click File > click Download > and click Comma Separated Values (.csv)

e. Upload to Talkpush the downloaded CSV file

Q: How long does it take for the applications to reflect in the Leads Tab after the upload?

A: Up to 30 seconds.

Q: Can I add candidates via CSV without email?
A: Yes, you can, as long as first name, last name, and mobile number are present.


Did this answer your question?