# 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.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://support.pears.io/analyze/n-pears-export.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.