Articles on: Settings
This article is also available in:

How to fill in the spreadsheet for importing people via Sync

This article explains how to correctly fill in the spreadsheet for importing data through Sync. Sync is a platform that makes imports easier. To learn how it works, see the article Como funciona o Sync (available in Portuguese).


Before you start, download the template spreadsheet, in Excel format, from the link Sync Spreadsheet Template. This is the spreadsheet you will use for the import.


Below, you will find the required fields and the steps for your data to be imported correctly into Sync.


Filling it in takes five steps, from preparing the spreadsheet to importing it into Sync.


In this article:


Step 1: Preparing the Spreadsheet


Open the import spreadsheet file in Excel or in another compatible program.


Step 2: Filling In the Fields on the Pessoas Tab


On the Pessoas tab, the required columns appear in the template with an asterisk in their name. There are six: Código, Nome, Sobrenome, E-Mail, Papel (user, manager, admin), and Data de Admissão.


The columns are listed below in the same order as in the template.


Column

What to fill in

Código

Enter a unique code for each person. The code must be unique on the TeamCulture platform. If the same code is already in use by another client, contact TeamCulture support, which will request its deletion. The code is usually the CPF, since it is a unique national identifier. But it can be any code, as long as it follows two rules: it is not registered in any other client account, and it has no special characters.

Nome

Enter the person's first name.

Sobrenome

Enter the person's last name.

E-Mail

Enter the person's email address. The email must be unique on the TeamCulture platform. If the same email is already in use by another client, contact TeamCulture support, which will request its deletion.

Papel (user, manager, admin)

Choose the appropriate role for the person. The options are user, manager (leader), and admin (administrator).

Data de Nascimento

Enter the person's date of birth in the DD/MM/AAAA format.

Data de Admissão

Enter the person's hire date in the DD/MM/AAAA format. This column is required.

Liderança direta (Obrigatório p/ Desenvolvimento)

This column is required only for the Development module. Otherwise, filling it in is optional. Fill it in with the email of the person's direct leader.

Atributos Demográficos

Enter all of the person's demographic attributes in a single text field, in the format "Attribute Name: Value".


What each role in the Papel (user, manager, admin) column means:


Role

Who it is

admin

These are the users who manage the account on the TeamCulture platform. They have visibility of all teams and permission to delete, add, and change people and groups.

manager

This is the user who manages a group within the company. This profile can manage team scores and view and reply to opinions from the groups where they were added as a leader.

user

This is the user who answers the survey and manages their own opinions.


In the Atributos Demográficos column, separate one attribute from the next with " | " (space, vertical bar, space).


Example: "Gender: Male | Tenure: Up to 1 year | City: São Paulo"


Note: fill in the demographic attributes based on the attributes created on the platform. Use the exact names, as they are configured there.


Step 3: Filling In the Fields on the Grupos Tab


These are the columns on the Grupos tab, from A to F:


Column

What to fill in

Column A: Centro de Custo

Fill it in with a unique code to identify each group. This code must be unique among the cost centers.

Column B: Nome do Grupo

Enter the group's name. This group will have the cost center entered in Column A. Use a unique name to identify each group: it must be exclusive among the group names.

Column C: Hierarquia Centro de Custo

Enter the cost center of the group that sits above the group in Columns A and B. If there is no group above, leave this column blank. For more information on how to create an organizational structure, see the article Group structuring and creation.

Column D: Hierarquia Nome do Grupo Acima

Enter the name of the group that matches the cost center in Column C. If there is no group above, leave this column blank.

Column E: Liderança (Código) - igual aba pessoa

List the codes of the leaders of the group in Columns A and B. Use the same codes you created for the people on the Pessoas tab. If the group has more than one leader, separate the codes with a comma and a space (example: cpf, cpf, cpf).

Column F: Pessoas (Código) - igual aba pessoa

List the codes of the people who belong to the group in Columns A and B. Use the same codes you created for the people on the Pessoas tab. If the group has more than one person, separate the codes with a comma and a space (example: cpf, cpf, cpf).


Note: in Columns E and F, use each person's code. The Liderança direta (Obrigatório p/ Desenvolvimento) column, on the Pessoas tab, is different: it takes the leader's email.


Step 4: Final Review


  1. Review all the filled-in fields, on all tabs, to make sure no information is missing or incorrect.
  2. Save the file in Excel format (.xlsx) to keep all the changes.


Step 5: Importing into Sync


To run the import, follow the Sync instructions in the article Como funciona o Sync (available in Portuguese).


If you have questions or need help during the import, contact TeamCulture.

Updated on: 09/11/2026

Was this article helpful?

Share your feedback

Cancel

Thank you!