THE MEMBERSHIP OPERATIONS FIELD GUIDE
Move your membership list from Excel.
A worked CSV import, a ready-to-edit spreadsheet and a clear way to reconcile every row before you switch registers.
By VeritableRoll · Updated · Product screenshots use fictional records.
Preparing a committee discussion? Use our spreadsheet risk and GDPR checklist to review access, copies, retention and recovery before moving the register.
Start with the example and template
The download contains three fictional memberships. Use the Excel workbook to prepare your own records, or upload the example CSV unchanged to test the process. The private workspace accepts CSV; save the workbook as CSV UTF-8 before uploading.
Replace all three example rows before importing real members. Keep the header row. The examples contain no payments, evidence documents or account credentials. Read the template field guide if you need to decide which references, branch labels and statuses to retain.
Keep the numbers people already use
Take a copy of the original register and agree an export cutoff. Each row represents one membership. Keep a separate stable person reference so that one person with two branch memberships can have two membership references but one person reference.
An email address is not a reliable identity: two people may share one, and an individual may change theirs. Preserve the source-system name and both references through later imports. Do not generate new references each time you export.
| Membership reference | Person reference | Member number | Branch | Status |
|---|---|---|---|---|
| EX-M001 | EX-P001 | 000042 | GLA | active |
| EX-M002 | EX-P002 | 000043 | GLA | active |
| EX-M003 | EX-P003 | 000044 | GLA | pending |
The member-number cells in the workbook are text. If you open a CSV directly in Excel, check that 000042 has not become 42. Import that column as text when necessary. Quoting a CSV value alone does not stop a spreadsheet from converting it.
Match columns once, then check the examples
- In Import & onboarding, select New import, choose the CSV and name its source register. Mark the example as fictional.
- Select Continue to column matching. Check the suggested matches against the sample values.
- Match “Grade” to Membership type, “Joined on” to Date joined, and the two reference columns to their separate membership and person fields.

Use YYYY-MM-DD dates such as 2025-03-14. Email can be blank; the third sample shows this. Status can be active, pending, grace, lapsed, expired, suspended or cancelled. An omitted status starts as pending. Missing names, references or membership numbers need correction.
Choose branches and membership types
At Organise members, map the sample group GLA / MEMBER to your Glasgow branch and Member grade. Your organisation may use different names: choose the destination deliberately. Create missing branches or membership types in this step if you have permission.
Creating the structure saves it immediately. It does not yet add members. Keep external branch labels in your source file; a mapping connects those labels to your register.
Resolve problems before you approve
Select Check file & review import. For this example in a register without those references, expect 3 new memberships, 0 already present and 0 rows needing correction. Data row 1 is spreadsheet row 2, after the headings.
- Unmapped branch: return to the structure step and select the destination.
- Invalid date: correct it in the source file; 2026-02-30 is not a date.
- Conflicting reference: investigate which person or membership it belongs to. Do not remove the reference just to bypass the conflict.
- Existing record: review the result. An exact repeat should not create another membership; conflicts are not silently overwritten.
Choices are saved in the current tab. After a refresh, choose the same file to continue; the browser does not retain the raw file as a permanent copy.
Reconcile the completed register
Approve the checked import, wait for processing and review the completion receipt. Reconcile imported, already-present and unresolved rows against the source total. Open member 000042 and confirm the name, Glasgow membership, type and joining date. Check the blank email and pending status on 000044 too.
For a new three-member register, the expected result is three memberships and three people. If you are adding to an existing register, compare the change in totals as well as the final number. Keep a copy of the receipt with your migration record.
A CSV can also carry one source term, a positive opening balance and evidence references per membership. Plan those mappings separately: an opening balance is not a historic payment ledger, an evidence reference is not an uploaded document, and a payment mandate needs its own provider process.
Once the register is checked, configure your renewal requirements and assess one member before working through the whole cycle. The public demo is a renewal example; imports belong in your private trial workspace.