> 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

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