# How to Run the N-PEARS Export

{% hint style="warning" %}
**NOTE:** The N-PEARS Export is only available to state-level (IA) organizations. 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 select **N-PEARS Export** from the dropdown.
{% endstep %}

{% step %}

#### Select Fiscal Year

Choose the correct **Fiscal Year** for the export from the dropdown. The default is the current or active Federal Fiscal Year. To run an export for a completed reporting period, select a previous fiscal 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 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                                                    |
| ------------------------- | -------------------------------------------------------------- |
| 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 contains 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.


---

# 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/how-to-run-the-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.