Export

Export indirect activity data from PEARS as an Excel workbook.

The Indirect Activities export generates an Excel (.xlsx) workbook containing data from your indirect activities. The export includes activity details, intervention channels, collaborators, and partners across multiple worksheets.

Getting Started

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

Screenshot: The Indirect Activities list view with the Export button highlighted and filter options for reporting period, program area, and completion status visible above the records table
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.

Workbook Structure

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

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

  • Indirect Activity Data — One row per indirect activity with fields including title, reporting periods, organization, unit, program areas, intervention topics, languages, start and end dates, materials, and timestamps.

  • Intervention Channels — One row per intervention channel, including the channel name, description, site details, estimated reach, newly reached count, and source of reach data.

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

Conditional Worksheets

  • Partners — Included when the partnerships feature is enabled and indirect activities have associated partners. Lists each partner's name, contributions, and linked partnership ID.

Last updated