> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://ajuda.teamculture.com.br/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# 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](https://docs.google.com/spreadsheets/d/11Wwx4B58diKZHe797rsZ0VeJab6a1-aF/edit?gid=1469567285#gid=1469567285). 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](#3-step-1-preparing-the-spreadsheet)
* [Step 2: Filling In the Fields on the Pessoas Tab](#3-step-2-filling-in-the-fields-on-the-pessoas-tab)
* [Step 3: Filling In the Fields on the Grupos Tab](#3-step-3-filling-in-the-fields-on-the-grupos-tab)
* [Step 4: Final Review](#3-step-4-final-review)
* [Step 5: Importing into Sync](#3-step-5-importing-into-sync)

### 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.