Skip to content

Roster · Your people

Import employees from a spreadsheet

If you already keep your people in a spreadsheet, you can bring them all in at once. Roster checks every row before anything is saved, so a mistake in the file does not leave you with half an import.

Prepare the file

Save your spreadsheet as a CSV file. The first row must be a header row, and the column names should match the names of your fields in Roster, such as the names you see on the New employee form.

Check it

  1. On the Employees page, click Import.
  2. Click Choose a CSV file, or drag the file onto the box.
  3. Roster checks the file and shows three numbers: Rows, Will import and With problems.

Each row with a problem says what is wrong. If some of your columns match no field, Roster lists them under Columns not used, and that data is not imported.

Import it

Click the import button, which shows how many people will be imported. Only the rows that passed the check are saved. The rows with problems are left out: correct them in your spreadsheet and import the file again.

When it is done, click See your employees to check the result.

After importing

Open a few records and check who each person reports to, because that decides who approves their time off. Personal details such as bank details are not imported; add those in each person's personal data panel.

Updated 14 November 2026