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

18 Nov 22 | 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.

Time out

5 things that HR doesn’t have time for

There’s only so many hours in a day. And there’s even fewer working hours… in theory. But for a...
What does HR do for employees really?

Seriously, what does HR do for employees?

“Oops, watch out - HR might be listening” “Don’t tell HR I said that!” “I’m not sure HR would be...
Window with money behind

Pay transparency is business critical: here’s why

‘Competitive’. What does the word mean? What is it hiding? Do people writing job advertisements...
Not talking about money

3 reasons bosses avoid ‘pay chats’ (and how benchmarks help)

No-one actually enjoys talking about money, do they? Whether you’re the employee or their manager,...

Salary benchmarking by Qlearsite Pro

Whatever kind of people leader you are - HR professional, CEO, team lead, line manager - then...
Absence management software

Why (and how) to choose absence management software

If you’re a people leader, there’s a lot to keep on top of. And managing absence isn’t always...
Sickness absence management: a guide

Sickness absence management: the ultimate guide

In your organisation, do employees have to call in when too unwell to work - rather than send a...
What is absenteeism?

What is absenteeism, and why should you measure it?

Absenteeism refers to a pattern of unplanned time off from work, often due to sickness or other...
6 reasons to use a salary benchmarking tool

6 reasons to use a salary benchmarking tool

If you’ve been following our blog, you’ll have learnt what benchmarking is, what salary...
why benchmarking salaries matters

Why benchmarking salaries matters

It’s important to benchmark your organisation’s salaries for multiple reasons - like being able to...

Get a live demo
of the platform 

Anne Therese Bogen, Head of HR, Thommessen

"Qlearsite’s platform is a really helpful tool to push through OKRs – it’s easier when you have statistics and concrete evidence to back up initiatives."