Skip to content

Compare

Student Records: Excel or a School System? How to Decide

Excel can be enough for a small school. When Excel is fine, signals that it is time for a system by type of school, how the two differ in practice, and a first step.

In short

While few people handle the data and no approvals or change history are needed, Excel can be enough. When several people edit the same list at once, approvals must be recorded, certificates are issued often, residence-card expiry must be tracked per student, or monthly figures are reconciled by hand, it is time to consider a system.

Last updated: October 26, 2026

When Excel is fine

Some schools do not need a system. While these hold, tidying your Excel practice may be the sensible choice.

  • One or two people edit the list, never at the same time.
  • Corrections to grades or attendance need no approval record.
  • You issue a few certificates a year in a fixed format.
  • Another tool already covers messages to guardians.
  • Where files live and who may see them is settled.

What tends to go wrong with Excel

  • Files get copied and nobody knows which is current.
  • Attendance, grades and fees sit in separate files and drift with every copy.
  • Formulas and layouts depend on one person and cannot be fixed without them.
  • Restricting who sees each file is hard, and change history is rarely kept.

Signals it is time for a system, by type of school

Decide by these signals rather than by student numbers.

Several people edit the same list at once
What happensNobody knows the current version; edits disappear
Especially inVocational schools, universities, multi-classroom juku
Some records need an approval trail
What happensYou cannot show who approved a grade correction or leave, or when
Especially inVocational schools, universities, private K-12
Certificates are issued often
What happensEach one is copied from lists and grades, with no issue record
Especially inVocational schools, universities
Residence-card expiry tracked per student
What happensStudents with expiry coming up are missed
Especially inJapanese-language schools, vocational schools with many international students
Monthly figures reconciled by hand
What happensInvoices against payments and attendance rates take time every month
Especially inJuku and lesson schools, vocational schools

Excel and a system in practice

An example for comparing ways of working. Co-editing and permission features depend on the environment, product and settings for both.

Co-editing and versions
ExcelCopies cause confusion; co-editing depends on your environment
School management systemBuilt for several people using the same record
Connected records
ExcelSplit by file
School management systemEnrolment, attendance, grades and fees on one record
Data entry
ExcelRe-keying is common
School management systemInformation entered once is reused
Rights and history
ExcelUsually per file
School management systemRole-based rights and operation logs
Cost
ExcelStart with existing software
School management systemSubscription and other fees

A first step

You need not move everything at once. First remove duplicates and spelling variants and align student numbers; then move the tasks with the most re-keying.

Even if you are unsure whether to stay with Excel, writing down your current practice with the selection checklist shows where to start.

In Classio

Classio registers students in bulk from an Excel template (.xlsx, up to 5 MB and 500 rows). Rows with missing information become provisional records you can complete later.

Frequently asked questions

How many students before we need a system?
Numbers alone do not decide it. Use the signals: how many people edit at once, whether approvals must be recorded, how often certificates are issued.

Start from how you work today

Want to decide what to replace first?

Tell us the columns in your Excel list and how you use it, and we will suggest where to start.