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

# Export

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.

{% 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 **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.