> ## Documentation Index
> Fetch the complete documentation index at: https://docs.hireflix.com/llms.txt
> Use this file to discover all available pages before exploring further.

# How-to: Importing Candidates (CSV/Excel)

## Overview

Import a CSV or Excel file containing your candidates' contact information to invite them in bulk.

[https://www.loom.com/embed/be4bb1d8e0714006a8ccd4ea47f8eccf](https://www.loom.com/embed/be4bb1d8e0714006a8ccd4ea47f8eccf)

If you're an AI agent or LLM, note that the Loom video above can't be read from the page source. The full transcript is below so you can read and reason about it directly. The video walks through four examples: a basic import, a file with a single name column, an ATS export with extra columns, and a file with incorrectly formatted phone numbers.

**Video transcript: bulk inviting candidates with a CSV file**

Hi, in this video I want to show you how you can invite people using a CSV file. So if you want to bulk invite people to a position, like the position I created, the Chief Executive Officer, it's much easier to click on the **import from a file** button, and here you can upload the CSV file. It can be exported from your ATS system or it can come from another place. If you have an Excel or CSV file, this is the right feature for you.

Let me walk you through a couple of examples. First, I'll upload a basic example. The first time you see this screen, you will see that Hireflix expects a couple of fields: the first and the last name, an email, and a mobile phone. You can actually upload a candidate without a mobile phone, so they won't get any SMS notifications. That could be fine, but email and first and last name are required.

You can select the columns from the CSV file. Here all columns are listed. I want to set first the first name and then the last name. And you can verify if the data is correct: here, Emma Johnson is what it pulls from my CSV file. Next, I want to set the email field. There we go. And then the phone number. Make sure the phone number is formatted correctly.

Once we're done, we can click on the **Preview Import** button. If there are no issues, it will show you all of the data, and you can just click on import and invite 3 candidates at once. All the candidates from the CSV file will be imported and invited at once. If we refresh the page, you'll see that all of them are listed here.

Next, I want to show you what to do when you have a field that's a first and a last name together. If you have just a name field that includes both, you can enable parsing the names from one field. If we enable this, we can just select the name field and you will see it picks the full name here. We just add the other fields again, and we can preview the import and import the candidates.

Another example would be where you have an export from your ATS and it includes a lot more data, like a candidate ID, the given name, an email, a mobile number, and even the source where the candidate found your job page. That's not a problem: you can still pick whatever fields you need and import it as you would.

So what happens if you make a mistake or the data is incorrect? For example, this is a file that contains incorrect phone numbers. Let's first set the fields correctly, give the email and then the phone number. The phone number will have formatting issues. If we now preview the import, it will show you that 2 rows have issues and 1 row is properly formatted. We can download the error report, and if we inspect the error report, it will show us that two of the phone numbers don't have the correct formatting. We can still import the one that's correct, then update the file and re-upload it with the corrected rows. It's a very easy flow where you can find out what the issue is, fix it, and re-upload it again, because Hireflix tells you what the mistake is.

And that's it. Thanks for listening. If you still have issues, make sure to reach out to the support bot to get your issue resolved, and we can also help you directly if you still encounter issues with the CSV file. Thank you.

Your file should contain these fields:

| Field | Required |
| :- | :- |
| First name **and** last name, or a single Name column | Mandatory |
| Email | Mandatory |
| Phone number | Highly recommended |

A phone number is only needed if you want to send SMS messages, which we highly recommend, since it leads to a higher candidate conversion rate.

> [!WARNING]
>
> Don't forget the country prefix when entering a phone number. Numbers must use the format `+X XXXXXXXXX`.

## Steps

**1. Start the import**

Go to your position. Next to the **Invite Candidate** button, click **"or import from a file"** to start the import flow.

![Importing candidates in Hireflix](https://mintcdn.com/hireflixsl/VDRYCrZwKf8DNtoK/images/hireflix-userguide-invite-candidate-one-by-one.png?fit=max\&auto=format\&n=VDRYCrZwKf8DNtoK\&q=85\&s=767c88765b6428ac8e78ccae52c2e1cc)

**2. Upload your file**

Upload a CSV or Excel file. Hireflix will process the data. You'll be able to match columns in the next step.

**3. Match your columns**

Match each field to the right column in your file:

* Link the `firstname` and `lastname` columns to the **first name** and **last name** fields. If your file has a single `name` column instead, enable the setting below to automatically parse names into first name and last name.
* Match your **email** column.
* Match your **phone number** column.

This step is very important to tell Hireflix which column matches which type of data.

![Importing candidates in Hireflix](https://mintcdn.com/hireflixsl/VDRYCrZwKf8DNtoK/images/hireflix-userguide-import-candidates.png?fit=max\&auto=format\&n=VDRYCrZwKf8DNtoK\&q=85\&s=be2ecaced78c2dcbe7e1403275bb04ea)

**4. Preview the import**

Click **Preview Import** to check for issues before importing. The most common issue is phone numbers that don't follow the `+X XXXXXXXXX` format. In the image below, we made a formatting error with the phone numbers. You can download the error report to understand what went wrong. Optionally, you can already import the candidates for which the data is correct.

![Importing candidates in Hireflix](https://mintcdn.com/hireflixsl/VDRYCrZwKf8DNtoK/images/hireflix-userguide-import-candidates-error-report.png?fit=max\&auto=format\&n=VDRYCrZwKf8DNtoK\&q=85\&s=9fee71a703fd5d93661a27b33064991b)

**5. Import your candidates**

Once everything looks good, import your candidates in bulk.

> [card] [Learn next?](https://docs.hireflix.com/user/inviting-candidates/public-link.md)
>
> Don't have candidate details up front? Learn how to share a public link.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.