How to export your members
Download a membership's members list, with membership numbers, payments and each requirement's answers, as a spreadsheet file.
The export gives you a membership’s whole members list as a CSV file, which any spreadsheet app opens: for your records, or for a federation or insurer that asks for your members.
Before you start
- You need to be a manager of your organization.
Steps
-
In your organization’s menu, click Memberships.
-
On the membership’s row, click the people icon (View members).
-
Click Export members. Your browser downloads a file named after the membership, ending in -members.csv.
What’s in the file
The file has one row for each person on the members list, whatever their status: people waiting for approval, people you rejected and members who haven’t renewed are in it too, and it has no status column. It always holds the whole list.
Its columns are:
- Name: the person’s or organization’s name.
- Email, for a player membership: the email of their account, unless one of your requirements already asks for it.
- Membership Number.
- Payment, when your membership has a fee of its own (the fee of a membership yours extends isn’t in it): the day they paid their current fee, the status of a payment that hasn’t gone through, or that they haven’t paid. A member who chose to pay you directly shows as pending until you mark the payment paid. After that, it shows the day they chose to pay you directly, not the day you marked it paid.
- One column for each requirement, in the order you set, then for each requirement of the membership yours extends: a column per question for personal information and per field for profile information, even when they left it blank; the date they accepted a document or watched a video; what they typed for a training or other requirement; and, for a course credential, whether they hold a valid one when you export, and until when. An uploaded document is a link that opens only for the member and the managers of the organization that asked for it, signed in to Dodgeball Hub.
The first column names, and values such as the payment status, are in English whatever language you use. A value that starts with =, +, - or @, such as a phone number that starts with +, has an apostrophe in front of it, so your spreadsheet app doesn’t run it as a formula.
Membership numbers
A member gets their number when they first complete the membership or claim a gift. It’s a few letters from your organization’s name, usually its initials, followed by a number that counts up across all your memberships. They keep it when they renew. The members list shows the newest numbers first.
The members list has no search. To find someone in a long list, use your browser’s find (Ctrl+F, or ⌘F on a Mac), or search the exported file.
download, csv, excel, spreadsheet, member list, roster, membership report, membership numbers, member numbers, registry, insurance list, find a member