Student grades and attendance spreadsheet template. Free, and ready to become an app.
One workbook for a class or a small school: every student with their grade level and enrollment date, a grade for each class and term with the teacher's comment, a daily attendance log marked Present, Absent or Tardy, the class schedule with teachers and rooms, and a list of the reports you run. Download it free. When teachers should take attendance from their own classes, and parents should see only their own child's grades, describe the same structure to Tadabase AI and it builds the grades and attendance app.
Excel · Google Sheets · Numbers · 5 sheets
Rather have it as an app? Describe it — we’ll build it now.
Same structure as the spreadsheet, plus logins, roles and workflows. Free to start.
5 sheets, already linked by ID.
Each sheet is one kind of record. The ID columns are how the sheets point at each other, and they are the same links the app version turns into real relationships.
-
Students
One row per student with their grade level, birthdate, email, phone and enrollment date.
Student ID · Name · Grade Level · Birthdate · Email · Phone · Enrollment Date
-
Grades
A grade per student, class and term (for example Q1 2025), with the teacher and a comment such as "Good participation".
Grade ID · Student ID · Class · Teacher · Term · Grade · Comments
-
Attendance
A daily log: which student, the date, a status of Present, Absent or Tardy, and a remark like "Late by 15 minutes".
Attendance ID · Student ID · Date · Status · Remarks
-
Classes
Each class with its teacher, its weekly schedule (for example Mon/Wed/Fri 9:00 AM to 10:00 AM) and its room.
Class ID · Class Name · Teacher · Schedule · Room Number
-
Reports
A list of the reports you produce, such as Grade Summary or Attendance Trends, with who generated each one and when.
Report ID · Report Name · Generated By · Generated Date · Remarks
Fine for one person. Hard for a team.
Where the spreadsheet starts to cost you time once more people depend on it.
-
The attendance dropdown stops after the sample rows
Present, Absent and Tardy are a dropdown only on the three example rows. From the fourth entry on, anyone can type "P", "late" or "here", and a count of absences no longer adds up.
-
Nothing is calculated
The workbook has no formulas. Reports lists report names, not reports: no attendance rate, no count of absences per student, no term average. Grades are letters typed as text, and a grade names its class and teacher by hand instead of pointing to the Classes sheet.
-
Sharing it shares every student
To show one parent their child's grades you would have to send the whole file, with every student's grades, birthdate, email and phone. And two teachers taking attendance in the same copy at once overwrite each other.
Same structure, with logins and automations.
Start from a real prompt, change anything that doesn’t fit, then build it.
Loads this prompt into the prompt box- Grades and attendance app A grades and attendance app for a school with students, parents, teachers, classes, enrollments, grades and attendance. Each class has a teacher, a schedule and a room, and students enroll in classes. Teachers log in, see only their own classes, take attendance for a class each day (Present, Absent or Tardy, with a remark) and enter a grade and a comment for each student per term. Parents log in and see only their own children's grades and attendance. Email the parent when their child is marked absent. The office sees each student's attendance rate for the term and a list of students with three or more absences this month.
- Gradebook with weighted categories A gradebook for teachers — each class has assignment categories (homework, quizzes, tests) with a weight; each assignment has a due date and a maximum score; the teacher enters a score for every student; the term grade is the weighted average converted to a letter grade; students see only their own scores and term grade; and the teacher can produce a PDF report card for each student at the end of the term.
- Absence follow-up An absence follow-up app for a school office — each absence is marked excused or unexcused with a reason and an optional note from the parent; every morning the office gets a list of yesterday's unexcused absences; parents can log in and submit an excuse for their own child only; and a student who reaches five unexcused absences in a term is flagged for a call home, with the call and its outcome logged.
Starting from Grades and attendance app
Opens the builder with your prompt. Free for 14 days, no card needed.
Questions about this template.
Is the spreadsheet template really free?
Yes. It is a normal .xlsx file that opens in Excel, Google Sheets or Numbers. No sign-up is needed to download it.
Does it work as a grades and attendance template in Google Sheets?
Yes. Upload the .xlsx to Google Drive and open it with Google Sheets, or use File, then Import, in a blank sheet. Every sheet comes across with its columns and sample rows.
Does the spreadsheet calculate attendance percentages or grade averages?
No. The file has no formulas, and grades are letters typed as text. In the app, the attendance rate and the counts of absences per student and class are worked out from the attendance records, and the gradebook prompt above computes weighted term grades.
Can parents and students see only their own grades?
Not in the spreadsheet. In the app, yes: the AI sets up a parent role that sees only their own children, a student role that sees only their own record, a teacher role limited to their own classes and an office role that sees everything. That rule is enforced on the server for every record, not by hiding rows.
Can I bring the data I already have in the spreadsheet?
Yes. Once the app is built, import each sheet into the matching table from a CSV or Excel file. The importer maps your columns to the fields and shows any row it could not bring in, and why.
When should I move from the spreadsheet to an app?
When more than one person edits it, when someone outside your team needs to see part of it, or when you start copying rows between tabs by hand. Those are the points where a spreadsheet starts losing data quietly.
Keep the structure. Lose the copy-paste.
Describe the app the spreadsheet was trying to be. Tadabase AI builds it with real logins, roles and workflows, and you can try it free for 14 days.
- 14-day free trial, no card
- Unlimited app users
- Live on your own domain