> For the complete documentation index, see [llms.txt](https://support.pears.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://support.pears.io/analyze/survey-response-exports/responses-by-survey.md).

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

{% hint style="info" %}
**TIP:** Navigate to **Analyze > Survey Data > 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 **Survey Name**, **Questions**, **Program Activities**, and **Aggregate**, which shows whether the survey allows responses to be entered in aggregate.

Use the **Filter** menu to narrow the list by program area, program completion, survey status, and whether the survey can have aggregate responses, or use the search box to search by survey title or description. By default the list is filtered to active surveys used by completed program activities. The program completion filter applied to the list also limits the responses included in the export.

## 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 in that period. Selecting a reporting period clears the date fields, and a date range is then no longer required.
{% 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. Responses entered in aggregate are excluded.
* **All Responses** — Each row represents a single response record, including responses entered in aggregate. 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

Enter a **Start Date** and an **End Date** to filter program activities. Both are required unless you select a reporting period. Only programs with a session occurrence that starts within this range, or with virtual content delivered during it, 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. This option is available only for the **Individual Responses** export type.
* **Include Response Data of Copied Surveys** — When checked, response data from surveys that were copied from the selected survey is also included, and the Response Data worksheet gains **Survey ID**, **Survey Name**, **Survey Is Copied**, **Copied from ID**, and **Copied from Name** columns. Only questions that were part of the original survey are reported for the copies.
* **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, Follow-Up, Retrospective, or Unknown.
* **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):

* **Question** — The question text.
* **Option** — The response option, with its numeric value in parentheses.
* **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.
* **Percent Change** — Percentage of change relative to the Pre response percentage.