Export

Export coalition data from PEARS as an Excel workbook.

The Coalitions export generates an Excel (.xlsx) workbook containing data from your coalitions. The export includes coalition details, members, meetings, and collaborators across multiple worksheets.

Getting Started

To export coalitions, navigate to the Coalitions list under the Engage menu and click the Export button. The export includes all coalitions matching your current filters.

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 coalition_id column.

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

• Coalition Data — One row per coalition with fields including name, reporting periods, organization, unit, program areas, jurisdiction level, member and sector counts, assistance received and provided, relationship depth, assessment tools and results, accomplishments, intervention involvement, and timestamps.

• Members — One row per coalition member, including the member name, sector of influence, entity type, site details, and role and resources.

• Meetings — One row per meeting or event, including the event title, start date, attendance, purposes, and notes.

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