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

# Export

Export program activity data from PEARS as an Excel workbook.

The Program Activities export generates an Excel (.xlsx) workbook containing data from your program activities. The export includes program details, sessions, virtual modules, collaborators, evaluations, and partners across multiple worksheets.

## Getting Started

To export program activities, navigate to the Program Activities list under the **Engage** menu and click the **Export** button. The export includes all program activities matching your current filters.

The arrow next to the **Export** button opens a menu of additional options. If your account has permission to export uploads, that menu includes **Export with Uploads**, which delivers the workbook together with an archive of the files attached to the exported records.

![Screenshot: The Program Activities list view with the Export button highlighted and active filter options for reporting period, program area, and completion status visible above the records table](https://2560412328-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Ff0820LrBGQ9ZA8SC4BR1%2Fuploads%2Fgit-blob-3f9c2926a6b67af98a118bd261e2ca6db5ea325e%2Fprogram-activity-list-view.png?alt=media)

{% hint style="info" %}
**TIP:** Apply filters before exporting to limit the results to a specific reporting period, program area, or completion status. Large exports are processed in the background and you will receive an email when the file is ready to download.
{% endhint %}

## Workbook Structure

The export workbook contains the following worksheets. Data can be linked across worksheets using the **program\_id** column.

* **Codebook** — Describes each column in the workbook and provides notes about the exported data.
* **Program Activity Data** — One row per program activity with fields including name, reporting periods, organization, unit, program areas, site details, session counts, participant demographics, intervention topics, and timestamps.
* **Sessions** — One row per session occurrence, including the session ID, program ID, start date, start time, length in minutes, number of participants, and virtual/multimedia flags.
* **Modules** — One row per virtual module reported on a program activity, including the module description, average time in minutes, and number of participants. This worksheet is only included when the export contains program activities with 2023 or later reporting periods.
* **Collaborators** — One row per collaborator per program activity, including the user's name, access level, contributor status, and contribution description.
* **Evaluations** — One row per survey attached to a program activity, including the survey name, delivery type (Pre, Post, Follow-Up, Retrospective), delivery date, and response count.

### Conditional Worksheets

* **Partners** — Included when the partnerships feature is enabled and program activities have associated partners. Lists each partner's name, contributions, and linked partnership ID.
* **CRM Partners** — One row per partner linked from the Partners module, including the partner name, contributions, and linked partner ID. This worksheet is included when your organization uses partner links on program activities and the exported records have linked partners.