> 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/engage/program-activities/analyze-export.md).

# Analyze a Program Activity Excel Report

Understand the contents and structure of a program activity Excel report in PEARS.

Individual program activity Excel reports contain data from a single activity. This is different from [program activity exports](https://support.pears.io/engage/program-activities/export.md), which are run from the Program Activities list and include multiple activities with expanded details such as site information and session data.

{% hint style="info" %}
**TIP:** Download the Excel report from the program activity detail page before performing your analysis. Click the **More** button at the top of the record and select **Download Excel Report**.
{% endhint %}

![Screenshot: The More menu open at the top of a program activity's detail page, showing the Print and Download Excel Report options](https://2560412328-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Ff0820LrBGQ9ZA8SC4BR1%2Fuploads%2Fgit-blob-22367644989bad9ccc7b4ac01874335b0c3d6368%2Fprogram-activity-more-menu-download-excel-report-v2.png?alt=media)

## Report Contents

A program activity Excel report contains three types of sheets:

### Export Details

Information about when the export was run and by whom, how many survey instruments are attached, and when the program activity was last updated. One sheet per file.

### Overview & Demographics

All details from the General Information section of the program activity, followed by custom field data and demographic totals when they have been entered. One sheet per export.

### Data Tabs

Raw survey response data as entered in PEARS. One sheet per attached survey instrument that has response data. Individual responses generate a separate row for each response; aggregate data lists each answer option with its response count.

{% hint style="info" %}
**TIP:** Use the data tabs for further statistical analysis in external applications such as Excel or Google Sheets.
{% endhint %}
