Attendance sheet studio

Free Attendance Sheet Generator

Paste a roster, choose the time period and columns, and print the attendance record or export a CSV when you need a spreadsheet.

Attendance previewWeekly attendance sheet · 10 roster rows · 3 printable pages · LETTER

Classroom Attendance Sheet

July 2026 · 10 roster rows · record keeping

Class: Room 204Teacher: Ms. RiveraDate: __________________
#NameGroupMonTueWedThuFriTotalRateNotes
1Mia CarterRed group
2Noah KimRed group
3Emma WilsonBlue group
4Lucas BrownBlue group
5Ava GarciaGreen group
6Ethan LeeGreen group
7Sophia PatelYellow group
8Liam JohnsonYellow group
9Olivia SmithOrange group
10Mason DavisOrange group
Total students10
Present_____
Absent / tardy_____
Attendance rate_____%
Codes: P = PresentA = AbsentT = TardyE = ExcusedL = LateN = Note

Class roster page

Room 204 · 10 roster rows · Teacher: Ms. Rivera

#NameGroupNotes
1Mia CarterRed group________
2Noah KimRed group________
3Emma WilsonBlue group________
4Lucas BrownBlue group________
5Ava GarciaGreen group________
6Ethan LeeGreen group________
7Sophia PatelYellow group________
8Liam JohnsonYellow group________
9Olivia SmithOrange group________
10Mason DavisOrange group________

Printable attendance code legend

P = PresentA = AbsentT = TardyE = ExcusedL = LateN = Note
DailyUse for quick morning attendance, lunch count, or one-day events.
WeeklyUse Monday-Friday columns for classroom tracking.
MonthlyUse date columns and total fields for record keeping.
CSVExport blank records for Excel or Google Sheets.
Teacher admin guide

Use one roster for daily, weekly, and monthly attendance

Paste the class list once, then switch the sheet type for morning attendance, weekly records, monthly code grids, substitute folders, clubs, daycare, homeschool records, sports teams, or sign-in pages.

Choose the sheet format

Daily sheets are best for quick checkboxes. Weekly sheets keep Monday–Friday on one page. Monthly sheets add date columns, totals, and code records.

Customize the code legend

Edit P, A, T, E, L, N, or your own school codes before printing so aides, substitutes, and families read the sheet the same way.

Export when you need a spreadsheet

Print the blank sheet for binders, or download roster and record CSV files when the same list needs to move into Excel or Google Sheets.

Reuse the same roster

Use the same names for classroom name tags, desk labels, cubby labels, student badges, assignment trackers, and substitute classroom setup pages.

Attendance setup

Choose the attendance record you need

Paste the roster once, choose the time period and columns, then print the sheet or export a CSV for records you need to sort later.

Set up the sheet

  1. Paste one student per line and add a group only when the class needs sections or teams.
  2. Choose daily, weekly, monthly, substitute, homeschool, or sign-in, then keep only the codes and columns you will mark.
  3. Check the date range and totals before printing; use CSV when the record needs calculations or long-term storage.

Choose the right record

Daily sheet

Use one roster with status, lunch, dismissal, or note fields for a single day.

Weekly sheet

Use weekday columns when the same group is checked several times during one week.

Monthly sheet

Use date columns and totals for a compact month record that may later move into a spreadsheet.

Sign-in sheet

Use names, arrival time, departure time, or signatures for clubs, events, and activities.

Keep the record readable

Use a short code legend

Keep only the attendance codes staff will actually use and print the legend on substitute copies.

Separate sensitive notes

Put confidential medical, custody, or discipline information in the official system required by your school.

Export only when useful

Print for quick marking; choose CSV when you need sorting, totals, or a reusable digital record.

Attendance sheet questions

Can I make a monthly sheet from my roster?

Yes. Choose Monthly, select the month and year, and review the date columns before printing.

Can I change the attendance codes?

Yes. Edit the code and label rows so the legend matches the terms your school or program uses.

Can I open the export in Excel or Google Sheets?

Yes. Download the roster or blank record CSV and open it in Excel, Google Sheets, Numbers, or another spreadsheet app.

Can I prepare a copy for a substitute?

Yes. Choose the substitute layout and include only the roster, codes, dismissal notes, and message fields the guest teacher needs.