Filling in your employee file in Excel can be tricky with all the possible input formats. To make sure you import the right data into the platform, here are the standards to observe when filling in your employee file in Excel.

In this article :

This one is pretty straightforward: you can simply enter the first and last names of the employees.

💡Pro tip: for an easier to update database, we recommend you choose a typography and stick to it (with or without accents, all capitalized last names or just the first letter, etc.).
​
​

This is a special Boolean filter (yes/no). To fill it in, here are the possible values:

ℹ️ This information is mandatory. Therefore, it is not possible to leave the value empty.

Make sure to fill in emails and personal identifiers (matricules) without accents, apostrophes or spaces.
Accepted characters for identifiers are: numbers, letters, dashes "-", underscores "_".

All phone number formats are supported! Just be sure to include the country prefix for non-French phone numbers.

ℹ️ If you plan to use your employees' personal numbers, remember to collect their consent first.

⚠️ Warning: you will need to collect a unique number per employee. The solution does not work for shared phone numbers (on-call phone, etc.). If several team members share the same phone number, the person holding the phone at the time of the survey launch will receive everyone's text messages. This could result in the employee answering for their colleagues.
​
​

Languages must be filled in according to the following standards:

Text filters are unrestricted. They only need to have values that don't exceed 255 characters.

For Boolean filters (yes/no), you can use these values:

💡 Pro tip: If you want to compare the results of the "Yes" employees with the rest of the population, remember to disassociate the other employees with the "No" value.
​
​

The supported formats for the Country filter are:

This is a list filter, for which the platform offers 3 options:

There are only two possible dated filters on the platform - date of birth and start date. To fill them in, here are the valid formats:

💡 Pro tip: in your Excel file, select the column and right click > "Cell Format". From there, you can set the date format for all values in the column.
​
If you have any questions, please feel free to let us know at [email protected]. We will be happy to help you. 💁‍♀️