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.

Plain English. It asks follow-up questions like a real developer.

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.

Starting from Grades and attendance app

Plain English. It asks follow-up questions like a real developer.

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.

Plain English. It asks follow-up questions like a real developer.

  • 14-day free trial, no card
  • Unlimited app users
  • Live on your own domain