Thirty names down the side, sixty days across the top, and every cell holding a P, an A, an L or an E. Turning that wall of little marks into per-student totals by hand is the kind of job that eats a Sunday — and one slipped row ruins the lot. Paste the whole grid into this attendance grid summarizer instead: it counts every code for every student, works out attendance percentages and longest present streaks, and totals each day for the whole class.
Paste a filled attendance grid copied from your spreadsheet — first column student names, one day per remaining column, tab- or comma-separated.
How the numbers work: Attendance % = (Present + Late) ÷ (Present + Absent + Late). Excused days and blank cells are left out of the percentage. Longest present streak = the longest run of consecutive Present marks. Codes the tool does not recognize are flagged below and never counted silently. Everything runs in your browser — nothing is uploaded.
How to use the attendance grid summarizer
- Copy your filled grid from your spreadsheet. The first column should hold student names and each remaining column should hold one day’s marks. Tabs or commas both work as separators.
- Paste it into the grid box above. If your first row holds dates or day names, leave the “First row holds dates” box ticked; otherwise untick it and the tool labels the days Day 1, Day 2 and so on.
- Check the code legend. P, A, L and E mean Present, Absent, Late and Excused by default, and you can edit both the codes and their meanings. Totals recalculate live as you type.
- Read the results. Each student gets Present, Absent, Late and Excused counts, an attendance percentage and a longest present streak. Below that you’ll find per-day totals for the whole class and a class-totals summary.
- Copy or download. Use Copy summary TSV to paste the table into a spreadsheet, or Download CSV to save it as a file.
Worked example: totals for 3 students over 5 days
Click Load example in the tool to try this grid yourself — it’s small enough to check by hand:
Student Mon Tue Wed Thu Fri Ayesha P P L P P Rahim P A P P E Karim P P P A P
The tool gives these exact totals:
- Ayesha: 4 Present, 0 Absent, 1 Late, 0 Excused – attendance 100%, longest present streak 2. Her late day counts as attended: (4 + 1) ÷ 5 = 100%.
- Rahim: 3 Present, 1 Absent, 0 Late, 1 Excused – attendance 75%, longest present streak 2. His excused day is excluded: (3 + 0) ÷ 4 = 75%.
- Karim: 4 Present, 1 Absent, 0 Late, 0 Excused – attendance 80%, longest present streak 3.
Per-day totals come out as: Monday 3 present; Tuesday 2 present, 1 absent; Wednesday 2 present, 1 late; Thursday 2 present, 1 absent; Friday 2 present, 1 excused.
What the attendance grid summarizer calculates
Per-student counts by code. For every student the tool counts how many times each of your four codes shows up – Present, Absent, Late and Excused by default.
Attendance percentage with a plain rule. Attendance % = (Present + Late) ÷ (Present + Absent + Late). Excused days and blank cells stay out of the percentage, so a student with excused absences isn’t penalised.
Longest present streak. The tool finds each student’s longest run of consecutive Present marks – handy for spotting reliably punctual students or for streak-based rewards.
Per-day totals and class summary. A second table shows how many students were present, absent, late or excused on each day, and a summary panel rolls everything up into class totals including the class average attendance.
Warnings instead of silent mistakes. A code the tool doesn’t recognise gets flagged per cell, with a warning count and a list of where it appeared – it’s never quietly dropped or counted as something else. Rows with missing cells are counted as blank and flagged too.
Attendance counts, percentages and streaks per student
Paste the filled grid and the summarizer returns a count, a percentage and a streak for every student. The codes stay as they are, so a present, absent and late mark each count the way you expect.
Tips for clean results
Keep one code per cell. Extra spaces are trimmed automatically and codes match regardless of upper or lower case, so “p” and “P” count the same. A cell with two codes in it, like “PA”, gets flagged as unrecognised rather than guessed at – which keeps every student’s totals unambiguous.
Use the legend when your school uses different marks. If your register uses different letters, just type them into the code boxes – the totals update straight away.
Blank cells are fine. If a student joined mid-term and has no marks for the first weeks, leave those cells empty; they count as blank and stay out of the percentage.
More classroom tools
If you plan lessons as well as registers, the School Term Lessons Planner spreads your remaining lessons across the term.
For ordering who presents when, try the Class Presentation Running Order Planner.
And when exams approach, the Exam Section Time Planner divides exam time fairly by marks.
Frequently asked questions
Which codes does the attendance grid summarizer understand?
Four codes that you define in the legend: P for Present, A for Absent, L for Late and E for Excused by default. You can change any code letter or meaning — say your school uses X for absent, just type X into the second code box and the tool counts it as absent. Anything that doesn’t match one of your four codes is flagged as unrecognised and listed with its exact row and day, so nothing is ever counted silently.
How is the attendance percentage calculated?
Attendance % = (Present + Late) ÷ (Present + Absent + Late). Late counts as attended, while Excused days and blank cells are left out of the calculation entirely. So a student with 3 presents, 1 absent and 1 excused scores (3 + 0) ÷ 4 = 75%. The exact rule is also printed inside the tool above the results.
Is anything uploaded?
No. The attendance grid summarizer runs entirely in your browser — your grid never leaves your computer, there’s no sign-up, and nothing is sent to any server. You can even disconnect from the internet after the page loads and the tool keeps working.
Can I use this to track attendance in Excel?
Yes. Paste the filled grid from Excel, and the summarizer returns per-student counts, percentages and streaks you can copy back into your sheet. There is no formula to write and no template to download.
Can I get an attendance summary for a whole class?
Yes. The summarizer turns the whole grid into a summary with one row per student, showing totals, percentages and streaks, so you can see at a glance who has missed the most days.
Privacy note: this tool processes everything locally in your browser. Your attendance data is never uploaded, stored or shared.