How to use it
- Keep the Roster tab first and leave row 1 as it is. Add one person per row.
- Always fill in Email. It's what you'll use to reach people, and the one column an import can't do without.
- Use the optional columns you need and delete the rest. Mark people who stop coming with N in Active instead of deleting them.
- Fill in the Officers tab with this year's officers and advisor.
- To email everyone, copy the joined cell on the Email list tab into the Bcc line. There's a second one for active members only.
What's in it
- Roster: Name, Email, Phone, Notes, then Grade or year, Role, Joined, Active (Y/N) and Tags. A plain table with the header in row 1, no title rows and no merged cells, so it sorts, filters and imports cleanly.
- How to use: short instructions, including the import rules.
- Officers: role, name, email, phone, term and notes for president, vice president, secretary, treasurer and advisor.
- Email list: every email joined with commas, plus active members only. It updates as the roster changes. The joined cells use TEXTJOIN, which needs Excel 2019 or later, Microsoft 365 or Google Sheets.
- Example: twelve filled rows to show how notes, roles and the Active column look in practice.
When this file is all you need
A spreadsheet roster is fine when one officer keeps it and you mostly use it for contact info. Store it in a shared folder the advisor can open, so it doesn't leave with an officer who graduates.
Doing this in Helptivo
When you outgrow the sheet, upload this exact file in Helptivo's member directory. It's already in the import format: names, emails, phones and notes come in, and your other columns are kept in each person's notes. From there, people who sign up for events are added and matched by email, and you can sort members by hours or by who's been active lately. Free for up to 150 members. Start a free club, or read about the member database.
Questions people ask
What should a club member roster include?
At minimum a name and email for each person. Phone, grade or year, role, join date and whether they are active are the columns most clubs add.
Can I import this roster into Helptivo?
Yes. Upload the .xlsx as is. Helptivo reads the first tab and the Name, Email, Phone and Notes columns. Rows without a valid email are skipped.
What happens to the extra columns when I import?
Columns Helptivo doesn't recognize, like Grade or year and Role, are added to each person's notes as text, for example "Role: Treasurer". The Tags column does not turn into Helptivo flags; add flags after the import.
Can I use it in Google Sheets?
Yes. Open it in Google Sheets to keep it up to date. To import it into Helptivo, download it with File > Download > Microsoft Excel (.xlsx), since Helptivo takes .xlsx files, not CSV.
Can I add or rename columns?
Yes, after the first four. Keep Name, Email, Phone and Notes in row 1 as they are if you want to import the file later.
