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

# Export

Export quarterly effort data from PEARS as an Excel workbook.

The Quarterly Efforts export generates an Excel (.xlsx) workbook containing data from your quarterly effort reports. The export includes effort details and multi-state and integrated project information across multiple worksheets.

## Getting Started

To export quarterly efforts, navigate to the Quarterly Efforts list under the **Reflect** menu and click the **Export** button. The export includes all quarterly efforts 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, quarter, or program area. 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 **quarterly\_effort\_id** column.

* **Codebook** — Describes each column in the workbook and provides notes about the exported data.
* **Quarterly Effort Data** — One row per quarterly effort with fields including reporting periods, organization, quarter, program areas, cooperative extension appointment, percent of effort by critical issue, contact demographics (gender, race, ethnicity), volunteer contacts and hours, and timestamps.
* **Multi-State & Integrated** — One row per project, including the project name, description, whether it is integrated or multi-state programming, and the percentage or hours of effort spent.

{% hint style="warning" %}
**NOTE:** Some columns depend on your organization's settings. The critical issue effort columns appear only for organizations that use Critical Issues, the contact demographic, volunteer contact, and volunteer hour columns appear only when the Contacts section is turned on for Quarterly Efforts, and the percent and hours of effort columns appear only when your organization reports project effort that way.
{% endhint %}