Attendance Sheet Template (Free Excel)
A free monthly attendance sheet. Mark P, A, L or H per day and get present, absent, late and attendance percentage for each person.
Download the free Excel template (.xlsx)
Free. No email or sign-up needed. One Excel file, 2 sheets.
What is inside the attendance sheet template
| Sheet | What it does |
|---|---|
| Attendance | Up to 30 people by 31 days with drop-downs, color coding, counts of present, absent, late and half days, and attendance percentage. |
| Read me | Short instructions. |
Yellow cells are for your own numbers and text. Green cells calculate by themselves, so do not type over them. Sample data is included so you can see how it works, then replace it with your own.
How to use it
- Download the file and open it in Excel 2010 or later. It also opens in Google Sheets and LibreOffice.
- Replace the sample data in the yellow cells with your own.
- Read the totals and results that update automatically.
- Save a copy for each month, project or client, or print it from File > Print.
The template is free to use and edit. If you want a version built around your own process, with your branding, extra sheets or automation, tell us what you need.
Free pricing tips for your business
Get short, practical tips on pricing jobs and using our free calculators. No spam, unsubscribe any time.
Frequently asked questions
How do I make an attendance sheet in Excel?
List names down the side and mark each day. Counts and percentages are automatic.
What do the letters mean?
P present, A absent, L late and H half day.
How is attendance percentage calculated?
Present days divided by present plus absent days. Half days count as half.
Can I use it for school or work?
Yes, for classes, teams and events.
Need a custom spreadsheet built for your business?
Talk to usMore free tools: All free Excel templates · Timesheet template · Employee schedule template · Checklist template