# N-PEARS Export

The N-PEARS Export transforms your organization's PEARS data into a format that can be imported directly into National PEARS (N-PEARS) for federal annual reporting. The export aggregates SNAP-Ed programming data by project and applies the field mappings required by N-PEARS.

![Screenshot: N-PEARS Export page showing the fiscal year dropdown, unit selector, reported by field, configuration options, and Start Export button](https://2560412328-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Ff0820LrBGQ9ZA8SC4BR1%2Fuploads%2Fgit-blob-84d30353284dfd0239483d3d0e8693016f4582fc%2Fn-pears-export-page.png?alt=media)

{% hint style="info" %}
**TIP:** Navigate to **Analyze > N-PEARS Export** to access this feature. The N-PEARS Export is only available to state-level (IA) organizations.
{% endhint %}

## Getting Started

The N-PEARS Export generates a .zip file containing two Excel workbooks:

* **N-PEARS Export** — Aggregated data formatted for direct import into N-PEARS.
* **N-PEARS Raw Export** — Disaggregated detail data for verification purposes. This file should not be imported into N-PEARS.

[How to Run the N-PEARS Export](https://support.pears.io/analyze/n-pears-export/how-to-run-the-export)

## Record Types

The export includes data from eight PEARS record types. Each record type has specific inclusion criteria and field mappings that determine how PEARS data translates to N-PEARS fields.

{% stepper %}
{% step %}

#### Programming Data

* [Program Activities](https://support.pears.io/analyze/n-pears-export/program-activities) — Maps to the Direct Education section in N-PEARS.
* [Indirect Activities](https://support.pears.io/analyze/n-pears-export/indirect-activities) — Maps to the Indirect Education Channels section in N-PEARS.
* [Social Marketing Campaigns](https://support.pears.io/analyze/n-pears-export/social-marketing-campaigns) — Maps to the Social Marketing Campaigns section in N-PEARS.
  {% endstep %}

{% step %}

#### PSE Data

* [PSE Site Activities](https://support.pears.io/analyze/n-pears-export/pse-site-activities) — Maps to the PSE Change Initiatives section in N-PEARS.
* [Partnerships](https://support.pears.io/analyze/n-pears-export/partnerships) — Maps to PSE Active Partners in N-PEARS. Only partnerships attached to PSE Site Activities are included.
  {% endstep %}

{% step %}

#### Collaboration & Stories

* [Coalitions](https://support.pears.io/analyze/n-pears-export/coalitions) — Maps to the Multisector Partnerships and Coalitions section in N-PEARS.
* [Success Stories](https://support.pears.io/analyze/n-pears-export/success-stories) — Maps to the Success Stories section in N-PEARS.
  {% endstep %}

{% step %}

#### Sites

* [Sites](https://support.pears.io/analyze/n-pears-export/sites) — Maps to Project Sites in N-PEARS. Any site linked to an included program, PSE, or success story is included.
  {% endstep %}
  {% endstepper %}

## Additional Resources

* [Data Cleaning Checklist](https://support.pears.io/analyze/n-pears-export/data-cleaning-checklist) — Review this checklist before running the export to ensure your data is ready.

## Global Inclusion Criteria

The following criteria apply to all record types unless otherwise noted:

* Only records attached to the selected **reporting year** are included.
* Only records with the **SNAP-Ed** program area are included.
* Only records marked as **complete** are included.
* Records entered by Canopy staff or test users are excluded.