AnyTool
Your files never leave your device. All processing happens locally in your browser.

How do I create a monthly attendance sheet (names × days register) online for free?

Open AnyTool’s Attendance Sheet Generator, choose employee or class mode, type the organisation / school, the department / class and a sheet title, then pick a month and year — the columns become that month’s real days (1–31) with weekday letters, and the weekend days you choose are shaded. Add people (type them in, or paste a list of names with optional IDs) and you get a grid of names down the side and days across the top. Click any cell to cycle the code — P (present), A (absent), L (leave), HD (half day), S (sick), H (holiday) or WO (weekly off) — or use a row menu to mark a whole person, or mark everyone at once. The tool counts each code per person, shows present / absent / leave totals and an attendance % over working days, and a daily present row. Download a clean landscape PDF, print the grid, or export a CSV (name, every day and the totals). Everything runs in your browser and is never uploaded. It is a register you fill in yourself, not biometric or automated attendance, so keep your official HR or school system as the system of record.

  • Employee or class mode — columns become the chosen month’s real days with weekday letters
  • Click a cell to cycle codes P / A / L / HD / S / H / WO; mark a row or everyone at once
  • Weekend days you pick are shaded and can default to Weekly Off
  • Per-person present / absent / leave totals + attendance %, plus a daily present row
  • 100% client-side — names & attendance never leave your device; landscape PDF, print or CSV

What is

Attendance Sheet Generator

An attendance sheet generator is a tool that builds a monthly attendance register — a grid whose rows are people (a name plus an optional ID or roll number) and whose columns are the days of a chosen month — and lets you mark each cell with a short code such as P (present), A (absent), L (leave), H (holiday), WO (weekly off), HD (half day) or S (sick). It shades weekends, counts each code into per-person totals (present / absent / leave) and an attendance percentage over working days, shows a daily present-equivalent row, prints a legend, and exports the register as a downloadable landscape PDF, a printable page or a CSV. It is a register you fill in by hand, not a biometric, card-swipe or automated attendance system.

Document Generator

Related terms

Attendance RegisterAttendance SheetRoll CallPresentAbsentLeaveHalf DayWeekly OffAttendance PercentageMuster RollCSV ExportPDF Export

Frequently Asked Questions

P is present, A is absent, L is leave, H is holiday, WO is weekly off, HD is half day and S is sick — a common convention you can adapt to your own policy.

On an attendance register each cell carries a short code: P = Present, A = Absent, L = Leave, HD = Half day, S = Sick, H = Holiday and WO = Weekly off. These are a widely used convention rather than a fixed standard, so organisations adapt them to their own leave policy (some add codes such as paid leave, casual leave or tardy). AnyTool’s Attendance Sheet Generator prints the legend on the sheet, lets you click a cell to cycle through the codes, and counts each code per person. The attendance percentage is computed as a present-equivalent (present counts as a full day, half day as one half) over the working days — the days that are not a holiday or weekly off — which may differ from how your payroll or school calculates it.

Yes. It is free with no signup, and names, IDs and the attendance you mark are processed only in your browser — nothing is uploaded.

AnyTool’s Attendance Sheet Generator is completely free with no account, no watermark and no sign-up wall. The register is assembled and the PDF and CSV are built entirely on your device with a local engine, so names, IDs and every attendance mark never leave the browser. An optional “Save draft” keeps a copy only in this browser’s local storage, which you control and can clear with Reset, and the page works offline once cached. Attendance data about real people is sensitive, and here it stays with you.

A header with the organisation / class and month, a name (and optional ID) column, one column per day of the month with weekday letters, and per-person totals plus an attendance %.

A monthly attendance register usually opens with a header carrying the organisation or school, the department or class and the month and year. Down the side is a row per person with their name and an optional employee ID or roll number; across the top is one column for each day of the month (1 to 28–31) with the weekday letter, and weekends are shaded. Each cell holds an attendance code, and a legend explains them. On the right, per-person totals count present, absent and leave days and an attendance percentage; a row at the bottom can total how many people were present each day. AnyTool’s Attendance Sheet Generator provides all of these and updates the totals live, in both an employee and a class/student layout.

No. It is a register you fill in by marking cells yourself; it does not detect who was present and is not the system of record — keep your official HR or school system for that.

The Attendance Sheet Generator produces a register that you fill in by marking each cell — it is not a biometric, card-swipe, GPS or automated attendance system, it does not sense, detect or verify who was actually present, and it cannot prevent a day being marked incorrectly. It is a clean, shareable record, not the authoritative source: your official HR or school attendance system should remain the system of record. The codes and legend are a convention you adapt to your own policy, and the attendance percentage is a simple present-equivalent over working days that may differ from your payroll or school’s method. This tool produces a document, not HR, payroll or legal advice.

Detailed Explanation

How It Works

In-Browser Monthly Attendance Register (Names × Days Grid)

AnyTool’s Attendance Sheet Generator builds a monthly attendance register — a grid whose rows are people and whose columns are the days of a chosen month — entirely in the browser. The user picks employee or class mode, an organisation / school, a department / class and a month + year; the columns then become that month’s real days (1–31) computed with calendar date math (new Date(year, month+1, 0).getDate()), each labelled with its weekday letter, and the weekend days the user selects are shaded and can default to Weekly Off. People are added by typing or by pasting a list of names with optional IDs. Each cell is marked with a short code — P (present), A (absent), L (leave), HD (half day), S (sick), H (holiday) or WO (weekly off) — by clicking to cycle the codes, by a per-row menu, or by marking everyone at once. The tool counts each code per person, computes an attendance percentage as a present-equivalent (P = 1, HD = 0.5) over the working (non-holiday, non-weekly-off) days, and shows a daily present-equivalent row. A landscape PDF is assembled client-side with pdf-lib, a CSV can be exported, and the grid is itself the live, printable surface.

  • Attendance register = rows are people (name + optional ID), columns are the days of a month
  • Employee or class mode; columns are the chosen month’s real days with weekday letters
  • Codes P / A / L / HD / S / H / WO marked by clicking a cell to cycle, a row menu, or mark-all
  • Weekend days the user picks are shaded and can default to Weekly Off
  • Per-person present / absent / leave totals + attendance % over working days; daily present row
  • Landscape PDF via pdf-lib (A4 / Letter / A3 / Legal) + CSV + print, all in the browser
Methodology

Codes, Totals and the Attendance Percentage

For each person the register reduces over the month’s days, tallying every code into counts and a present-equivalent. Present (P) contributes a full credited day, half day (HD) contributes one half; leave (L), absent (A) and sick (S) contribute none but still count as working days; holiday (H) and weekly off (WO) are excluded from the working-day denominator entirely. The attendance percentage is therefore credited days ÷ working days × 100, rounded for display and colour-coded (green ≥ 75%, amber ≥ 50%, red below). A daily total row sums the present-equivalent across all people for each day. The landscape PDF draws an ATTENDANCE REGISTER wordmark with the month, the organisation / class header, a column-header band of day numbers and weekday letters (weekends shaded), one row per person with coloured code cells and the name / ID, a legend, the present / absent / leave / % totals columns, a daily present row, a prepared-by signature line and a per-page footer; long rosters page-break and repeat the column header. The CSV writes the name, ID, every day’s code and the per-person totals (including half-day, sick, holiday and weekly-off counts, working days and attendance %), plus the daily present row, with RFC-4180 quoting and a UTF-8 BOM.

  • Attendance % = credited days (P = 1, HD = 0.5) ÷ working (non-holiday, non-WO) days × 100
  • Per-person counts for every code; daily present-equivalent row across the roster
  • PDF: wordmark + header, day/weekday column band, coloured code cells, legend, totals, footer
  • Long rosters page-break in the PDF and repeat the day-column header
  • CSV (UTF-8 BOM, RFC-4180): name, ID, each day’s code, all totals + daily present row
Privacy & Security

Privacy and Honest Limits: a Register You Fill In, Not Biometric Attendance

Because names, IDs and every attendance mark are processed only on the device and the PDF and CSV are produced locally with pdf-lib and a CSV builder, nothing is uploaded, logged or stored on a server, and the tool works offline once cached; an optional draft lives only in this browser’s localStorage. The page is explicit that this is a register the user fills in by marking cells: it is not a biometric, card-swipe, GPS or automated attendance system, it does not sense, detect or verify who was actually present, and it cannot prevent a day being marked incorrectly. It is therefore a clean, shareable record rather than the authoritative source — the user’s official HR or school attendance system should remain the system of record. The codes and legend are a convention to adapt to one’s own leave policy, and the attendance percentage is a simple present-equivalent that may differ from a payroll or school’s method; the tool produces a document, not HR, payroll or legal advice.

  • No upload of names, IDs or attendance marks — all processing is on-device
  • Attendance PDF and CSV generated locally with pdf-lib / a CSV builder
  • Optional draft stored only in this browser’s localStorage; works offline after first load
  • Honest: a register you fill in, NOT biometric / card-swipe / automated attendance
  • Not the system of record — keep your official HR or school system; codes are customisable
Attendance register creation: in-browser (AnyTool) vs typical online attendance tools
CapabilityAnyToolTypical online attendance tools
ProcessingRuns in your browser, no CDNOften server-side / account-based
PrivacyNames & attendance never uploaded; offline-capableData usually sent to and stored on a server
GridReal month days (1–31) with weekday letters, weekends shadedSometimes a fixed or generic grid
ModesEmployee and class/student layoutsOften one fixed format
CodesP / A / L / HD / S / H / WO, click-to-cycle, customisable legendOften present/absent only
TotalsPer-person present / absent / leave + attendance %; daily present rowSometimes a present count only
ExportLandscape PDF (pdf-lib) + CSV + print, all client-sideServer-rendered; CSV sometimes gated
Cost / signupFree, no signup, no watermarkOften requires an account or paid upgrade
HonestyStates it is a register you fill in, not biometric/automated attendanceRarely stated

AnyTool assembles every attendance register, its PDF and its CSV locally in the browser and uploads nothing.