How do I download my survey results data?

18 Nov 22 | Knowledge Base

Downloading your survey data is simple, but not all Qlearsite users are able to do this because it a permission-based feature. By default, most survey administrators are setup with this capability. However, if you are unable to download your survey data, please email support@qlearsite.com.

Want to export your survey distribution data? Read this article here.

Go to your Insights module to export and download your survey results data. Hover over the distribution of your choice to see the download icon. Clicking on it will let you start the process of exporting your results. When you are informed that your export is in progress, you can close the pop-up.

Processing time can vary depending on the size of your survey and the number of respondents. You can continue to use the Qlearsite platform while your file is being prepared.

Check in on the progress of your export by clicking on the download icon again. If the file is ready to be downloaded, you will see the option to download the file to your computer.

What about employee privacy?

Employee confidentiality is maintained even when you export your survey results. If there are insufficient responses to meet the data protection thresholds, your data will be displayed as “redacted” in the Excel file.

The Survey Results Export File

The Excel file consists of 6 tabs:

  • Survey summary
  • Respondent count by hierarchy
  • Metrics by hierarchy
  • Closed responses by hierarchy
  • (language) Themes by hierarchy
  • Text responses by hierarchy

How to analyse the Engage score:

The product excel export tabs are filtered by hierarchy. We recommend starting with a single point in the hierarchy as the excel provides every single answer, for all hierarchy levels which can be a lot of data to view at one time.

The Aggregated Metric Value is the questions that have been marked positively in the survey form – all select one type questions should be marked with a Blue Tick for the positive answers Strongly Agree + Agree.

Using the Metric by Hierarchy tab to calculate the Engage score per department:

  • Apply data filters to the top row, columns headers
  • Within Metrics by hierarchy, Column G . ‘Metric name’ – select the 4 engagement questions used in the survey form. This can include:
    • I am motivated to respond to the changing needs of our organisation.
    • At our organisation, I feel motivated to persevere to find solutions to challenge
    • Our organisation inspires me to contribute more and do my best work every day.
    • I would recommend this organisation as a great place to work.
  • Column A – select the hierarchy / department you want to view
  • The average of those questions scores in Column H Aggregate Metric Value is the Engage score

Please note, all scores are percentages within the file.

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...
Everything people leaders needs to know about salary benchmarks

What is salary benchmarking?

Salary benchmarking is about comparing your organisation’s salaries to similar roles in different...
The text says "What is benchmarking Everything people leaders need to know"

What is benchmarking? Everything people leaders should know

Benchmarking is about making comparisons. You can compare your organisation’s metrics against an...
People saying bye to each other

The ultimate guide to attrition rates

People start jobs. People leave jobs. It’s just the natural order of things. You expect to see...
Man and woman working in tech

Gender ratio benchmarks: is the tech sector improving?

Steve Jobs. Elon Musk. Bill Gates. Mark Zuckerberg. When you think of tech leaders, these are...
Software integration illustration

How (and why) to choose people analytics software

We live in a data-driven era. That’s because we know we’ve already got a lot of the answers, it’s...

The Legal Sector and presenteeism: benchmark insights

You wake up with streaming eyes, a congested nose, and a banging headache. It’s official: you’re...

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."