Member database export columns reference
This reference describes the columns available when you export member contacts and explains the data each column contains.
Format
Section titled “Format”Exports are in CSV format (UTF-8 encoded, spreadsheet-compatible). The first row is a header row with column names. Values that start with a special character (such as =, +, or -) are prefixed with a single quote to prevent spreadsheet formula injection. This includes negative numbers: a number custom field holding -5 exports as '-5, so a spreadsheet shows it as text. Remove the leading quote (or convert the column to numbers) if you need to calculate with it.
Columns you can choose today
Section titled “Columns you can choose today”The export’s column selector currently offers two groups:
| Group | Columns |
|---|---|
| Core fields | Member ID · First name · Last name · Email · Phone · Status · Type · Created. First name, Last name, Email, Phone and Status are checked by default. |
| Custom fields | One checkbox per custom field you can see, unchecked by default. A sensitive field is listed only if your role includes the Export sensitive fields permission; it is marked as such, and Select all never ticks it (a sensitive field you already ticked stays ticked). |
At least one column must be selected.
If your role loses the permission later. An export you made with a sensitive column can’t be downloaded once your role no longer has Export sensitive fields — Export history shows “Download unavailable — your role can no longer export sensitive fields.” instead of the link.
Planned column groups
Section titled “Planned column groups”The Core fields, Email roles, Membership, and Tags and roles groups below are the planned design for the export; the selector offers only the columns listed above. The Custom fields section describes the custom field columns you can choose today.
Core fields
Section titled “Core fields”These columns are planned as defaults.
| Column | Content |
|---|---|
| First name | The member’s first name |
| Last name | The member’s last name |
| Primary email | The member’s primary email address |
| Phone | The member’s phone number |
| Address | The member’s full mailing address |
| Date of birth | The member’s date of birth (ISO 8601 format: YYYY-MM-DD) |
| Pronouns | The member’s pronouns |
| Date joined | The date the member record was created (ISO 8601) |
| Last modified | The date and time the record was last updated |
Email roles
Section titled “Email roles”Collapsed by default. Expand to include secondary email addresses.
| Column | Content |
|---|---|
| Billing email | The email address assigned the billing role |
| Receipts email | The email address assigned the receipts role |
Membership
Section titled “Membership”| Column | Content |
|---|---|
| Membership status | The current status (for example, active, grace, lapsed) |
| Level | The membership level name. A linked household member shows the household’s level (their own membership mirrors the primary’s), so an export filtered by a family or household level includes them. |
| Expiry date | The date the current membership period ends |
| Archived at | The date and time the record was archived. This column appears automatically when archived records are included in the export. |
Tags and roles
Section titled “Tags and roles”| Column | Content |
|---|---|
| Tags | A comma-separated list of all tags applied to the member |
| Contact roles | A comma-separated list of the member’s contact roles |
Custom fields
Section titled “Custom fields”One column appears for each custom field your organization has defined, in field-position order. Column names match the field label as it appears in MapleGather.
Each cell holds the member’s current value for that field, as it reads under the field’s current type (after a field type change, values read as converted). A multiple-choice value lists its option keys separated by ; . A member with no value has an empty cell.
For file-type custom fields, the export contains a secure download URL (not the file itself). The URL is valid for 24 hours after the export is created.
Field categories limit which custom fields you can export. Only fields in categories your admin roles include are listed; a field in any other category isn’t offered, and an export that asks for one is refused with “Some columns are outside the field categories your role can see. Remove them and try again.” A sensitive field you can see is marked “Sensitive — exported in full; the export is recorded in the audit log.” It is never ticked by Select all; tick it yourself to include it. The export then contains its values, and the export is recorded in the audit log. Everywhere else in MapleGather a sensitive value stays hidden until an admin selects Reveal.
Row count and async threshold
Section titled “Row count and async threshold”Every export runs in the background, whatever its size; download it from Export history when it’s ready (no email is sent). Download links are available for 24 hours. After that the row reads Expired and offers Re-run, which starts a new export with the same columns, filter, format and archived setting.