← All articles

Importing past exam marks from a spreadsheet: what to check before you press save

Opero demo video: every learner accounted for on the bus
For more information, watch the Opero demo (opens YouTube). No login is needed to watch it.

A school moving to a new system does not want to lose its past marks. Teachers have kept them in spreadsheets for years. The marks can be brought across, but a careless sheet can create a mess that is hard to clean up. This article shows the layout Opero reads and the mistakes to catch in the preview.

VideoWatch Monday, Again: a 2-minute school story
Opero: fees by M-Pesa, attendance, report cards, the school bus and parents in one system, hosted in Kenya. KSh 250 per learner per term. Watch on YouTube.
A short cartoon, not a real school.

What shape should the sheet have?

The shape most teachers already use. One row for each learner. One column for each subject. One sheet for each exam.

Adm NoNameMathematicsEnglishKiswahili
ADM-001Example Learner827568

The exam name and the total marks are typed once on the screen, not repeated in the sheet. That is why one sheet must be one exam. A sheet that mixes Mid-term and End-term marks must be split first.

Opero reads the admission number column, and takes every other column as a subject, apart from a list it ignores: name, class, stream, year, term, position, rank, total, average, mean, points, comment and remarks. So a total or an average column does no harm. A heading that is not a subject name, such as "Science marks" when your subject is called "Science", is read as an unknown subject.

What should be ready in Opero first?

Two things, or the preview will refuse rows.

  1. The learners must already be imported, each with a class. A mark for an admission number that matches nobody is refused. So is a mark for a learner with no class.
  2. The subjects must exist in Opero, spelled the way the sheet spells them. A column heading that matches no subject gives an error on every row under it.

What does the preview check?

The preview writes nothing. It checks every mark and tells you:

CheckWhat you see
Admission number not on the rollThe row is refused with a message
Subject column not known to the schoolEvery mark under it is refused, and the subject is named
A mark above the "marked out of" figureThe mark is refused, and it names the limit
A mark that is not a number, such as ABSRefused, with advice to leave the cell empty
A negative numberRefused
Learner withdrawn or transferred outNot matched, the row is refused

A mark sheet marked out of 50 but loaded as out of 100 is not caught by the maximum check, because every mark would pass. Type the right figure on the screen. It is the one number the preview cannot guess.

What about blank cells?

An empty cell is treated as "did not take this subject", not as zero. A zero would drag an average down and look like a fail. Opero does the safe thing. That means you must clean the sheet. If a learner was absent, delete ABS and leave the cell empty. If a learner scored a real zero, type 0.

What gets created?

One assessment for each class and subject on the sheet, named with your exam title, and the marks under it. A sheet with three classes and four subjects makes twelve assessments. The code reads each mark as a whole number, so a mark like 72.5 is rounded. Check any decimals before you upload.

The import does not publish the results. That is on purpose. The families have already seen these marks in the old system, and publishing would announce last year's results as new. The head teacher can publish them later if the school wants them in the portal.

Who can run the import?

The right to create assessments and enter marks is needed. The head teacher has it. Every teacher has it too, but a teacher's import covers only the classes and subjects they are allocated. The preview lists what is "not yours", and the rest is left out, with a message for each row. If you want one person to load the whole school, let the head teacher do it.

Two cautions

  • We found nothing in the code that stops the same sheet being imported twice. A second import would create a second set of assessments. Import once, and note the exam title and date.
  • Check the sheet against the original on paper for a few learners. A preview confirms the sheet is readable. It cannot confirm that the marks are right.

What next, after the marks are in?

For how marks turn into report cards during a term, read how CBC report cards can be done without the last-minute rush.

Frequently asked questions

Can I import several exams in one file? No. One sheet is one exam. Load each exam on its own, with its own title and its own marked-out-of figure.

What happens to a learner who was absent? Leave the cell empty. A blank is not a zero. Opero refuses text such as ABS.

Will parents get a notice about the imported marks? Imported marks are not published. Nothing reaches parents until the head teacher publishes them.

What if one mark is wrong after the import? Fix the sheet before you save. We did not find a one-step undo for an import in the code, so do not count on fixing it afterwards.

Does Opero accept Excel and CSV files? Yes, both. Use one header row and the first sheet of the file.

Next step: See Opero's price and Ask for a demo.

Sources: Opero's own product code, checked on 18 November 2026 (past results import, mark entry and role rights). The sheet in the example uses made-up names and marks. No outside law or statistic is quoted. Written by the Opero team.

Importing past exam marks from a spreadsheet: what to check before you press save | Opero