Our spreadsheets are very messy — some have data for 5 different academic years on one sheet. Where do we start?

Start by making a copy of each spreadsheet (never clean the original), then use Excel's filter function to isolate just the current academic year's data onto a separate sheet. Migrate only the current year data first. Historical data from prior years can be addressed gradually over the next few months — there is no need to migrate it all at once.

What if our spreadsheet columns do not match the RedeemOS import template columns?

Download the RedeemOS import template CSV from Settings → Data Import and compare it to your spreadsheet columns. In Excel, you can rearrange columns by cutting and inserting to match the template order, or simply rename your columns to match the template headers exactly. If a field in your spreadsheet does not have a corresponding RedeemOS field, add it as a note on the student profile after import.

Is it possible to import a Google Sheet directly without exporting to CSV?

RedeemOS's bulk import requires a CSV or Excel file — Google Sheets cannot be linked directly. However, exporting from Google Sheets to CSV takes only seconds: File → Download → Comma Separated Values (.csv). The resulting file can be imported immediately.

We have formula-heavy spreadsheets that calculate grades automatically. Will RedeemOS replace those calculations?

Yes. RedeemOS's Examinations and Report Card modules handle grade calculations automatically based on your configured grading scale, weightings for continuous assessment versus exams, and subject combinations. You set up the grading rules once in the system settings and RedeemOS applies them consistently to every student. You no longer need to maintain Excel formulas.

Toolkit

5 phases

Excel/Spreadsheet to School Management System Toolkit

Many schools take a first step toward digitisation by building elaborate Excel spreadsheets for student lists, fee tracking, and examination scores. While better than paper, spreadsheets create significant problems as schools grow: data lives in multiple disconnected files, errors are common, sharing and permissions are uncontrolled, and generating reports requires manual effort. RedeemOS is designed to replace these spreadsheets with a connected, role-based platform. This toolkit helps you export, clean, and import your spreadsheet data into RedeemOS efficiently, and guides you through replacing each spreadsheet workflow with its RedeemOS equivalent.

For: School administrators and IT coordinators at schools currently managing student records, fees, attendance, or timetabling in Microsoft Excel or Google Sheets who want to migrate to RedeemOS without losing existing data.

Before You Start

1.A complete inventory of all spreadsheets currently in use across the school — where they are stored, who maintains them, and what data they contain
2.RedeemOS account with school profile, academic year, class groups, and subject list already set up
3.Spreadsheet administrator access: the person running this migration needs edit access to all source spreadsheets
4.Basic knowledge of Excel or Google Sheets: ability to create and use filters, sort data, and save as CSV
5.Buy-in from the staff who currently own and maintain the spreadsheets — their cooperation is essential for a successful handover

Implementation Phases

Phase 1

Week 1

Spreadsheet Inventory and Mapping

Before exporting anything, create a complete picture of what spreadsheets exist, where they are, and which RedeemOS module they map to. This prevents duplicate migrations and helps you identify data quality issues early.

Tasks

List every spreadsheet used by the school: student lists, class registers, fee ledgers, examination score sheets, timetables, staff lists, library catalogues
For each spreadsheet, record: file name, location (local drive, USB, Dropbox, Google Drive), who maintains it, last updated date, and which module in RedeemOS it corresponds to
Open each spreadsheet and assess data quality: look for empty cells that should have values, inconsistent name spelling (e.g., "Emmanuel" vs "Emmanual"), duplicate rows, and merged cells that will break CSV exports
Create a Mapping Document that shows exactly which column in each spreadsheet corresponds to which field in the RedeemOS import template (e.g., Column A "Surname" → RedeemOS field "last_name")
Flag spreadsheets that mix data for multiple academic years in the same sheet — these need to be split before import
Identify which spreadsheets are "master records" and which are copies — migrate only from master records

Tools / Modules

·Microsoft Excel or Google Sheets (source data)
·RedeemOS Data Import Templates (downloaded from Settings → Data Import)
·Mapping Document (a simple spreadsheet or table)

Phase 2

Week 2

Data Cleaning and Standardisation

Data cleaning is the most time-consuming phase but the most important. Importing dirty data into RedeemOS creates problems that are harder to fix after the fact than they are to prevent now.

Tasks

Standardise all student names: first name, middle name, last name in separate columns; no titles (Mr, Miss) in name fields
Standardise all date formats to DD/MM/YYYY — Excel often stores dates in inconsistent formats that import as numbers
Remove all merged cells from every spreadsheet that will be imported — RedeemOS CSV import cannot handle merged cells
Check for and resolve duplicate student entries: use Excel's COUNTIF function or Google Sheets duplicate detection to find students listed more than once
Ensure every student row has a unique identifier — use their admission number or, if none exists, create a temporary ID in the format YEAR-CLASS-SEQUENCE (e.g., 2023-JHS1A-001)
Standardise class names to match exactly what is configured in RedeemOS (e.g., "JHS 1A" must match "JHS 1A" not "JHS1A" or "Junior High 1A")
Validate parent phone numbers: strip spaces, ensure consistent format with country code prefix

Tools / Modules

·Microsoft Excel (TRIM, PROPER, COUNTIF, Text to Columns functions)
·Google Sheets (Remove Duplicates, CLEAN function)
·RedeemOS Data Import template as the target format reference

Phase 3

Week 2–3

Staged CSV Import into RedeemOS

With cleaned data ready, import into RedeemOS in a defined sequence. Student profiles must be imported before academic records or fee data, since those records reference the student ID.

Tasks

Export the cleaned student list from Excel as CSV (File → Save As → CSV UTF-8 in Excel; File → Download → CSV in Google Sheets)
Import students via RedeemOS Settings → Data Import → Students: upload the CSV, review the field mapping preview, and confirm the import
After student import, verify the total count of students in RedeemOS matches your spreadsheet — investigate any count mismatch before proceeding
Import fee outstanding balances using the RedeemOS Finance import template — only current-year outstanding balances need to be imported as opening balances
Import examination scores and continuous assessment records using the RedeemOS Examinations import template — import by subject and class group
Import the staff list using the RedeemOS Staff import template to create accounts for all teaching and administrative staff
After each import batch, generate a sample report in RedeemOS and cross-check it against the source spreadsheet to validate accuracy

Tools / Modules

·RedeemOS Settings → Data Import
·RedeemOS Student Information System (SIS)
·RedeemOS Finance Module
·RedeemOS Examinations Module
·CSV files exported from source spreadsheets

Phase 4

Week 3–4

Replacing Spreadsheet Workflows with RedeemOS Equivalents

The migration is only complete when staff stop reaching for the old spreadsheet and start using RedeemOS instead. This phase maps each former spreadsheet workflow to its RedeemOS equivalent and trains the relevant staff member on the new process.

Tasks

Match each deprecated spreadsheet to its RedeemOS replacement: class register → RedeemOS Attendance; fee ledger → RedeemOS Finance; exam score sheet → RedeemOS Examinations; staff list → RedeemOS HR/Staff module
Train each staff member who owned a spreadsheet on the equivalent RedeemOS module — a one-to-one walkthrough is more effective than a group session for this phase
Set a "freeze date" for each spreadsheet — after that date, no new data is entered into it; all updates go into RedeemOS only
Rename deprecated spreadsheets with a "DEPRECATED - DO NOT UPDATE - [date]" prefix and move them to an archive folder
Remove edit access from deprecated spreadsheets so that staff cannot accidentally continue updating them
Run both systems in parallel for a maximum of two weeks to build confidence, then disable the spreadsheet workflow entirely

Tools / Modules

·RedeemOS (all relevant modules)
·Google Drive or SharePoint for archiving deprecated files

Phase 5

Week 4–5

Validation, Reporting, and Handover

The final phase validates that everything is working correctly, confirms that all historical data was migrated accurately, and formally hands over system ownership to the school.

Tasks

Generate a full student enrolment report from RedeemOS and compare the total to the previous term's physical register
Generate an outstanding fees report from RedeemOS and reconcile it against the final state of the old fee ledger spreadsheet
Generate a sample end-of-term report card from RedeemOS and compare it against a paper report card from the previous term to verify grading logic and format
Conduct a two-hour walkthrough with the Head of School covering the management dashboard, key reports, and approval workflows
Document any data that could not be fully migrated and create a plan for handling it (e.g., historical exam scores older than two years stored as scanned PDFs)
Formally retire all source spreadsheets and confirm that RedeemOS is the single source of truth for all school data going forward

Tools / Modules

·RedeemOS Reports and Analytics Module
·RedeemOS Student Information System (SIS)
·RedeemOS Finance Module

Success Criteria

All currently enrolled students are importerd into RedeemOS with zero duplicate profiles and matching total count to the source spreadsheets

All current-year outstanding fee balances in RedeemOS reconcile to within zero variance against the previous fee ledger spreadsheet

All source spreadsheets are archived and flagged as deprecated — no staff member is maintaining parallel records in both systems

Every staff member responsible for a key workflow (attendance, fees, exams) has received training and can operate their RedeemOS module independently

The Head of School can generate a management dashboard report showing student enrolment, attendance rates, and fee collection status without assistance

Frequently Asked Questions

Related Resources

Student Information System

School Fee Management Software

Examination Management Software

School Report Card Software

School Attendance Tracking Software

Paper Records to Digital System Toolkit

New School Digital Setup Toolkit

Get expert implementation support

Our implementation team supports schools through every phase of this toolkit — book a demo to get started.

Book a Free Demo Start Free Trial