> 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/reflect/success-stories/export.md).

# Export

Export success story data from PEARS as an Excel workbook.

The Success Stories export generates an Excel (.xlsx) workbook containing data from your success stories. The export includes story details, collaborators, and partners across multiple worksheets.

## Getting Started

To export success stories, navigate to the Success Stories list under the **Reflect** menu and click the **Export** button. The export includes all success stories matching your current filters.

The arrow next to the **Export** button opens a menu of additional options. If your account has permission to export uploads, that menu includes **Export with Uploads**, which delivers the workbook together with an archive of the files attached to the exported records.

{% hint style="info" %}
**TIP:** Apply filters before exporting to limit the results to a specific reporting period, program area, or completion status. Exports of more than 20,000 records, and every **Export with Uploads**, 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 **story\_id** column.

* **Codebook** — Describes each column in the workbook, lists the filters that were applied, and provides notes about the exported data.
* **Success Story Data** — One row per success story with fields including title, reporting periods, organization, unit, program areas, site details, COVID-19 impact, linked program activity and action plan(s), project name, keywords, background, story narrative, favorite quote, priority indicators, socioecological frameworks, approaches, partner types, the noteworthy, complete, and verified flags, any custom fields your organization has added, and timestamps. Some of these columns appear only when they apply to your organization — program areas and COVID-19 impact are each left out when the organization does not use them, and the action plan columns appear only for Extension users.
* **Collaborators** — One row per collaborator per success story, including the user's name, access level, contributor status, and contribution description.

### Conditional Worksheets

* **Partners** — Included when your organization has the legacy Partnerships section turned on for success stories and the exported stories have associated partners. Lists each partner's name, contributions, and linked partnership ID.
* **CRM Partners** — Included when your organization uses partner links on success stories and the exported stories have linked partners. Lists each partner's name, contributions, and linked partner ID from the Partners module.