# Import Partnerships

The Partnership import allows you to create multiple partnership records at once from a spreadsheet file, including their action plan links and collaborators. PEARS generates a dynamic template customized to your organization, validates your data, and reports errors in a downloadable error workbook.

**Permission required:** Organization administrator or data manager.

## Import Partnerships

{% stepper %}
{% step %}

#### Navigate to the Import Page

From the Partnerships list page, click the **Import** button to open the import page.
{% 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.
* A **Key Mapping** sheet listing valid values for program areas, action plans, sites, units, jurisdiction levels, partnership types, assistance types, and meeting purposes — 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 partnership data. The template supports:

* **Partnership general information** — Name, reporting period, program areas, unit, site, jurisdiction level, partnership type, assistance types, etc.
* **Action plans** — Link partnerships to action plans using the plan IDs from the Key Mapping sheet.
* **Collaborators** — Add collaborators with access levels.

Required fields are indicated in the Codebook sheet. Each row on the main sheet represents one partnership record. Action plan and collaborator rows reference their parent partnership.
{% endstep %}

{% step %}

#### Upload and Submit

Upload the completed spreadsheet file. PEARS validates each row and creates partnership records for valid rows.

{% hint style="warning" %}
**NOTE:** If a partnership row fails validation, any child rows (action plans, collaborators) for that partnership are also skipped.
{% endhint %}
{% 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.
{% endstep %}
{% endstepper %}

{% hint style="warning" %}
**NOTE:** Only the import creator and organization administrators can view and manage an import. Data managers have additional flexibility to import data for completed records or past reporting periods.
{% endhint %}


---

# 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/engage/partnerships/import-partnerships.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.