How NZ charities actually run volunteers – and the day the spreadsheet breaks
Most New Zealand charities do not run volunteers on software. They run them on a spreadsheet, a Google Form, a Facebook group and a volunteer centre membership – and for most of the year that stack genuinely works. This guide covers what the sector actually uses (with the sector's own numbers), a free roster template that is more useful than the standard four-column one, and the specific day the spreadsheet stops being enough.
What everyone actually uses
The sector's peak body has measured this. The State of Volunteering in Aotearoa New Zealand Report 2024, published by Volunteering New Zealand, asked organisations what systems they use to manage volunteers' hours and projects:
“Despite rapid digitisation and growth in many organisations, the majority still do not use any form of digital or online system for managing their volunteers' activities. 50.6% report using no digital system at all (including simple tools such as Excel spreadsheets) while 22.9% report using only basic systems such as Microsoft Excel or Microsoft Word.”
Add the first two figures together: 73.5% of New Zealand's volunteer-involving organisations run on nothing more than Excel, Word, paper or memory. The spreadsheet is not the fallback – it is the market leader. And the same page of the report identifies the crossover point: “Organisations who engage more than 100 volunteers a year are more likely to report using a specific volunteer management system.” Keep that number – it comes back at the end of this guide.
The regulator works from the same starting point. Charities Services asks registered charities to report, in the annual return, the number of volunteers who supported the charity during the year and the total hours they volunteered – and it provides a free spreadsheet template for the job, with four fields: volunteer name, date, hours volunteered, and activity or project. Community Governance Aotearoa redistributes that same template in its resource hub. The DIA template is right for what it is for: it answers the annual return, simply and for free.
Around the spreadsheet sits real infrastructure. New Zealand has 16 regional volunteer centres providing recruitment, referrals, advice and training to member charities – for annual fees that run from free at Volunteer South to $60–$300 at Volunteering Auckland (tiered by income), with Volunteering Canterbury at $65–$137. They are among the best value in the sector, and nothing in this guide suggests replacing them – the centres are the recruitment layer, and Volunteering Auckland's own advice to growing charities is to pair that with a free or low-cost platform for shifts, rosters and communications. Keep your membership. Keep listing everywhere.
The spreadsheet's genuine strengths
73.5% of the sector is not wrong. The spreadsheet holds its position for reasons that deserve saying out loud:
- It costs nothing and is already owned – every charity has Google Workspace or Microsoft 365, so there is no procurement conversation
- It satisfies the compliance floor – the Charities Services annual return needs a volunteer count and total hours, and a spreadsheet is the regulator-endorsed way to meet it
- Anyone can read it – no accounts, no passwords, no training, and any committee member can open it
- A Google Form feeding a sheet is a functioning intake pipeline – names, availability and site preferences land in one place, and for a one-off working bee it genuinely works
So rather than argue with the spreadsheet, we built a better one. The regulator's template has four columns because the annual return needs four columns. A roster needs more: sites, shifts, capacity, contact details, and a record of who confirmed and who turned up.
Free volunteer roster template (.xlsx)
A working roster, not four columns. Three sheets: a Roster (site/location, date, shift start and end, capacity, volunteer contact details, confirmed and checked-in columns, with hours calculated from the shift times), a Volunteers database (one row per person, entered once), and a ReadMe explaining how it fits together. Hours still total up for the Charities Services annual return – and the Volunteers sheet uses the same fields PurposeTech's CSV importer accepts, so if you ever outgrow it, graduating is one upload.
No email address required. Download it, adapt it, share it.
The day it breaks
Every tool in the default stack – the sheet, the form, the Facebook group, the free listing boards – keeps working right up until the day you need to know, live, which sites are covered. On that day, none of them can tell you. For most charities that day is their first real appeal: hundreds of collectors, dozens or hundreds of sites, two or three shifts each, area coordinators who each need to see their own patch, and a 9am question – which sites are actually covered? – that a spreadsheet cannot answer while it is being edited by five people at once.
Five things fail at the same time:
Forms are one-way
A Google Form cannot cap a site at two collectors per shift, close a full slot, or show volunteers what is still open. The coordinator becomes the matching engine – by email, one row at a time.
One writer at scale
Concurrent editing at appeal scale, with multiple area coordinators in one sheet, turns it into a fragile single point of truth with no record of who moved whom.
No communications layer
No confirmations, no reminders, no day-of messaging. Every send is a manual mail-merge, in the busiest week of the year.
No day-of state
Check-ins, no-shows, uncovered sites – the sheet cannot answer “which of our sites are covered right now?”, and that is the question appeal day asks all morning.
The record dies with the tab
Next year's appeal starts from a blank sheet. The sector's own data shows organisations engaging more than 100 volunteers a year migrating to dedicated systems – that is the ceiling being observed at scale.
New Zealand has already run this experiment
The most famous volunteer mobilisation in the country's history started as a Facebook page. After the September 2010 Christchurch earthquake, Sam Johnson's callout grew into what the NZ Herald described as “a 10,000-strong student volunteer army... gathered via Facebook” – Stuff covered the same mobilisation as it redeployed after the February 2011 quake. Facebook was a perfect megaphone. It was not an operations system, and the SVA did not pretend otherwise: within days it was running on Facebook plus GeoOP, a mobile job-dispatch system, to move teams around the city (NZ Geographic told the fuller story). Even the country's defining Facebook mobilisation needed a coordination layer bolted on the moment real deployment started.
That is the same shape, at emergency speed, of what a national appeal does to a spreadsheet on a planned timetable. For scale: the Pink Ribbon Street Appeal runs 8,000+ collectors across 1,000+ sites each October – a coverage question the size of a small city, asked every hour of appeal weekend.
What graduating preserves
Moving to a platform is not a rip-and-replace. Every part of the stack that works keeps its job – it just stops being asked to do coordination.
| What you have | Keeps doing | What changes with PurposeTech |
|---|---|---|
| The spreadsheet | The treasurer's familiar artefact and the annual-return record | Your volunteer list imports via CSV – email is the only required column – and exports back out whenever you want it |
| Volunteer centre membership | Recruitment, referrals, advice and training – it was never coordination software, and it stays worth every dollar | Centre referrals feed a volunteer database that persists between campaigns instead of a tab that gets retired |
| SEEK Volunteer, Do Good Jobs and other free boards | Free listings, wide reach – keep listing everywhere | Top-of-funnel into a campaign page where applicants book an actual shift instead of landing in an inbox |
| The Facebook group | The megaphone – community-building, callouts, urgent broadcasts | The signup link in the pinned post goes to a campaign micro-site, so coordination stops living in comment threads and Messenger |
CSV import details per the PurposeTech bulk operations documentation. Volunteer centre services and fees per the sources listed at the end of this guide, last checked 3 September 2026.
Keep your stack – change one layer
The advice in this guide reduces to one sentence: keep the volunteer centre membership, keep the Facebook group, keep the free listings, keep the treasurer's spreadsheet – and when you cross the line the sector's own report identifies, around 100 volunteers a year, move the coordination layer onto something built for it. That is the point at which the sheet stops being a record and starts being a bottleneck, and it is usually the point at which a first appeal is on the calendar.
Until then, the free roster template will carry you further than the four-column standard, and it is deliberately built so that graduating later is one CSV upload – not a re-keying project. If you want to see what the other side of that upload looks like, pricing is published in NZD and the trial is self-serve.
Volunteer spreadsheet FAQ
Is a spreadsheet enough to satisfy Charities Services?
Yes. The annual return asks for the number of volunteers who supported your charity during the year and the total hours they volunteered, and Charities Services itself provides a simple spreadsheet template for exactly that. The regulator's template is right for what it is for. Our free template keeps you compatible with those needs – hours are calculated from shift start and end times, so the year-end totals are one SUM away.
Is the free roster template really free?
Yes. It is a direct download – no email address, no account, no follow-up sequence. It is an ordinary .xlsx file that opens in Excel, Google Sheets or LibreOffice, and you are welcome to adapt it and share it.
Do we need to leave our volunteer centre if we adopt software?
No – keep your membership. New Zealand's 16 regional volunteer centres provide recruitment, referrals, advice and training, not coordination software, so nothing about adopting a platform replaces them. Volunteering Auckland's own advice to growing charities is to pair centre membership with a scheduling tool. Keep the membership, keep listing everywhere.
When do NZ charities usually move off spreadsheets?
The State of Volunteering 2024 report identifies organisation size as the main factor: organisations engaging more than 100 volunteers a year are more likely to use a specific volunteer management system. That threshold is roughly where an appeal campaign starts, which is why the move so often happens in the weeks before a charity's first big appeal.
Can we import our spreadsheet into PurposeTech?
Yes. The Volunteers sheet in our free template uses the fields PurposeTech's CSV importer accepts – email is the only required column; first name, last name, phone, address and adopter organisation are optional – so graduating is one upload. The importer validates every row and flags people who already exist in the system. If your existing sheet is messier than that, send it to us and we will help you load it.
Sources (last checked 3 September 2026):
- State of Volunteering in Aotearoa New Zealand Report 2024, Volunteering New Zealand, p.11 (PDF) – systems used to manage volunteers, and the 100+ volunteers/year finding
- Charities Services (Department of Internal Affairs) – keeping track of volunteer contributions, the annual-return requirements, and the free spreadsheet template
- Community Governance Aotearoa resource hub – redistributes the Charities Services volunteer spreadsheet template
- Volunteering Auckland, “Growing during expansion”, 14 July 2025 – advice to small charities on free/low-cost scheduling platforms
- Volunteering New Zealand – finding volunteer roles (the 16 regional volunteer centres)
- Volunteering Auckland membership fees ($60–$300/yr, tiered by income)
- Volunteering Canterbury membership fees ($65–$137/yr) and services
- Volunteer South – membership currently complimentary (archived 15 January 2026)
- NZ Herald – “Christchurch earthquake: students form volunteer army” (the 10,000-strong army gathered via Facebook)
- Stuff – “Student volunteer army mobilises”, February 2011
- NZ Herald – “Christchurch and the Student Volunteer Army” (Facebook plus the mobile management system GeoOP)
- NZ Geographic – “Call to arms”, on the SVA operation
- PurposeTech docs – bulk operations and CSV import
- Case study – Breast Cancer Foundation NZ Pink Ribbon Street Appeal (8,000+ collectors, 1,000+ sites)
- PurposeTech pricing page (NZD)
Volunteer centre fees are the centres' published rates and may change – confirm with your local centre before budgeting. Volunteer Wellington's fees are also tiered by income but are not quoted here, as the current figures are not published in machine-readable form.
When the spreadsheet stops fitting
Keep everything that works. When the coordination layer needs to graduate, your spreadsheet imports in one upload – pricing is published, the trial is 14 days, and no credit card is required.