# Export

The Community Events export generates an Excel (.xlsx) workbook containing data from your events. The export includes event details, collaborators, sessions, registration types, forms, and payment information across multiple worksheets.

## Getting Started

To export community events, navigate to the Community Events list under the **Plan** menu and click the **Export** button. The export includes all events matching your current filters.

![Screenshot: The Community Events list page with the Export button highlighted, showing the filter options applied above the list of event records](/files/EUPlj0bwu2sfn73vUy62)

{% hint style="info" %}
**TIP:** Apply filters before exporting to limit the results to a specific date range, status, or program area. Large exports are processed in the background and you will receive an email when the file is ready to download.
{% endhint %}

## Workbook Structure

The export workbook contains the following worksheets. Data can be linked across worksheets using the **event\_id** column.

* **Codebook** — Describes each column in the workbook and provides notes about the exported data.
* **Events** — One row per event with fields including title, summary, program areas, unit, location details, time zone, start and end times, payment settings, status, and timestamps. If the event was copied from another event, the row includes a **Copied From ID** and **Copied From** name pointing back to the source event.
* **Collaborators** — One row per collaborator per event, including the user's name, access level, event organizer status, contributor status, and contribution description.
* **Event Sessions** — One row per session, including the session name, start and end times, and location.
* **Event Registration Types** — One row per registration type, including the type name, deadline, and capacity.
* **Event Forms** — Form elements and options associated with event registration types, including element names, types, and option labels.

The Registrations sheet also includes a **Resume Link** column with the direct link for each parent registration. Child registrations leave this column blank so you can skip them when emailing the link to the registrant -- the parent's email already covers the group.

### Payment Worksheets

The following worksheets are included when the event payment feature is enabled for your organization:

* **Event Registration Fees** — Base fees associated with registration types.
* **Event Session Fees** — Fees for individual event sessions.
* **Early Bird Discounts** — Time-limited discounts applied to registration fees.
* **Additional Fees** — Add-on fees triggered by form element selections.
* **Promotional Codes** — Discount codes that can be applied during registration.

### Payment Details Export

The Payment Details export is available from the event detail page for users with the **Export Payment Details** permission. It contains one row per transaction with a **Transaction Type** column indicating "Payment" or "Refund." Refunds appear as separate rows with negative totals, so summing a payment and its refund yields the net amount. Rows are sorted by registration, with refund rows immediately following their corresponding payment.

{% hint style="info" %}
**TIP:** Test/preview registrations created while previewing the registration flow are excluded from the Payment Details export.
{% 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/plan/community-events/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.