Yes. You can get a free attendance Excel template from Excel’s template gallery or create a simple tracker yourself in Microsoft Excel for Microsoft 365 on Windows. A template can record names, dates, attendance statuses, totals, and attendance rates; choose one that fits your situation and check how it treats late, excused, and blank entries before relying on its totals.
Where to find a free attendance template
In the desktop version of Excel, choose File > New and search the available templates for “attendance.” The gallery may show options for class attendance, employee time tracking, or sign-in records. Template availability and names can vary by Excel version, account, and region. Microsoft’s online template pages are another place to look; review the file details and make sure the download is an Excel workbook if you want to edit it in Excel.
You can also make a useful tracker from a blank workbook without downloading anything. That is often the clearest option when a ready-made file has unnecessary fields, an unfamiliar attendance policy, or formulas that do not match the way your group counts attendance. A free template is not the same thing as a free desktop Excel license: access to the desktop app depends on your license, while Excel for the web may be available with a Microsoft account and has some differences from the full desktop application.
What an attendance workbook should record
Start by deciding what a row represents. For a class, a row might be one student; for a workplace, it might be one employee. Put stable identifying details at the left, such as an ID and name, and put one session or workday in each date column. A month-long grid is easy to scan, while a separate row for every person and date is often better when you need detailed check-in times, locations, or reports across many months.
Before entering records, define a small set of status codes and write down what each means. For example:
- P: present.
- A: absent.
- L: late.
- E: excused absence.
Decide whether late counts as present, absent, or a separate category for the report you need. An excused absence may or may not count against an attendance percentage, depending on the relevant school or workplace policy. A blank should usually mean “not recorded” or “not yet scheduled,” not “absent.” Mixing those meanings can make a percentage misleading.
Build a basic tracker in Excel
For a monthly roster, enter an ID in column A, a person’s name in column B, and the session dates across row 1 starting in column C. Enter one status code in each person-and-date cell. For example, C1 might contain the first date and D1 the next date; row 2 would hold the first person’s attendance entries. Use actual Excel dates in the header cells, then format them as short dates or weekday-and-date labels. That makes sorting, date calculations, and later changes more reliable than typing date labels as plain text.
Add summary columns to the right of the last date. With dates and attendance codes in C:AG and the first person on row 2, the following formulas count the relevant entries:
- With that layout, enter this in AH2 to count P entries:
=COUNTIF(C2:AG2,"P"). If the row contains 18 P codes, the result is 18. - With the same layout, enter this in AI2 to count A entries:
=COUNTIF(C2:AG2,"A"). If the row contains two A codes, the result is 2. - With the same layout and only recorded session cells filled, enter this in AJ2 for the share of recorded sessions marked present:
=IFERROR(COUNTIF(C2:AG2,"P")/COUNTA(C2:AG2),0). If there are 18 P, two A, one L, and one E, the result is 18/22, or about 81.8% when formatted as a percentage.
The last formula treats every nonblank status as part of the denominator, including excused absences and late entries. If your policy excludes E from the denominator, use a different calculation. With the same C2:AG2 layout, this formula counts P as attended and excludes E from the denominator while counting P, A, and L: =IFERROR(COUNTIF(C2:AG2,"P")/(COUNTIF(C2:AG2,"P")+COUNTIF(C2:AG2,"A")+COUNTIF(C2:AG2,"L")),0). For 18 P, two A, one L, and one E, it returns 18/21, or about 85.7%. Copy the chosen summary formulas down the roster and label the columns so readers know what each figure means.
Make entries consistent and easy to review
Typing status codes by hand can lead to variants such as “Present,” “p,” or “abs.” Those may not match a formula that counts only P or A. In Excel for Microsoft 365 on Windows, select the cells where users will enter codes, then choose Data > Data Validation. Under Settings, set Allow to List and enter the permitted codes in the Source box, such as P,A,L,E. A drop-down helps people use consistent values. If your Excel uses a different regional list separator, follow the separator Excel expects in that installation.
Use conditional formatting to make patterns visible without replacing the underlying data. Select the attendance-entry range, then choose Home > Conditional Formatting > Highlight Cells Rules > Text that Contains to set a distinct fill for a code such as A. Check the rule against your actual status values and avoid color alone as the explanation: retain the letter code, use clear column headings, and consider accessible contrast. For longer rosters, select cell C2 before choosing View > Freeze Panes > Freeze Panes. This keeps the top row and the two identifying columns visible while scrolling through dates and people.
Choose a layout for your use case
A monthly grid works well when people need to mark attendance quickly and review a single month at a glance. It is less convenient for detailed reporting across a year, since dates become columns and summaries can span a wide sheet. A transaction-style log uses one row per person per session, with fields such as date, ID, name, status, and optional check-in time. That structure is easier to filter by date or person and to summarize with a PivotTable, but it takes more rows and may feel less familiar for daily manual marking.
Match the template to the question you need to answer. A teacher might need a student’s absences by term; a manager might need scheduled shifts and late arrivals; an event organizer might need a sign-in list for one day. A shift or timekeeping workbook may require clock-in and clock-out times and rules for breaks, which a simple P/A tracker does not capture. Do not treat an attendance count as a payroll timesheet or a formal record of hours worked.
Check formulas, dates, and totals
Before using a downloaded workbook, inspect its formulas and test it with a few invented entries. Confirm that a blank future date does not count as an absence, that an excused code is handled according to your policy, and that totals update when you change a status. If a workbook contains formulas that refer to a fixed date range, adding more dates may not expand the calculation automatically. Read formula ranges and extend them when necessary rather than assuming every summary includes new columns.
Also check the date headers. A date stored as text can sort differently from a real date, and a template may show a month or year that needs updating. If you duplicate a monthly sheet, update its dates and verify the totals on the new sheet. For an attendance rate, state the denominator clearly: “present / all recorded sessions” is not necessarily the same as “present / scheduled sessions excluding excused absences.” Neither convention is universally correct; the applicable policy determines which is appropriate.
Sharing, privacy, and record keeping
An attendance sheet may contain personal information, so limit access to people who need it. Before sharing a workbook, check the file’s sharing permissions and remove unrelated details. Avoid posting a public link to a roster containing names or attendance history. If you use a shared workbook, agree who can edit status entries and how corrections are recorded; unrestricted editing can make it difficult to tell whether a change was intentional.
Keep a clear backup or follow your organization’s record-retention process. Excel’s version history and recovery options depend on where the workbook is stored and how it is shared, so do not assume a file has a usable backup just because it is open in Excel. For sensitive or regulated records, follow the organization’s applicable privacy and retention rules rather than relying on a general-purpose template to provide compliance.
Excel templates compared with other options
A spreadsheet is flexible, inexpensive to adapt, and familiar to many users. It can be a sensible choice for a small class, team, or one-off event when a few people maintain the records. Its limitations become more important as the group grows: people can overwrite formulas, conflicting copies can circulate, and manual entry can be inconsistent. A dedicated attendance or timekeeping system may offer controlled roles, audit trails, check-in tools, or reports, but those features and any fees depend on the product.
Google Sheets is another spreadsheet option for browser-based collaboration, but an Excel template may not behave identically after conversion. Excel-specific formulas, formatting, or features can change when a workbook is opened in another program. If multiple people need to edit at once, test the intended workflow with a copy first and confirm that validation, formulas, and date formats carry over as expected. For a small, single-editor roster, a local Excel workbook may be simpler.
Common problems and practical fixes
- The total stays at zero: Check that the status in the cell exactly matches the value counted by the formula. Remove accidental spaces and confirm the formula points to the correct row and date range.
- The rate seems too low: Check whether blank cells, excused absences, or late entries are being counted in the denominator. Label the chosen attendance-rate definition.
- A new date is missing from totals: Expand the formula range to include that date column, then verify the copied formulas for each person.
- Dates sort incorrectly: Check whether the headers are real Excel dates rather than text. Re-enter or convert them as dates, then apply a display format.
- Different editors use different codes: Add a Data Validation list, share a short code legend, and assign someone to review unusual entries.
Frequently Asked Questions
Does Excel have a free attendance template?
Excel’s File > New gallery may include attendance templates, and free Excel-format templates may also be available from Microsoft’s online template pages and other providers. Availability can vary. You can also build a basic tracker in a blank workbook.
Can I use an attendance Excel template without Microsoft 365?
Possibly. A downloaded workbook can be opened in a compatible spreadsheet program, and Excel for the web may be an option with a Microsoft account. Some features or formatting may differ outside the desktop Microsoft 365 app, so verify formulas and layout in the program you plan to use.
How do I calculate attendance percentage in Excel?
Count the sessions marked present and divide by the sessions included under your attendance policy. The result depends on whether late or excused entries count in the denominator. Test the formula with a small example and label the rule used.
Should blank cells count as absences?
Usually not unless the organization explicitly uses blanks to mean absent. A blank can also mean the session has not happened or the entry is missing. Using a distinct A code makes those situations easier to tell apart.
Is an Excel attendance sheet suitable for employee timekeeping?
It can record basic attendance, but it may not capture all information needed for timekeeping, such as shift details, breaks, corrections, or approval records. Check the relevant workplace process and use a system designed for formal time records when required.
Related
- Excel Statistical Analysis Tools and How to Use Them
- Excel Z-Test: How to Calculate and Interpret Results
- Excel Site Analysis: Methods, Limits, and Examples
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Heat Maps: How to Create, Format, and Read ThemIn Microsoft Excel for Microsoft 365 on Windows, create a heat map by selecting a numeric range and…
- Excel Table Data Filtering: How to Narrow RowsTo filter an Excel table in Microsoft 365 for Windows, click a dropdown arrow in its header row,…
- Change Google Sheets Date Format to AustraliaTo use Australian dates in Google Sheets, open the spreadsheet in a browser and choose File > Settings.…
- Excel Flash Fill for Rows: How It Works and When to Use ItIn Excel for Microsoft 365 on Windows, Flash Fill recognizes a pattern from examples and fills matching values…
- Close Excel Without a Mouse Using Keyboard ShortcutsTo close the Excel desktop app on Windows without a mouse, press Alt+F4. If a workbook has unsaved…
- How to Remove a Section Break in Word and Keep FormattingTo remove a section break in Word, show formatting marks, select the break, and press Delete (or place…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.