> ## 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: Bulk Exporting Candidates to CSV

## Overview

You can export the data of multiple candidates in a position to a CSV file, which opens in Excel, Google Sheets, or Numbers. Use it to report on your hiring funnel, share scores with someone who doesn't use Hireflix, archive interview transcripts, or bring results into your own system.

You choose exactly which candidates to include, even across different stages, and which extra data to add to the file.

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

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 selects two candidates from different stages, walks through the export options, and opens the resulting CSV file.

**Video transcript: bulk exporting candidates to a CSV file**

Hi, this is Michiel from Hireflix, and in this video I want to show you how you can export candidates to a CSV file, so you can use it for analysis with AI or other tools.

First, let's go to our positions and select the position you want to export candidates from. For me, this is the Social Media Manager position. I have a couple of candidates across the different stages, and I can select one by clicking on the checkbox above the name. You can also select an entire stage, like Invited, by clicking on the stage's **select all** checkbox.

For now, I want to show you that you can select people across different stages. I have Ben selected from the Invited stage, and I want to select John from the To evaluate stage. So now I have 2 candidates selected, and you can see the count of 2 in the bottom bar as well. We can hit the **CSV export** button.

Here you can see you get a lot of options. You can turn off everything and still get a lot of default data exported. If you look at the docs, by default Hireflix exports the interview ID, the first name, last name, email, position name, the stage they're in, the invitation source, an external ID if you used an ATS system, and the overall team score.

We can also add a lot of extra options, like the position ID, the number of interview questions, or the time to complete the interview. This is not how long it took them to record the interview, but the time from receiving the invite until completing the interview. So it can take a couple of hours or a couple of days. It's sometimes a nice metric to have. You can also export scores per question, the transcripts per question, or all the transcripts at once.

I'll select a few, just to show you, and export the 2 candidates to a CSV file. Now we can open the file, and as you can see, the data has been exported: the interview ID, their name, their email address, the position name, the position ID that I added as an optional item, and the number of questions. A lot of the data is here.

This is very useful if you want to use it for analysis, or want AI to have access to it to find the best candidates for you. So this is how you export candidates to a CSV file.

## Steps

**1. Open the position**

Go to **Positions** and open the position that contains the candidates you want to export.

**2. Select candidates and click the CSV icon**

**(1)** Hover over a candidate and tick the checkbox in the top-left corner of their profile picture. You can select candidates across different stages in the same position.

To select **all candidates in a stage** at once, click that stage's tab (for example **Shortlisted**), then tick the empty checkbox next to the stage name. Want several stages in your export? Repeat this for each stage you want to include.

**(2)** The bar at the bottom of your screen shows how many candidates you've selected. Click the **file icon with the CSV label** to open the **CSV Export** popup.

![Selecting candidates and clicking the CSV export icon](https://mintcdn.com/hireflixsl/02VSqs2tyl0krcix/images/hireflix-userguide-bulk-export-csv-select.png?fit=max\&auto=format\&n=02VSqs2tyl0krcix\&q=85\&s=8f36f6be1575c37b5f52cc6940eea539)

**3. Choose extra data (optional)**

Turn on any extra data you want to include. All options are optional. If you leave them all off, you still get the [standard columns](#standard-columns).

![CSV export options](https://mintcdn.com/hireflixsl/02VSqs2tyl0krcix/images/hireflix-userguide-bulk-export-csv-options.png?fit=max\&auto=format\&n=02VSqs2tyl0krcix\&q=85\&s=53041832499ca6d9b6a62bef59a7f742)

**4. Export**

Click **Export**. Hireflix generates the CSV file and your browser downloads it.

## What's in the CSV

### Standard columns

Every export includes these columns, whatever options you choose:

| Column | Description |
| - | - |
| **Interview ID** | The unique ID of the candidate's interview in Hireflix. |
| **First Name** / **Last Name** | The candidate's name. |
| **Email** | The candidate's email address. |
| **Position Name** | The name of the position. |
| **Stage** | The stage the candidate is in, such as *To evaluate* or *Shortlisted*. |
| **Invitation Source** | How the candidate was invited, for example *Admin* when a team member invited them from the dashboard. |
| **Invitation Date Time** | When the candidate was invited. |
| **Completion Date Time** | When the candidate completed the interview. |
| **External ID** | The ID from your own system, if one was passed when the candidate was invited (for example through an [ATS integration](https://docs.hireflix.com/user/integrations/overview.md) or the [API](https://docs.hireflix.com/tech/features/interviews/inviting-candidate.md)). |
| **Team Score** | The candidate's overall score from your team's reviews. |

### Optional columns

Each toggle in the export popup adds one or more columns:

| Option | Adds | Description |
| - | - | - |
| **Position ID** | `Position ID` | The unique ID of the position. Useful when you combine exports from several positions, or match data with the [API](https://docs.hireflix.com/tech/features/positions/fetching-positions.md). |
| **Invite link** | `Invite Link` | The candidate's personal interview link (`app.hireflix.com/...`). Handy if you want to resend it yourself. |
| **Admin link** | `Admin Link` | A direct link to the candidate's interview in the Hireflix dashboard (`admin.hireflix.com/...`). Team members can click it to jump straight to the candidate's videos. They need to be logged in to view it. |
| **Candidate phone number** | `Telephone` | The candidate's phone number. This is empty if no phone number was provided. |
| **Time to complete the interview (hrs)** | `Time to Complete (hrs)` | The time between the invitation and the completion of the interview, in hours. This measures how long the candidate took to respond, not how long they spent recording. |
| **Number of interview questions** | `Number of Questions` | How many questions the interview has. |
| **Team reviews (scores and comments)** | `Score by <name> (<email>)` and `Comment by <name> (<email>)` | One score column and one comment column for each team member who reviewed the candidate, so you can see each person's rating next to the overall **Team Score**. |
| **Scores per question** | `[Question 1] Title: ...`, `[Question 2] Title: ...`, ... | The score your team gave the candidate on each question, one column per question. Only available when **Allow rating per question** is enabled under [**My Account > Ratings**](https://admin.hireflix.com/en/my-account/ratings) (see [Rating Settings](https://docs.hireflix.com/user/account-team/account-preferences/rating-settings.md)). |
| **Transcripts per question** | `[Question 1] Answer Transcript`, `[Question 2] Answer Transcript`, ... | The [transcript](https://docs.hireflix.com/user/building-the-interview/transcriptions.md) of the candidate's answer to each question, one column per question. |
| **All transcripts in one cell** | `All Transcripts` | Every question and answer combined in a single cell. This is easier to read, or to paste into another tool, than separate columns. |

The **All Transcripts** cell lists each question followed by the candidate's answer:

```text theme={null}
[Question 1 - Experience CX?]
[Answer 1 - Yes. I've led multiple customer experience teams, and I feel that I am very fit for this job.]

[Question 2 - Experience with leading a team?]
[Answer 2 - Yes, I have led multiple larger teams of up to 50 people.]
```

### Example: all options enabled

With every option turned on, the CSV for an interview with two questions has these columns:

```csv theme={null}
"Interview ID","First Name","Last Name","Email","Telephone","Position ID","Position Name","Stage","Invitation Source","Invitation Date Time","Completion Date Time","Time to Complete (hrs)","Number of Questions","Invite Link","Admin Link","Team Score","Score by Jane (jane@example.com)","Comment by Jane (jane@example.com)","[Question 1] Title: Question","[Question 2] Title: Question","[Question 1] Answer Transcript","[Question 2] Answer Transcript","All Transcripts"
```

> [!TIP]
>
> Opening the file in Excel and seeing strange characters or everything in one column? Import it instead via **Data → From Text/CSV** and choose **UTF-8** and **comma** as the delimiter. Google Sheets handles this automatically via **File → Import**.

## Learn next?

> [card] [Bulk download interview videos (API)](https://docs.hireflix.com/tech/features/interviews/bulk-downloading-videos.md)
>
> Need the interview videos too? Use a ready-made script with the Hireflix API to download every video for a position or your whole account.

> [card] [Share a single interview](https://docs.hireflix.com/user/reviewing-sharing/sharing-an-interview.md)
>
> Want someone outside your team to review one candidate? Share a direct link to that candidate's interview.


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