Response Extract (Surveys)

Tool Search: Response Extract

The Response Extract allows you to review all responses submitted for a survey, including the ability to filter, print, save, and display responses in a pivot table for further analysis. 

screenshot of the response extract tool

Users must have at least R(ead) rights in order to generate this extract. 

For more information about Tool Rights and how they function, see the Tool Rights article.

Generate Survey Responses in a Table

To view survey responses, mark the checkbox next to the desired survey and click the Generate Responses Table button. The selected survey's responses will appear in a new table editor.

screenshot of a user generating the report and a view of the report

Using this editor, you can copy the data, download the data into a CSV, print the data, and search/filter the data using various features. The table below describes each available option.

FeatureDescription
Filter Repeat ResponsesIf Repeat Responses is enabled for the survey, marking this checkbox will filter responses to only the most recent. 
Copy the copy buttonCopies all data onto your computer's clipboard. 
CSV the csv buttonGenerates a CSV file containing extract information.
Print the print buttonAllows you to print the extract or save the extract as a PDF. 
Search
the search field
Allows you to filter data based on search criteria. 
Move Columnthe move column iconAllows you to drag and move a column to a different position in the data table. 
Move Column to be First Column the move column to be the first column buttonClicking this button moves the column to be the first column displayed in the data table. 
Hide Column the hide column buttonClicking this button will hide the column from the data table. 
Sort Columnthe sort column buttonClicking this icon will sort the columns data in ascending or descending order (if selected a second time). 

Use the table below for descriptions of each default column in the response table:

ColumnDescription
Assignee's First NameThe first name of the respondent assigned to take the survey.
Assignee's Last NameThe last name of the respondent assigned to take the survey.
Assignee's PersonIDThe personID of the respondent assigned to take the survey.
Start Time The time the assignee started the survey
End TimeThe time the assignee ended the survey.
Student's First NameThe student's first name if assignee is taking the survey on behalf of the student.
Student's Last NameThe student's last name if assignee is taking the survey on behalf of the student.
Student's PersonIDThe student's personID if assignee is taking the survey on behalf of the student.

Create a Response Pivot Table

To convert Response Extract data into a Data Analysis pivot table, click the Generate Data Analysis Report button. 

screenshot of the generate data analysis report button highlighted

Once selected, response data will display in a pivot table, allowing you to further analyze and present this data in various forms such as graphs and charts as well as apply logic rules and various formatting options.  

For a comprehensive explanation of pivot functionality, please view the following:

example of a generated report

Generate a Responses Summary

To view a summary of survey responses, mark the checkbox next to the desired survey and click the Generate Responses Summary button. 

Survey responses will appear in a summary with each question and corresponding answers displayed in a format best suited for each question type:

  • Select-type questions display as charts (bar, pie, doughnut, line)
  • Range-type questions display as a gauge
  • Text questions display as word clouds or a table

To modify the format of a question's responses, select a value in the dropdown lists found under each question.

screenshot of generating and viewing the response summary

You can also generate a PDF of the summary by clicking the the download pdf button button.