Help · Team leaders and HR

Import templates: employees, salaries and contracts, absences

Each spreadsheet importer has an Excel and a CSV template, with the columns it accepts and an example row. Download it, fill it in and upload it.

Updated on

Help centre

Selfcare's three spreadsheet importers each have a template to download, in Excel (.xlsx) and CSV (.csv). Each template has exactly the columns that importer accepts, with the names it recognises, and an example row. When you upload the filled-in template, the columns map themselves.

The column names stay in Portuguese, because those are the names the importer recognises.

Who can do it

The owner and HR, the same people who can import.

The three templates

  • Employees (employee files): to create or complete employee files. Only the full name (Nome completo) is required. Inside the app, the template also includes your company's custom fields.
  • Salaries and contracts: to update the contract and pay of people who already exist. It never creates employee files.
  • Absences: to import absence history. The start and end dates (Data início, Data fim) are required, and each row must identify the person (full name, internal code, external code or email).

Where to download them

  1. Open People and select Import.
  2. In the Action step, the Templates to fill in card has all three templates, each in .xlsx and .csv.
  3. Once you pick the action, the Upload step shows that action's template again, next to the button to choose the file.
  4. In Import absences, the template is in the Upload step.

How to fill it in

  • The Excel file has two sheets: Dados (data), the first one, where you fill it in, and Instruções (instructions), after it, with each column, whether it is required, the format and the accepted values. The file opens on the Dados sheet.
  • On the Dados sheet, required columns have an orange header. Do not rename the columns: that is how the importer recognises them. You can delete the columns you will not fill in.
  • Row 2 is a fictitious example: the name starts with "Exemplo", the emails are on exemplo.selfcare.work and the IBAN is a test IBAN. Delete it or type over it before importing.
  • Dates as DD/MM/YYYY. Amounts in euros with a decimal comma (1.250,00), as in Portugal; the € sign is optional.
  • Save as .xlsx or .csv. The old .xls format is not supported.

In the demo request

Anyone who requests a demo gets the employees template attached, with no one's data in it. Filled in, even with just the names, it lets us see the company inside Selfcare during the demo.

Not using Selfcare yet?

In a 45-minute demo we show you holiday requests, expenses and payslips.

Import templates: employees, salaries and contracts, absences · Help centre · Selfcare