> 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/analyze/n-pears-export/how-to-run-the-export.md).

# How to Run the N-PEARS Export

Step-by-step instructions for running the N-PEARS Export from PEARS.

The N-PEARS Export produces SNAP-Ed data formatted for import into N-PEARS, along with a second file containing the disaggregated data behind those numbers.

{% hint style="warning" %}
**NOTE:** The N-PEARS Export is only available to Implementing Agency (IA) organizations that use SNAP-Ed, and only to users with SNAP-Ed permissions. If you do not see this option in the Analyze menu, contact your PEARS administrator.
{% endhint %}

## Steps

{% stepper %}
{% step %}

#### Open the N-PEARS Export

Hover over the **Analyze** menu in the top navigation bar and click **N-PEARS Export**.
{% endstep %}

{% step %}

#### Select Fiscal Year

Choose the correct **Fiscal Year** for the export from the dropdown. Each option shows the date range of your organization's SNAP-Ed reporting period for that year, and the default is your organization's current reporting year. To run an export for a completed reporting period, select a previous year.

{% hint style="info" %}
**TIP:** Reporting years from 2023 onward are available for the N-PEARS Export.
{% endhint %}
{% endstep %}

{% step %}

#### Select Unit

Choose from the **Units** dropdown. You may select multiple units. The export will include records from the selected units and their sub-units.
{% endstep %}

{% step %}

#### Select Reported By (Optional)

Optionally select a specific user in the **Reported by** field to limit the export to records created by that user.

{% hint style="warning" %}
**NOTE:** Selecting a user will only export records that the user **created**. Records where the user is listed as a collaborator are not included.
{% endhint %}
{% endstep %}

{% step %}

#### Configure Options

* **Only include 'Adopted' PSE Changes** — When checked (default), only newly adopted PSE changes are included. Uncheck to also include maintained changes from previous years.
* **Only include 'Noteworthy' Success Stories** — When checked, only success stories marked as "Noteworthy" are included.
  {% endstep %}

{% step %}

#### Start the Export

Click the **Start Export** button. The export runs in the background and may take several minutes depending on the volume of data.
{% endstep %}

{% step %}

#### Download the Results

When the export completes, a confirmation message appears. A .zip file named **National Pears Export.zip**, containing two Excel workbooks, downloads automatically:

* **N-PEARS Export** — The formatted data for import into N-PEARS.
* **N-PEARS Raw Export** — Disaggregated detail data for review. This file is labeled "DO NOT IMPORT" and should not be uploaded to N-PEARS.

If the download does not start automatically, click the download link in the confirmation message.
{% endstep %}
{% endstepper %}

## Export Worksheets

### N-PEARS Export Workbook

| Worksheet                 | Description                                                                            |
| ------------------------- | -------------------------------------------------------------------------------------- |
| Codebook                  | Export version, the filters you applied, and the field definitions for every worksheet |
| Sites                     | All sites used in included programs, PSEs, and success stories                         |
| Project Sites             | Sites annotated with intervention approaches and settings                              |
| Direct Education          | Program activity data aggregated by project                                            |
| PSE Changes               | Adopted and maintained PSE changes                                                     |
| PSE Partners              | Partnership data for PSE site activities                                               |
| Social Marketing          | Campaign summary data                                                                  |
| Social Marketing Segments | Campaign market segments                                                               |
| Social Marketing Channels | Campaign channels and reach data                                                       |
| Indirect Education        | Indirect activity data aggregated by project                                           |
| Success Stories           | Individual success story records                                                       |
| Coalitions                | Coalition summary data                                                                 |

### N-PEARS Raw Export Workbook

The raw export opens with its own Codebook worksheet, followed by one worksheet per record type with disaggregated data, including individual program activity records, sessions, modules, PSE records, partnership records, campaign records, channel records, indirect activity records, success stories, coalition records, member records, and site records. Use this file to verify the data before importing the N-PEARS Export into N-PEARS.