The spreadsheet nobody trusts any more
Almost every association starts with a spreadsheet. It works perfectly until the day someone emails a copy to someone else and there are suddenly two versions. Then the treasurer changes, the file stays on a private laptop, and nobody dares say how many members the association actually has.
The real problem is not the format but the direction: in a spreadsheet, only the person who owns the file can change anything. The member whose phone number changed has nowhere to put that information, so the register ages at exactly the rate members’ lives change.
A digital member register reverses that. The member updates their own details, the board sees the change immediately, and nobody has to email a file to anyone.
What a member register should contain
The basics are short: name, a way to make contact, and the membership itself. Beyond that, the register should answer three questions — is this person a member right now, what type of membership do they hold, and has the fee been paid. In Membly that is membership type, status (active, inactive or pending) and payment status.
On top of that, most associations collect what the activity actually requires: phone number, address, which group or section the member belongs to, whether they sit on the board, and whether a guardian is linked to a child. In Membly you can also add up to ten custom fields — text, phone, address, date, multiple choice or checkbox — and tie them to a specific membership type.
The principle is to collect what you have a use for, not everything you can think of. Every extra field is something that has to be kept current, protected, and one day deleted.
The member register and the GDPR
A member register contains personal data, and the association is the controller of it. In practice that means being able to say why you keep a piece of information, how long you intend to keep it and who has access to it. Membly is the processor and handles the data on the association’s instructions, under the processing agreement you accept when the association is created.
Access is restricted from the outset. An ordinary member sees names and roles in the member list but never anyone else’s phone number, email address or postal address — only administrators and leaders see contact details. The same boundary covers more sensitive fields such as gender and date of birth.
Personal identity numbers are entirely optional to collect. If you choose to, they are encrypted, shown masked in the interface, visible only to administrators and leaders, and never included in an export — not even when you export the whole register. Every member can also request their own data or delete their account.
This is general information about how Membly works, not legal advice. Assessing your own processing — particularly how long data should be kept — is a decision for the association to make and document.
What you can do with the register
All included in the subscription. No add-ons.
Import from Excel
Upload CSV, XLSX or XLS, map the columns and approve a preview before anything is saved. Up to 500 rows per import.
Members update themselves
Every member manages their own contact details from their account. The register stays current without the board chasing anyone.
Search and filter
Filter by status, membership type, group, custom tags, payment or role. A group is the unit a member belongs to — a voice part, a class or a section — so narrowing down follows how the association is actually organised.
Custom fields and tags
Up to ten custom fields and freely defined tags, tied to the right membership type. The association decides what is relevant.
Protected data
Contact details are visible only to administrators and leaders. Personal identity numbers are encrypted, masked and never exported.
Export whenever you want
The whole register or a filtered selection as CSV. The file opens in Excel — and imports back in.
From spreadsheet to living register
Four steps. The first takes a quarter of an hour — the rest grow out of using the register.
Import the list you already have
Upload the file, map the columns to the fields in Membly and review the result before it is saved. Split large lists into files of 200–250 rows so they stay easy to review.
Invite the members
Members receive an email invitation and sign in with a link. They fill in what is missing and correct what is wrong — which is, in practice, the cleanup nobody on the board has time for.
Set permissions and fields
Decide who administers, which fields the association actually needs and whether to add custom ones. Turn on personal identity numbers only if the activity requires it.
Use the register
Filter the right members for an announcement, see who has paid, link guardians to children, and export when you need figures for the annual meeting.
Who it is for
The register is the core of Membly. We are currently built for cultural and non-profit associations — sports clubs and housing cooperatives can register their interest.
- Associations whose member list lives in Excel or Google Sheets today
- Boards where the register follows the treasurer rather than the association
- Associations with several membership types and fees
- Activities involving children, where guardians need to be linked to the member
- Associations that need to show who is allowed to see which data
Compared with what you do today
Most associations keep their register in one of three ways.
Excel or Google Sheets
Where it breaks
The file gets copied, versions drift apart and the data goes stale. No member can correct their own details, and permissions effectively do not exist.
In Membly
One register, updated by the members themselves, with different access for administrators and members.
The member list in the Facebook group
Where it breaks
The group shows who joined a Facebook group — not who is a member of the association or who has paid. The data cannot be exported.
In Membly
Membership, membership type and payment status in one view, and an export you own yourself.
A binder or paper list
Where it breaks
Exists in one place, cannot be searched and cannot be shared without copying it. It rarely survives a change of board.
In Membly
Searchable and available to everyone authorised, whoever sits on the board right now.
| What many do today | Where it breaks | In Membly |
|---|---|---|
| Excel or Google Sheets | The file gets copied, versions drift apart and the data goes stale. No member can correct their own details, and permissions effectively do not exist. | One register, updated by the members themselves, with different access for administrators and members. |
| The member list in the Facebook group | The group shows who joined a Facebook group — not who is a member of the association or who has paid. The data cannot be exported. | Membership, membership type and payment status in one view, and an export you own yourself. |
| A binder or paper list | Exists in one place, cannot be searched and cannot be shared without copying it. It rarely survives a change of board. | Searchable and available to everyone authorised, whoever sits on the board right now. |
What it costs
SEK 299 per month for the whole association, however many members you have. The member register is included alongside fees, events, chat, feed and membership cards. The first 30 days are free and require no card. If you collect fees in the app the association receives the full amount; the SEK 25 service fee is added to the member's payment. The feature is optional.
Frequently asked questions
What should a member register contain?
At minimum a name, a contact detail and the membership itself — type, status and whether the fee is paid. Beyond that, collect what the activity actually requires, such as phone number, group membership or guardian. Every extra field is something you also have to keep current and protect, so do not collect more than you have a use for.
Is an association required to keep a member register?
Under Swedish law an ekonomisk förening — including a housing cooperative (bostadsrättsförening) — must keep a register of members. For non-profit associations there is no equivalent statute, but the by-laws usually require one in practice — and without a register you cannot call an annual meeting, collect fees or show who is entitled to vote.
How long may an association keep member data?
The GDPR sets no fixed limit. The principle is that data should not be kept longer than it is needed for its purpose, which means the association has to decide and document a retention period itself. Note that material counting as accounting records carries its own statutory archiving requirements, independent of the member register.
May we store members’ personal identity numbers?
Personal identity numbers may be processed where clearly justified by the purpose, for example when reporting for grants. In Membly the field is off by default. If you turn it on, the number is encrypted, shown masked, visible only to administrators and never included in an export.
Can members update their own details?
Yes. Every member manages their name, phone number and address from their own account, and the change takes effect in the association immediately. The email address is the login and is handled separately, so nobody accidentally locks themselves out.
Who in the association can see the register?
All members see the member list with names and roles, but only administrators and leaders see contact details. Fields such as gender and date of birth are visible to administrators only. You always see your own details, and a guardian sees their child’s.
How do we move the register out of Excel?
Upload the file as CSV, XLSX or XLS, map the columns to the fields in Membly and review a preview before anything is saved. An import takes up to 500 rows at a time and we recommend files of 200–250 rows.
Can we get the register back out?
Yes, at any time. Administrators can export the whole register or a filtered selection as a CSV file that opens in Excel. The file is designed to be imported back in. Personal identity numbers are never part of the export.
Read on
- Membership system for associationsThe whole system around the register — fees, permissions, announcements and events.
- GuidesIncluding what the GDPR actually requires of an association that uses Facebook.
- Compare association systemsMembly next to the most common alternatives on the Swedish market.
- PricingOne price for the whole association, however many you are.
