Systems & Ops
When to move off spreadsheets: the five signals
Spreadsheets are the right tool - until they aren't. Five signals that your organisation's data has outgrown them, what each one is quietly costing you, and the three situations where staying put is the smarter move.
By Arvind Eshwarlal · 12-09-2026 · 7-min read
It's report week. A funder wants one number by Friday: how many children completed your programme this quarter.
The number exists - in pieces. A master spreadsheet on the programme lead's laptop. An attendance register in the field office. A volunteer's Google Sheet that nobody has updated since August. A WhatsApp group named "final" in which three versions of the answer are being debated right now. Your NGO's data isn't missing. It's scattered. By Thursday you have a figure. By Friday you're confident enough to send it. Mostly.
If you run an education or sports-for-development organisation in India, some version of this scene is your quarter. So let's answer the practical question underneath it: at what point do spreadsheets stop being the right tool - and how would you know?
First, the case for spreadsheets
Most articles like this skip it, so let's be honest about what spreadsheets do well. They're free. Everyone on your team already knows how to use them. They bend to whatever shape your programme takes this month. For a small team running a stable programme, a well-maintained set of spreadsheets is a perfectly good system - often a better one than software, because software brings cost, training time, and a new dependency on whoever sold it to you.
So the question is never "are spreadsheets bad?" They aren't. The question is whether your organisation has crossed the line where the workarounds cost more than a system would. Here are the five signals, in the order they usually arrive.
The five signals
Signal 1
Two people, two numbers
Someone asks for last month's participant count. Two staff members pull it independently - and come back with different numbers. Both defensible. Neither exactly wrong. One worked from the master sheet; the other from a copy that has been circulating since the last review.
What it means: Your data has forked. There is no single version of the truth anymore - there are versions, and someone is about to make a decision on the wrong one.
What it costs: Not the hours. The credibility. The day a board member or CSR partner spots the mismatch is the day every future number you present carries a silent asterisk.
Signal 2
One person holds the system
Every organisation has one: the person who knows where everything is. The formulas make sense to her. The tab names, the colour codes, the "don't touch column F" rules - none of it is written down, because none of it needed to be. Ask what happens if she leaves, and the room goes quiet.
What it means: You don't have a data system. You have a data person, and the system lives in her head.
What it costs: Invisible on normal days, catastrophic on the day she resigns. Organisations lose months of programme history to a single unarchived personal laptop.
Signal 3
Every report is a construction project
When a funder report is due, normal work stops. Someone spends a week copying from registers into sheets, from sheets into slides, reconciling as they go. The report gets done - it always gets done - but the organisation has just spent 30 to 40 staff-hours producing information it should have been able to simply look up.
What it means: You're paying a recurring tax, four times a year, in your most senior people's time.
What it costs: Run the arithmetic. Two staff spending five days per quarter on reporting is roughly 40 days a year - most of a hiring month - spent on work no donor is funding you to do.
Signal 4
The field arrives late
Your coaches and field workers fill registers on paper. The pages reach the office weekly, sometimes later. Someone re-types them. By the time the information is usable, the session it describes happened two weeks ago. A child who stopped attending gets noticed three weeks after she stopped.
What it means: Your decisions run on stale data, and your earliest warning signals - dropout, disengagement - arrive only after they've stopped being signals.
What it costs: The thing that's hardest to put a number on. The participant you could have caught.
Signal 5
The question you couldn't answer
A donor asks: "What actually happened to the children from last year's cohort?" It's a fair question. It is, arguably, the question the funding exists to answer. And it takes your team nine days to answer it badly - because last year's records are three spreadsheets deep and partly in someone's inbox.
What it means: Your organisation can describe activity, but not outcomes. Funders are steadily moving from the first question to the second.
What it costs: At best, an uncomfortable meeting. At worst, a renewal that goes to the organisation that could answer.
So you recognise two or three of these. Now what?
The instinct - and every vendor will encourage it - is to go shopping for software. Resist that for one more paragraph, because moving off spreadsheets is a sequence, not a purchase.
- Standardise first. One participant list, with a unique ID for every person you serve. One standard way attendance is recorded. One place reports are built from. This costs nothing, and it decides whether any future tool works - a tool can only organise data that follows a pattern.
- Then decide build versus buy. Often the right answer is a ₹500-a-month existing tool, not a custom platform. Sometimes it's a simple system built around how your team actually works. A proper assessment tells you which - before you spend, not after.
- Involve the people who'll use it. Tools chosen in the head office die in the field. If the coaches and coordinators didn't help choose it, adoption was never going to happen.
The order matters more than the tool. In one of the largest digitisation projects our founder led - operations across 700+ villages in six states - a fifth of the efficiency gains were found on a whiteboard, in process mapping, before a single line of software was written. Standardise first, and whatever you adopt has something clean to hold. Buy first and standardise never, and you get the platform nobody updates.
You don't move off spreadsheets when they stop working. You move when the workarounds start costing more than the system would.
Three situations where you should stay - for now
Because honesty cuts both ways, here's when moving off spreadsheets is the wrong call:
- Your data isn't standardised yet. Moving messy data onto a platform doesn't clean it. It makes the mess faster, and more expensive to fix.
- Your team hasn't been part of the decision. Software imposed from above gets politely ignored, and in six months you'll own an expensive archive of good intentions.
- There's no maintenance answer. Every system needs someone to update it, fix it, and answer questions about it. If there's no budget line and no owner, you're pre-ordering tomorrow's abandoned tool.
If any of these is you: run the three standardisation habits for a quarter, then revisit. That is genuinely the fastest path to being ready - and it's free.
The question underneath the question
The honest version of this decision isn't "spreadsheets versus software." It's smaller, and it happens weekly: does the right information reach the right person at the moment they need it? When the answer starts coming back "not usually," the five signals above tell you what's breaking first - and what to fix before anything else.
If you want a structured read on where your organisation stands, our Tech Readiness Checklist scores you on seventeen questions in this spirit - five minutes, an honest result either way. Including, sometimes, the result that says: stay put a little longer.
Arvind Eshwarlal is the founder of Communittii. He has spent over a decade inside India's social sector - education, livelihoods, safe drinking water - and fifteen years building companies and products, with senior stints at Akamai, LinkedIn, and Gloat along the way.
Before you spend a rupee on software
Take the 5-minute Tech Readiness Checklist - or talk it through with us first. The call is free, and honest even if we never work together.