> 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/engage/program-activities/import-program-activities.md).

# Import Program Activities

Import program activity records in bulk from a spreadsheet file in PEARS.

The Program Activity import allows you to create multiple program activity records at once from a spreadsheet file. PEARS generates a dynamic template customized to your organization, validates your data, and reports errors in a downloadable error workbook.

**Permission required:** A Role that includes the **Program Activity Importer** and **Manage Own Program Activities** Permission Groups. The importer must also be turned on for your organization.

## Import Program Activities

{% stepper %}
{% step %}
**Navigate to the Import Page**

From the Program Activities list page, click the **Import** button to open the import page.

![Screenshot: The Program Activity Importer page with the Download Program Activity Data Template button, the file upload drop area and the File Upload History table](https://2560412328-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Ff0820LrBGQ9ZA8SC4BR1%2Fuploads%2Fgit-blob-5aeda75da23192f81031136ecd949449470bb649%2Fprogram-activity-importer-page.png?alt=media)
{% endstep %}

{% step %}
**Download the Template**

Click **Download Template** to generate an Excel template customized to your organization. The template includes:

* A **Codebook** sheet explaining each field with field types and example data formats.
* A **Key Mapping** sheet listing all valid values for lookup fields (program areas, action plans, sites, units, delivery methods, etc.) scoped to your organization's current reporting periods.

{% hint style="info" %}
**TIP:** Always download a fresh template before importing. The Key Mapping sheet reflects your organization's current configuration and may change between reporting periods.
{% endhint %}
{% endstep %}

{% step %}
**Prepare the Spreadsheet**

Fill in the template with your program activity data:

* Required fields are indicated in the Codebook sheet.
* Reference the **Key Mapping** sheet for valid values in lookup fields such as program areas, sites, and delivery methods.
* Each row represents one program activity record.
* Each row needs a **unit** and a **reporting\_period\_groups** value. The **reporting\_period\_groups** column holds the type of work, such as Extension or SNAP-Ed, by the name the Key Mapping sheet lists. There is no reporting period column: PEARS files each row under the current reporting period of its type of work. The unit must be one where your Role lets you add program activities, and it must offer that type of work.

{% hint style="info" %}
**TIP:** Fields that accept several values are separated by commas, so a value that contains a comma must be wrapped in double quotes — for example `SNAP-Ed, "Children, Youth, and Families"` in the **program areas** column. Without the quotes each fragment is validated on its own and the row is rejected.
{% endhint %}

{% hint style="info" %}
**TIP:** On the Collaborators sheet, enter **one collaborator per row**. Multiple emails separated by commas in a single row are not supported and will fail validation with a "One user per row" error.
{% endhint %}

{% hint style="info" %}
**TIP:** Extension and SNAP-Ed use different demographic categories. The SNAP-Ed-specific demographic columns are only included in the template when your organization has SNAP-Ed permissions. Use the column descriptions in the Codebook sheet to confirm which categories apply to your data.
{% endhint %}

{% hint style="warning" %}
**NOTE:** Once a 2027 or later reporting period has opened for your organization, the template also includes the combined race and ethnicity columns, named **participants\_race\_ethnicity\_one\_** and **participants\_race\_ethnicity\_mult\_** followed by the category (for example **participants\_race\_ethnicity\_one\_hispanic\_latino**), plus **participants\_race\_ethnicity\_two\_or\_more**, **participants\_race\_ethnicity\_prefer\_not\_to\_respond**, and **participants\_race\_ethnicity\_unknown**. Fill in the columns that match each program activity's reporting period: the combined columns for a 2027 or later reporting period, and the separate ethnicity and race columns for an earlier one. A value in a column from the other era fails validation with the message "This program activity records demographics for a different reporting era, so these values cannot be saved." A template downloaded before your organization entered the 2027 reporting period still imports.
{% endhint %}

{% hint style="info" %}
**TIP:** Session start times are interpreted in your account's time zone, so a session entered as 8:30 AM will appear as 8:30 AM in PEARS. Check your time zone in your profile settings before importing.
{% endhint %}

{% hint style="warning" %}
**NOTE:** Demographic data is validated the same way as on the Program Activity form. If you provide a **Participants Total**, the demographic breakdown must reconcile with that total. When the count method is **Unknown**, the unknown counts for each category must equal the total. Rows that do not reconcile fail validation and appear in the error workbook.
{% endhint %}
{% endstep %}

{% step %}
**Upload and Submit**

Upload the completed spreadsheet file. PEARS validates each row and creates program activity records for valid rows.
{% endstep %}

{% step %}
**Review Results**

If errors are found, download the **error workbook**. The error workbook includes:

* A dedicated **Errors** sheet with one row per error.
* Hyperlinked cell references sorted by sheet, row, and column so you can quickly locate and fix issues.

Correct any errors in your original file and re-upload to import the remaining records.

![Screenshot: The Import Errors panel on the Program Activity Importer page listing the worksheets that contain errors, with the Download file with errors button](https://2560412328-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Ff0820LrBGQ9ZA8SC4BR1%2Fuploads%2Fgit-blob-1c45b59b35ff8675cdf26b51895c2bd106c6f421%2Fprogram-activity-import-errors-panel.png?alt=media)
{% endstep %}
{% endstepper %}

{% hint style="warning" %}
**NOTE:** The **File Upload History** table on the import page lists only the imports you uploaded yourself.
{% endhint %}
