---
title: "Exporting Survey Responses and Analyzing them in Excel"
slug: "analyze-survey-results"
tags: ["NFR"]
updated: 2024-09-27T15:12:36Z
published: 2024-09-27T15:12:36Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.skillable.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Exporting Survey Responses and Analyzing them in Excel

When you need to analyze the responses to a survey you have attached to a Course or classes, you can export the responses to a CSV file for analysis in Excel or other programs.

## Export Survey Responses

There are 2 locations to export responses:

1. Navigate to the **Survey Profile** page.
2. In the quick links bar, select **Export Survey Responses** or **Export Anonymous Survey Responses**. Note: The anonymous export will not contain any information identifying the respondent. **-OR-**
3. Navigate to the **Response Summary** page for the survey.
4. Select **Search**. The Export link will appear next to Search.
5. Select **Export**.
6. Save the file where needed.

### Export Response Properties

You can open this file in any program that reads a .csv file format and then analyze or format the results as needed in that program. The file for a student survey will contain the following items:

- Survey Id
- Course Id
- Class Id
- Class
- Class Start Time
- Class End Time
- Instructor
- Instructor Email
- User (unless exported using Anonymous Survey Responses)
- User Email (unless exported using Anonymous Survey Responses)
- Question
- Label
- Response

Each row will contain one answer to one question in the survey. If a question is a matrix-type question (i.e. Rate the following on a scale of 1 to 10), each label will be considered its own question and thus have its own row.

The following are two ways to analyze the results in Excel: [Using filters](/docs/analyze-survey-results#using-filters) and [Using PivotTables](/docs/analyze-survey-results#using-pivottables). Start by opening the file in Excel and widening the columns as necessary. Highlight and bold the top row, if desired.

## Using Filters

Filters can be used if you would like to collapse the data based on different data points such as only looking at responses to a specific question or for a specific instructor. Filters can be applied to more than one column at a time. A row must match every filter to appear in the results.

To use the **Filter** functionality:

1. Ensure the active cell is anywhere in the data.
2. On the **Home** ribbon tab, select **Sort & Filter > Filter**. A dropdown arrow will appear in each column’s header cell.

Here are two examples of how you might want to use these filters:

*Show me the responses for question X*

1. To narrow the results for a specific question, select the dropdown arrow next to **Question**.
2. From the list, ensure only the question(s) you want to see responses for are checked and select **OK**.

When a filter is applied to a column, you will notice a Funnel icon added to the dropdown arrow in the column header, the row indicators change color, and the Status bar at the bottom will display **X of Y records found** indicating the number of filtered results.

*Show me the responses for X course(s) taught by Y instructor(s)*

1. To narrow the results for a specific instructor, select the dropdown arrow next to **Instructor**.
2. From the list, ensure only the instructor(s) you want to see responses for are checked and select **OK**.
3. To narrow the search even further to only certain course(s), select the dropdown arrow next to **Course Id**.
4. From the list, ensure only the course(s) you want to see responses for are checked and select **OK**.

Filters can be applied and removed from columns in any order. To remove or change a single column filter, select its dropdown and either make changes to the selections or select **Clear filter from …**.

## Using PivotTables

PivotTables can be used to do a higher level of analyzing. You may need to practice with the PivotTable to get the analysis you want but it is highly flexible. This article will only touch on the basics with one scenario to help you get started: *What is the average rating for each instructor on the Instructor’s Knowledge question*.

To add a **PivotTable**:

1. Start with the active cell inside of the data. This allows Excel to recognize the range of cells for the data.
2. From the **Insert** ribbon tab, in the **Tables** group, select **PivotTable**.
3. In the **Create PivotTable** dialog, keep the defaults and select **OK**. A new tab will be added to your file.

The following steps may differ depending on your needs and the way your questions are configured in your survey.
4. In the **PivotTable Fields** menu box, check and drag **Instructor** to the **Columns** area at the bottom of the menu box.
5. Check and drag **Question** to the **Filters** (or **Rows**) area.
6. Check and drag **Label** to the **Rows** area (if **Question** is already there, drop **Label** below it).
7. Check and drag **Response** to the **Values** area. Select the dropdown on **Count of Responses** and select **Value Field Settings**.
8. In the **Value Field Settings** dialog, select **Average** in the **Summarize value field by** list.
9. Select **Number Format** and in **Format Cells** dialog, select the format you want the average responses to be in (in rating scale questions, it is best to go with **Number** and your choice of decimal places) and select **OK**.
10. Select **OK** again to close the **Value Field Settings** dialog.
11. In the table, select the filter dropdown next to **Question**, and select the knowledge question and select **OK**.

When using the Average summary for the Values, all data must be numerical. When a data point is not numerical, its value is ignored. If all data points are text, you will receive a #DIV/0! Error in that cell as can be seen in the screenshot for Andy Barkl. In this case, the Response scale has numbers except for 1 and 10, which are “1 Not effective” and “10 Effective”. Andy received all “10 Effective” responses to a couple of items and thus you see the error.

This article is not an in depth explanation of Excel’s filters and PivotTables. It just provides some simple examples of how you might get started in analyzing your survey responses.

Bundles together content to then be set up for training through classes, subscriptions, and course assignments. Courses can include labs, videos, SCORM, LTI, external links, assessments, and documents. Courses must be assigned to a Content Provider and a Publishing Group to be available to set up for training.

A class is a scheduled instructor-led event with a start and end time/date. Typically, these include lectures and hands on activities such as labs.