Import Workers

Add a whole crew from a spreadsheet: a preview with each row's problems, then add and invite them all.

For: Contractor Administrator · Customer Administrator · System AdminLast checked: 2026-11-06Open this page in Obtempera ↗

Import beside Add Worker on the Workers page opens it. It adds up to 500 Workers at a time, each invited by email. A Contractor Administrator imports its own Contractor's Workers, a Customer Administrator its Customer's own workforce, and System Admin any; HR and EHS Administrators, Licence Reviewers and Report Viewers do not add Workers, so the page is not theirs. If you add Workers to more than one Contractor, choose Whose Workers under step 2 first. If you add Workers to none, the page says You do not add Workers to any Contractor.

Back to Workers (top right) returns to the register. The ? beside the title opens this article.

1. Start from the template

Download the Excel template or the CSV template. Its columns are First name, Last name, Email, Project code and Language. Keep the first row (the column names) as it is.

  • First name, Last name and Email are required.
  • Project code: the Project the Worker is going to, if any. It must be a Project of the same Customer.
  • Language: the language the Worker's invitation and emails use, as a code or the language's name (for example pl, Polish or Polski); blank means English. The portal speaks English, Polish, Romanian, Lithuanian, Latvian, Portuguese, Italian, French, German, Dutch, Danish and Swedish. For someone already on record the column is checked but their language is not changed.

The template's second row is an example Worker (Aoife Byrne): delete it. Left in the file (it is recognised by its email address), it is marked Fix this, and, as with any row to fix, nothing is added until it is gone.

2. Check the file

Choose the file (.xlsx or .csv, up to 2 MB) and press Check the file. An Excel file is read from its first sheet; a CSV should be saved as UTF-8. Blank lines are skipped. Nothing is added at this step.

3. The preview

A summary line (to add · nothing to do · to fix), then one row per line of the file: Line, Name, Email, Project, Language and Result.

ResultMeans
To addA new Worker, invited by email; or someone already on record, added to the Project (again, if their time on it had ended).
Nothing to doAlready on record, and already on that Project or with no Project given.
Fix thisThe row cannot be added; the reason is beside it.

The reasons a row needs fixing:

  • This is the template's example row: delete it.
  • First and last name are both needed.
  • The email address is not valid.
  • The same email is on line … (the later line of a duplicate).
  • The Language is not one the portal speaks.
  • No Project with the code … at the Customer.
  • The Contractor is not registered in the Project's Country, or its Country Compliance Declaration is not approved yet (Worker onboarding is locked until the contractor is approved in this country.).
  • Contractor is not assigned to this project.
  • The Project is suspended, completed or archived: it takes no new Workers.
  • The Worker's record is not Active (for example suspended or archived): set it back to Active on their Worker record first, then add them to the Project.

"Already on record" means the same email at the same Contractor.

4. Add and invite

Add and invite N Workers appears only when no row needs fixing and at least one is to add. Fix the file and check it again until then. Everything is added in one go:

  • A new Worker gets an invitation to the Worker Portal, in their language.
  • Someone who already has a Worker Portal account and is added to a new Project gets the email that they have been added to it instead.
  • With a Project, their compliance record for it is started.

The heading then reads 3. Done, with a link to Open Workers. The import is recorded on the audit trail. Any further questions on the Add a Worker form are not in the file: they are left unanswered, to fill in later on each Worker's record.

When it is refused

  • An Inactive Contractor takes no new Workers: the page says so instead of offering Check the file. A Customer Administrator of that Customer, or a System Admin, can set it Active again on the Contractor's record.
  • A suspended or archived Contractor, or a Customer that is not active, takes no new Workers either.
  • A whole file is refused, with the reason, when it is empty, over 2 MB, over 500 Workers, cannot be read, or its first row does not name the columns.