How to Run the N-PEARS Export

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

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.

Steps

1

Open the N-PEARS Export

Hover over the Analyze menu in the top navigation bar and select N-PEARS Export from the dropdown.

2

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.

TIP: Reporting years from 2023 onward are available for the N-PEARS Export.

3

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.

4

Select Reported By (Optional)

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

NOTE: Selecting a user will only export records that the user created. Records where the user is listed as a collaborator are not included.

5

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.

6

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.

7

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.

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.