> 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

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.

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