Responses by Survey
Export all survey response data for a single survey as an Excel workbook.
The Responses by Survey export generates an Excel workbook containing all response data collected for a selected survey across Program Activities you have permission to view.
TIP: Navigate to Analyze > Reports > Responses by Survey to access this export. Select a survey from the list and click Export.
Selecting a Survey
The export page displays a list of surveys available for export. Only surveys with a Direct Education purpose that have at least one question are shown. The list includes the survey title, question count, and program activity count.
You can filter the list by program completion status and search by survey title or description.
Export Options
When you click Export on a survey, a modal appears with the following options:
Type of Export
Individual Responses — Each row represents a single participant's response. Each question appears as one column, and the participant's selected option is shown as the cell value.
All Responses — Each row represents a single response record. Questions with multiple response options are split into separate columns (one per option), and cell values show the response count for that option.
Additional Options
Code Values — When checked, response option text is replaced with numeric code values (e.g., 1 instead of "Strongly Agree"). The Codebook worksheet documents the code mappings.
Include Response Data of Copied Surveys — When checked, response data from surveys that were copied from the selected survey is also included in the export.
Code Blank Responses — When checked, blank or missing responses are assigned a custom value that you specify in the Value field. Requires Code Values to be enabled.
Response Data Columns
The Response Data worksheet includes the following columns:
Program Activity ID — Unique identifier of the program activity the response was collected for.
Program Name — Name of the program activity.
Program Entered By — User who created the program activity.
Organization — Organization the program activity belongs to.
Unit — Extension unit where the program activity took place.
Primary Curriculum — Primary curriculum assigned to the program (SNAP-Ed programs only).
Program is Complete — 1 if the program is complete, 0 if not.
Response Collection Method — How the response was collected: Manual Entry or Public Link.
Program Survey Name — The label given to the survey when it was attached to the program activity.
Delivery Type — Survey delivery type: Pre, Post, Followup, or Retrospective.
Is_aggregated — 1 if the response is an aggregated response, 0 if individual.
Delivery Date — The date the survey was delivered as part of the program activity.
Response Date and Time — The date and time the survey response was submitted.
Unique PEARS ID of Response — System-generated unique identifier for the response record.
Survey questions — One or more columns for each question on the survey, depending on the export type selected.
NOTE: When using the All Responses export type, each response option for a question becomes its own column. The cell value shows how many times that option was selected. When using Individual Responses, each question is a single column with the selected option as the value.
Summary Statistics
The Summary Statistics worksheet provides statistical analysis for each question and response option, broken out by delivery type (Pre, Post, Followup, Retrospective):
Frequency — Count of responses selecting each option.
Question Total (n) — Total number of responses for the question.
Percent of Response — Percentage of responses selecting each option.
Mean — Mean of the numeric values for the question.
Median — Median of the numeric values.
Mode — Most frequently selected numeric value.
Standard Deviation — Standard deviation of the numeric values.
Change in Percent — Difference in percentage between Pre and Post responses.
Percentage Change — Percentage of change relative to the Pre response percentage.
Last updated