Free School Management System in Excel – No Macros

A complete school management workbook built inside Microsoft Excel using nothing but native spreadsheet features — no macros, no VBA, no code. Type a student's roll number and the profile assembles itself: personal details, guardian information, attendance record and subject-wise academic performance, all driven by formulas.

What it does

The workbook ships as a set of linked sheets — Students, Teachers, Fees, Attendance, Grades, Timetable, Settings and a summary Dashboard. Because every calculation is a plain Excel formula rather than a script, the figures recalculate as you type and the file opens on any machine with Excel, with no security warning about macros and no add-in required to use it. Fees are set up in PKR against a Pakistani school structure with classes from nursery upward, and both are straightforward to change in the Settings sheet for another country or fee model.

Highlights

• Roll-number lookup that pulls a full student profile onto one screen
• Fees tracker showing paid against outstanding per student
• Daily attendance marking with totals feeding the dashboard
• Subject-wise grade entry and summary
• Weekly timetable laid out per class section
• Dashboard tying students, fees, attendance and grades together
• Fully offline — the data never leaves the file, which matters for student records

How it was made

The entire workbook was generated by Claude inside Excel from a single written prompt, including every formula. That prompt is included, so you can regenerate it, adapt it to a different institution, or use the same technique to build a workbook for another business entirely.

Who it is for

Small schools, academies and tuition centres that want student, fee and attendance records organised without buying school ERP software or putting student data online — and anyone who wants to see what an AI assistant can build inside a spreadsheet.