Many Swiss associations keep the member list in Excel. That works until versions multiply, addresses go stale, and before the AGM nobody knows which file is true. This guide shows when spreadsheet chaos starts, how to consolidate scattered lists, and how to land cleanly in Membear via CSV.
Excel is fine while one person owns the file and the association stays small. It breaks when several board members keep copies, WhatsApp lists and email attachments pile up, or payment status sits next to addresses in the same sheet. Typical signs: before the AGM you hunt for the “right” version, new members live only in an inbox, and address changes get lost. That is spreadsheet chaos — not because you are messy, but because a file is not a shared system.
For the secretariat and Aktuar role, “scattered member lists” means asking, retyping and reconciling. One list on a predecessor’s laptop, one in a cloud folder, one as a PDF for the audit — and nobody shares the same truth. Newsletters, invitations and fee runs need current contacts. Every hour spent merging files is an hour less for association life. That is why switching is often a push moment: not software enthusiasm, but the next AGM or board handover that the old way can no longer carry.
Before you import, a short cleanup pays off: one column per field (first name, last name, email, address, membership type, status), no duplicate rows, consistent spelling. Drop mystery note columns and clarify open resignations. A clear header row saves rework later. If you start from scratch or need to reorder columns, use our member-list template as an Excel or CSV start — fill it in, check it, then import. That way the switch does not fail on messy data.
The pull moment is simple: import members and have a shared overview tomorrow that the whole board trusts. In Membear you upload your cleaned CSV, map the columns and bring members into the central list. No retyping the whole association history. After that, secretariat, treasurer and presidency work from the same data — instead of asking for Excel exports. The core version is free to start, no credit card. Import is the entry; the win comes when nobody asks “Do you have the current list?” anymore.
After import you manage joins, leaves and addresses in one place. Later you can onboard new members digitally instead of retyping paper forms. Members update addresses in the portal themselves — fewer questions to the secretariat. You do not need to change everything on day one: centralise the list first, then fee runs and communication. Habit and anxiety (“We have always used Excel”) are normal. The pragmatic path: import CSV, invite the board, run two weeks in parallel — and keep the old file as archive only.
Short answers for secretariat, Aktuar roles and the board.
Upload CSV, invite the board and have a shared overview tomorrow. Start free — no credit card needed.