> 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.md).

# Survey Response Exports

Export survey response data from PEARS as Excel workbooks for analysis.

Survey Response Exports allow you to download survey response data collected through Program Activities as Excel (.xlsx) workbooks. Three export types are available, each organizing the data differently to support different analysis needs.

![Screenshot: Responses By Survey page showing the list of available surveys with Survey Name, Questions, Program Activities, and Aggregate columns and an Export button on each row](https://2560412328-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Ff0820LrBGQ9ZA8SC4BR1%2Fuploads%2Fgit-blob-9ceb1969bb672858024cb949cdc1b840ddf00ed2%2Fsurvey-response-exports-page.png?alt=media)

## Getting Started

To open an export, hover over the **Analyze** menu in the top navigation bar and click **Responses By Survey**, **Responses By Question**, or **Responses By Matched ID** under **Survey Data**. Each export displays a list of available surveys or questions based on your permissions. The **Survey Data** section is only visible if your organization has the Surveys module enabled and you have permission to the Surveys module.

{% hint style="info" %}
**TIP:** The **Responses By Survey** and **Responses By Matched ID** lists include only surveys with a purpose of **Direct Education** that have at least one question. You can only export response data for Program Activities you have permission to view.
{% endhint %}

## Export Types

{% stepper %}
{% step %}

#### Responses by Survey

Export all response data for a single survey. Each row represents one survey response, with columns for every question and response option on the survey.

[Responses by Survey](/analyze/survey-response-exports/responses-by-survey.md)
{% endstep %}

{% step %}

#### Responses by Question

Export response data for a single question across all surveys that include it. Useful for analyzing how a specific question performs across different surveys and programs.

[Responses by Question](/analyze/survey-response-exports/responses-by-question.md)
{% endstep %}

{% step %}

#### Responses by Matched ID

Export pre/post (and followup/retrospective) response data matched by a unique identifier, allowing you to compare an individual participant's responses across survey delivery types.

[Responses by Matched ID](/analyze/survey-response-exports/responses-by-matched-id.md)
{% endstep %}
{% endstepper %}

## Workbook Structure

All three export types generate an Excel workbook with the following worksheets:

* **Codebook** — Describes each column in the workbook, lists applied filters, and provides notes about the export.
* **Summary Statistics** — Statistical analysis of responses including frequency, question total (n), percent of response, mean, median, mode, and standard deviation for Pre, Post, Followup, and Retrospective survey types. Also includes **Change in Percent** and **Percent Change** between Pre and Post.
* **Response Data** — The raw response data rows.

The Responses by Matched ID export includes an additional **Matching Errors** worksheet.