School Software vs Spreadsheets: An Honest Comparison

It is the second week of term. Fatima in the office has the admissions workbook open on one screen and the fee workbook on the other, and she is retyping a new student's name, class and father's phone number from the first into the second. Down the corridor, the deputy head is emailing class teachers for this week's attendance tabs because the master file has a broken formula again. Nobody is doing anything wrong. The spreadsheets are simply doing what spreadsheets do.

This post is not an argument that every school must buy software. Spreadsheets are free, flexible and familiar, and for a small school with one capable administrator they can work for years. The question is where the line sits for your school, and how to find it using evidence rather than a sales pitch. Our spreadsheets comparison page sets out the side-by-side view; this post is about testing your own situation.

What spreadsheets genuinely do well

It is worth being fair before being critical. Spreadsheets have real strengths that any replacement has to match or beat:

• No cost to start. Nobody needs approval to open a new file.
• Total flexibility. If the board wants a new column for scholarship status tomorrow, it exists in thirty seconds.
• Everyone already knows them. There is no training budget and no new login.
• They work for one-off analysis. Modelling next year's fee increase or a staffing plan is exactly what a spreadsheet is for, and it will stay useful even after you adopt a school system.

If your school has under a couple of hundred students, one person who owns the records, and few complaints from families about information, spreadsheets may still be the right answer. Be honest about that.

Where the cost hides

The trouble with spreadsheets is rarely visible on any single day. It accumulates in four places.

The same fact typed several times

A student's name, class and guardian contact typically live in admissions, fees, attendance, exam results and the transport list. Every copy is a chance for a typo, and every change (a new phone number, a class move) has to be made in every file. Count how many files contain your student list. That number is the multiplier on every update.

Nobody knows which version is right

"Fees_2026_final_v3_Kwame_edits.xlsx" is a familiar sight. When two people edit copies of a file, the school ends up with two truths, and someone spends an afternoon reconciling them.

No history of who changed what

If a fee balance changes from 12,000 to 2,000, a spreadsheet does not usually tell you who did it, when or why. For most changes this does not matter. For money, marks and attendance, it matters a great deal, and it is the first thing an auditor or an unhappy parent will ask about.

Everything waits for one person

Spreadsheets concentrate knowledge. The formulas, the colour codes and the hidden tabs make sense to the person who built them. When that person is ill, on leave or resigns, the school discovers how much it depended on them.

Five tests to run on your own files this week

Rather than debating in the abstract, run these checks. Each takes under an hour.

1. The duplicate count. Pick ten students at random. Search for each one across every file the school keeps. Note how many places each appears and whether the details match everywhere.
2. The parent question. Time how long it takes to answer "What does Amara owe, and was she in school last Thursday?" from scratch. If it needs two files and a phone call, families are waiting that long too.
3. The month-end clock. Ask the accounts team how many hours last month's fee reconciliation took, and how many of those hours were spent matching records rather than deciding anything.
4. The holiday test. Ask the person who maintains your main workbook to take a week off, and ask a colleague to produce a defaulters list without them. Note what went wrong.
5. The change trail. Pick a fee balance that changed in the last month. Try to find out who changed it and why. If you cannot, note it.

Write the results down. If most of the tests pass comfortably, keep your spreadsheets and revisit next year. If three or more fail, you have a case built on your own evidence.

What changes when you move to a school system

The main difference is not features. It is that each fact is entered once and every function reads the same record. When Fatima admits Tomasz, his class, guardian and fee plan are set once, and the attendance register, the fee ledger and the exam sheets all show the same Tomasz.

Three practical consequences follow:

• Each person sees their part. Teachers mark attendance and enter marks; the office handles fees; families see their own child's information. No one emails a master file around.
• Changes are recorded. A good system records who made a change and when, so the question "who changed this balance?" has an answer.
• Reports come from live data. A defaulters list or an attendance summary is produced when you need it, not assembled.

What does not change: you still need someone who owns the data and cares about its accuracy. Software stops copies from drifting apart. It does not stop someone entering the wrong date of birth.

Keeping spreadsheets where they belong

Moving to a school system does not mean abolishing spreadsheets. Keep them for planning, modelling and ad hoc analysis. The rule of thumb is simple: if a spreadsheet is the place where a fact about a student, family, staff member or payment is stored, it should move. If it is a place where you think about those facts, it can stay, fed by an export when you need one.

Common mistakes

• Comparing licence price with zero. Spreadsheets are free to open, but staff hours spent reconciling are not free. Compare the price with the time your tests revealed.
• Cleaning everything before deciding. Schools sometimes spend a term tidying files in preparation and then lose momentum. Clean what you will import, and do it as part of the move.
• Moving everything at once. Starting with admissions, attendance and fees, then adding exams or payroll later, is usually gentler on the office.
• Keeping the old file "just in case". If staff can still update the old workbook after go-live, some will, and you are back to two truths. Archive it as read-only.

Frequently asked questions

How big does a school need to be before software makes sense?

There is no fixed number. A small school with several campuses, transport and a busy fee office may feel the pain earlier than a larger single-site school with simple fees. The five tests above are a better guide than headcount.

Can we bring our existing spreadsheets across?

Usually yes. Student, family, staff and fee records are the typical starting point. Ask any vendor to show you how their import handles messy rows before you commit.

Next steps

If your tests point towards a change, our guide to choosing school management software walks through the full selection process. Scolvia brings student, family, staff and fee records across from spreadsheets during onboarding, and the spreadsheets comparison shows where it differs in day-to-day work.