Free Employee Attendance Tracker (Excel)
What's in the free attendance tracker
The template is a single Attendance sheet built as a grid: one row per employee, one column per day of the month (31 columns), with a dropdown in each day cell so you enter P, A, L or H instead of typing free text that could be inconsistent between employees.
It's sized for up to 30 employees and one full month per sheet — copy the tab for each new month (right-click the tab, Move or Copy) so you keep a clean history without overwriting the previous month's data.
Attendance percentage, calculated for you
For every employee row, Present, Absent and Late columns count how many of that employee's day cells match each status, and an Attendance % column divides present days by total tracked days (present + absent + late) — no manual counting across 31 columns.
This is the daily attendance sheet in excel most people are looking for when they search for a printable grid, except the counts and percentage update themselves as you fill in each day, instead of you tallying at month-end.
Daily grid, not a per-day headcount view
This tracker is built around one row per employee across the month — it does not include a separate per-day company-wide headcount row (a single 'how many people were present today' summary across all 30 employees on a given date). If you need that view, you can add a SUM formula per day column yourself.
The chart included ranks each employee's Attendance % side by side, which is the view most managers actually check: who's trending low on attendance this month, at a glance.
Who this attendance tracker is for
Small business owners and office managers running attendance manually — without a time clock system or HRIS — are the core fit. If you're tracking a team of up to 30 people and mostly need a clear monthly record for payroll or performance conversations, this sheet does the job without a subscription.
It also works well for shift-based teams (retail, restaurants, trades) where a supervisor marks attendance at the end of each shift rather than employees clocking in themselves.
How to use it
- List your employees, then mark each day's status: P, A, L or H, using the dropdown.
- Let the Present, Absent, Late and Attendance % columns calculate automatically.
- Check the attendance chart to see who's trending low across the team.
- Copy the sheet tab for each new month to keep a clean monthly history.
Download the free Free Employee Attendance Tracker (Excel)
No spam — template updates and new free templates only. Unsubscribe anytime.
PTO & Leave Tracker — with Automatic Accrual
For leave that needs real accrual math, the paid PTO & Leave Tracker ($19) handles three policies (PTO, sick, personal) with automatic monthly accrual for up to 30 employees, no macros.
See the full versionTracking PTO for a whole team?
Attendance sheets track who showed up. For planned time off - vacation, sick days, PTO accrual and approvals - LeaveSheet does it as a web app your whole team can use.
See LeaveSheet — $1.50/employee/moFrequently asked questions
Can I use this attendance tracker in Google Sheets?
Yes. Upload the downloaded file to Google Drive, then open it and choose File > Save as Google Sheets. The counts, attendance percentage and chart keep working.
Is this template really free?
Yes. You give an email address to download it, and then it's yours to use with no further cost.
How many employees and days does it cover?
Up to 30 employees, with one column per day for a full month (31 columns). Copy the sheet tab for each new month.
Does it show a daily company-wide headcount row?
No, this version is one row per employee across the month, not a per-day total-present row. Add your own SUM formula per day column if you need a daily headcount figure.
What do the P, A, L, H codes mean, and can I change them?
Present, Absent, Late, and Holiday/leave. They're set as a dropdown list you can edit if your business uses different codes (for example, adding a Remote or Sick code).