How do I create a distribution file for a Confidential Survey?

Nov 18, 2022 | Knowledge Base

The distribution file (sometimes referred to as a send list) is used to setup your employees in our application, send them invitations, record their responses and help structure the analysis of the results.  It is only required when using Confidential-style surveys.

If you have not integrated your HRIS with the Qlearsite platform, then you will need to prepare your send list in Excel. We have made this easier for you by including a simple template to get started.

Follow these steps:

  1. Download your employee data from your HRIS system, this is often referred to as register data. You will need your source data to cover:
    • A unique identifier for each employee
    • Employee Name
    • Email address
    • Hierarchy information so that your analysis can group employees into their teams
    • Any demographic information you want to use in the analysis, for example, gender or age.   
  2. Download the template from the Qlearsite platform. This is accessible in the “Distribution” step when designing your survey.
  3. Once you open the spreadsheet template, you will see a single sheet in the file. The table below walks through the columns and describes what is required.

Below is a guide to each column:

Column nameConfigurationMandatory
Employee IDA unique alphanumeric identifierYes
NameIn a consistent format such as ‘Firstname Lastname’, to be used in the addressing of emails.

Tip: Do not separate out first and last names into different columns. 
Yes
Email AddressMust be unique and valid and all in lowercase.  International characters (àäôçé) and sub-addressing in the email prefix (for example, ‘name+inbox1@company.com’) are allowed.Yes
Hierarchy Level 1Hierarchy Level 1 is the first level of your organisation beneath your whole “Organisation View”. Up to 9 additional levels of Hierarchy can be added with each new column on the excel file being a new level on the hierarchy.

Most international characters (àäôçé) and the following special characters are accepted: & . , – ( ) * ‘ ” + 

You cannot use these characters:    # / ;  ? \
Yes, even if the same value is used for all employees
Hierarchy Level 2As aboveNo. If not required, leave the column title Labels (Hierarchy Level 1, Hierarchy Level 2, etc) and remove the dummy text in the cells below, leaving them blank
Hierarchy Level 3As aboveAs above
Hierarchy Level 4 etc…As aboveAs above
Attribute 1, 2,3,…Change the column title to the label you would like to see in your analysis. Make sure each column title is unique and keep the labels short and easy to read. E.g. Gender, Tenure, Location etc…

You can add as many attributes as you think will be useful when analysing your results. Add additional attributes as extra columns in the sheet.
Optional, if not required, remove the entire column (including the heading and dummy text)

Some additional tips:

  • Don’t change the name of the tab in the spreadsheet file.  It should remain as ‘Sendlist’.
  • Take care to use the right data in Attributes.  For example, don’t include dates for age or tenure. Instead, transform your raw date data into buckets which will make your analysis easier. Read more about attributes and demographics here.
  • Here is an example file with sample data that demonstrates how buckets can be created.

Once your file is completed, upload into the platform. The platform will perform validations and let you know if there are any issues that need to be corrected.

Get started with Qlearsite