search
Contact Us

Export

Export PSE site activity data from PEARS as an Excel workbook.

The PSE Site Activities export generates an Excel (.xlsx) workbook containing data from your PSE (Policy, Systems, and Environmental) site activities. The export includes site activity details, partners, readiness assessments, changes adopted, recognition, effectiveness indicators, and collaborators across multiple worksheets.

hashtag
Getting Started

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

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

hashtag
Workbook Structure

The export workbook contains the following worksheets. Data can be linked across worksheets using the pse_id column.

  • Codebook — Describes each column in the workbook and provides notes about the exported data.

  • PSE Data — One row per PSE site activity with fields including name, reporting periods, organization, unit, program areas, site details, planning stages, intervention topics, needs assessment, funding sources, sustainability mechanisms, and timestamps.

  • Partners — One row per partner associated with a PSE site activity, including the partner name, contributions, and linked partnership ID.

  • Needs, Readiness, Effectiveness — Readiness assessment data and effectiveness assessment results for each PSE site activity.

  • Changes — One row per change adopted, including the change category, level, description, and adoption status.

  • Recognition and Media Coverage — Recognition events and media coverage associated with PSE site activities.

  • Individual Indicators — Individual-level effectiveness indicators tracked for PSE site activities, when applicable.

  • Individual Assessments — Assessment data for individual-level indicators.

  • Collaborators — One row per collaborator per PSE site activity, including the user's name, access level, contributor status, and contribution description.

Last updated