Go to
SurveyLab
SurveyLab

Help sections

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 :

  1. Email
  2. First name
  3. Last Name
  4. Phone
  5. Language
  6. Custom1
  7. Custom2
  8. Custom3
  9. …
  10. Custom8

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 semicolon (;).
  • 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)[D] Download
Survey | Contact file template (Excel)[D] Download

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