Attendance Generator
Monthly attendance sheets with automatic totals.
Generate a month-by-month attendance register with weekends and holidays pre-marked, dropdown status codes, and automatic per-employee totals for present, absent, leave and late days.
- Price
- Free
- Your files
- Never uploaded
- Runs
- In your browser
or drag it here
· up to 50 MB · processed locally, never uploaded
Excel and spreadsheet files only. Export from Google Sheets as .xlsx or .csv.
Files stay on your device
What it does well
- Weekends and holidays shaded automatically for the month you pick
- Status dropdowns with counts per code per employee
- Twelve-month workbook option with a yearly summary sheet
How to use Attendance Generator
- 1
Choose the month, year and working days.
- 2
Add your employee list.
- 3
Mark public holidays on the calendar.
- 4
Download the attendance workbook.
Watch a walkthrough
Common problems and fixes
Totals do not change when I mark attendance.
You typed a code that is not in the dropdown list. Use the dropdown, or add your custom code to the codes sheet.
Weekend shading is on the wrong days.
The week start setting does not match your region. Change it before generating — it drives the whole calendar layout.
Frequently asked questions
More templates tools
Invoices, payroll, timesheets, budgets and dashboards — every template ships with real formulas, not screenshots, and downloads as a native .xlsx.
Browse Templates