# Import officers from a spreadsheet

Bring your officers in from a spreadsheet instead of adding them one at a time. Download the template, fill it in, upload it, and ShiftTracker creates every officer it can. Rows with a problem come back as a file to fix, and invitations can wait until you are ready.

## Who can do this?

Agency Admins and Agency Coordinators.

## How do I import?

1. On **Officers**, press **Import**.
2. Press **Download template** and open it in Excel or any spreadsheet. The second row says what each column takes, and the third is an example. An unchanged notes or example row is never imported.
3. Fill in one row per officer, up to 500 rows. **Name** and **Email** are required. Give the SIA licence type, number and expiry together, or leave all three empty. **Role type** must match one by name.
4. Save the file as CSV and choose it under **Upload the filled-in file**. Every row is checked, and nothing is created yet.
5. Choose **Hold invites** or **Send invites now**, then press **Import**. Keep the page open until it finishes.
6. If any rows were left out, press **Download rows to fix**, fix them using the **Problem** column, and upload the file again.

![Import officers after a file is uploaded, at step 3, Check and import. It reads 2 rows are ready to import. 1 row has a problem and is left out. Rows to fix lists Row 4, Dev Patel: Email appears earlier in the file, on row 2, with a Download rows to fix button. Under Invitations to sign in, Hold invites is selected; the other choice is Send invites now. The buttons read Choose another file and Import 2 rows.](/docs/img/import-officers-preview.png)

An officer whose email or licence number is already on one of your officers is refused, as is a licence that has already expired.

## When do my officers get their invitations?

With **Hold invites**, nobody is emailed. When you are ready, go to **People → Imports**, open the import and press **Send held invites**. Anyone who has already signed in is skipped, and an invitation that fails to send stays held so you can try again.

You can also send one officer's invitation from their page, as for an officer you added by hand. See [Manage officers](/docs/agency/manage-officers).