← The Scoliom blog

Guides

Running a school on Excel: the signs it is time to change

2 August 2026

The file is called "Students_2025-2026_V4_final(2).xlsx". It is eight o'clock, and the secretary opens it to log the week's arrivals. At the same moment, in the next office, the payments desk manager opens their own copy to record the morning's payments. Both are working conscientiously. Both are updating a different file. The gap between the two will not show today: it will surface at the end of term, when a family disputes a reminder for an amount already settled.

This scenario accuses no one. Excel was often the right choice at the start: the school had around a hundred pupils, one person kept the register, and everything fitted in a single workbook. Then the school grew. The columns multiplied, so did the tabs, and the file became, without any formal decision, the school's administrative memory. That is where the risk begins: a calculation tool has turned into a database, without a database's safeguards.

The tell-tale signs

Certain signals come up in most of the schools concerned. If you recognise two or three of them, the question deserves to be raised.

• Two versions of the same file are in circulation. One on the accounts office computer, one on the head's, sometimes a third sent by messaging app. Nobody knows which one is authoritative.
• Only one person "knows". The formulas, the colour codes, the hidden tab: everything rests on that one person. A single week's absence is enough to slow down the payments desk and enrolments.
• Outstanding balances are chased by hand. Filtering the rows, checking recent payments, writing the messages one by one, ticking a column. A whole morning every month, with a risk of error at every step.
• The start of the school year takes three weeks. Re-entering records, rebuilding the classes, carrying over the previous year's balances: the file starts again almost from scratch every year.
• The figures vary depending on who produces them. The pupil numbers announced in a meeting do not match those held by the accounts office, and nobody can explain the gap quickly.
• Nobody knows who changed what. A deleted row, an overwritten amount: without a history of changes, there is no way to trace the source.

What Excel does very well — and what it cannot do

Let us be precise: Excel remains a very good tool. For one-off analysis, it is hard to do better. Modelling pupil numbers over three years, comparing the results of two classes, preparing a table for the governing board: a spreadsheet does all this quickly and well, and it will continue to do so.

The problem is not the tool, it is the role it has been given. A school database calls for guarantees a workbook does not provide: several people working on the same records at the same time, access rights that differ by role, a history of changes, and above all a permanent link between the pupil, their family and their payments. In a workbook, a pupil is not a record: it is a row. And a row can be sorted, copied, overwritten and lost.

Changing without stopping everything

The most common fear is legitimate: "we cannot shut down the payments desk in the middle of the school year". That is true, and it is precisely why a successful move to management software does not replace everything overnight.

The sensible approach starts from what already exists. Your current files are not a problem to be thrown away: they hold the school's history and serve as the source for imports. Migration proceeds register by register — pupils and families first, then payments — keeping the old routine open until the new one has proved itself. At no point does the school stop taking payments, enrolling pupils or answering families. And Excel keeps its place: that of an analysis tool, fed by data that has become reliable.

Before any decision, the first step is to see clearly: which files exist, who maintains them, where the duplicates and the risks lie. That is the purpose of a remote assessment, carried out on your actual files, which results in a written record and a realistic order of migration. The choice of tools and the timetable come afterwards, and only afterwards. When that time comes, our guide to choosing school management software sets out the questions to ask any supplier.