> 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/plan/community-events/export.md).

# 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 %}