How to prepare contacts import file?
SurveyLab allows you to upload a previously created contact database saved as an Excel or CSV file.
How to prepare a contact file.
The contact details should be entered in the following order :
- First name
- Last Name
- Phone
- Language
- Custom1
- Custom2
- Custom3
- …
- Custom40
Remember
- The Email field is mandatory.
- The Email needs to be unique.
- All other fields are optional and may be left blank.
- Each field (e.g., Email, First Name, Last Name, etc.) should be separated by a comma (,).
- Each new contact should be entered on a new line (ENTER).
For 360-degree surveys, the email addresses of evaluators should be separated by a comma or entered on separate lines.
Contacts file format
Download the contact file template and use it to create your own file :
| Survey | Contact file template (Google Docs) | |
| Survey | Contact file template (Excel) |
Example
Email, First Name, Last Name, Phone, Language, Custom 1, Custom 2
[email protected], Jan, Kowalski, 520-232-453, PL, Gdynia, Specjalista IT
[email protected], Adam, Nowak, 520-235-455, PL, Kraków, Manager HR
[email protected], Anna, Smith, 520-238-458, EN, London, Opiekun Klienta