# Responses by Survey

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.

{% hint style="info" %}
**TIP:** Navigate to **Analyze > Reports > Responses by Survey** to access this export. Select a survey from the list and click **Export**.
{% endhint %}

## 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:

{% stepper %}
{% step %}

#### Reporting Period

Optionally select a reporting period to limit the export to program activities within that period.
{% endstep %}

{% step %}

#### 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.
  {% endstep %}

{% step %}

#### Date Range

**Required.** Enter a start date and end date to filter program activities. Only programs with session occurrences or creation dates within this range are included.
{% endstep %}

{% step %}

#### 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.
  {% endstep %}
  {% endstepper %}

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

{% hint style="warning" %}
**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.
{% endhint %}

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


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://support.pears.io/analyze/survey-response-exports/responses-by-survey.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.