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, curriculum 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.

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

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.

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 Activities — 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 curriculum module delivered during a session, including the module name and associated session. 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, Followup, 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.