Zoom Attendance Tool
A browser-based Zoom attendance analysis tool that lets meeting facilitators upload a Zoom attendance CSV, calculate total participant attendance time, identify who met a minimum-duration requirement, and manually combine duplicate attendees who joined under different names or devices.
Client: Internal / Public Utility Tool
Type: Browser-Based Attendance Analysis Tool
Overview
Zoom attendance reports often include multiple rows for the same participant when someone leaves and rejoins a meeting, switches devices, or joins under a slightly different display name.
For meetings tied to continuing education, training, compliance, or other credit-based attendance requirements, facilitators need a fast way to determine who was present long enough to qualify.
I designed and built a one-page web tool that allows users to upload a Zoom attendance CSV, automatically summarize attendee participation, and interactively review who met a configurable minimum attendance threshold.
The Challenge
Zoom attendance data is useful but not always easy to interpret.
Common issues include:
- Multiple join/leave records for the same attendee
- Participants joining from different devices
- Slight variations in Zoom display names
- Blank or inconsistent email fields
- Manual effort required to calculate total attendance time
- Difficulty confirming whether attendees met a required minimum duration
For facilitators, this creates unnecessary administrative work and increases the chance of errors when determining credit eligibility.
The Solution
The tool processes the Zoom attendance report directly in the browser.
Users can drag and drop a Zoom CSV file onto the page, set the required minimum attendance time, and immediately view a summarized dashboard of participants, durations, join counts, and credit status.
The system automatically groups participant records by email when available and by name when email is missing. It also allows users to manually combine attendees when Zoom records show the same person under different names.
All calculations happen client-side, so the file is not uploaded or stored.
Key Features
- Drag-and-drop Zoom CSV upload
- Automatic detection of Zoom attendance report structure
- Participant grouping by email or name
- Total attendance duration calculation
- Configurable minimum attendance threshold
- Clear “Met” / “Below” status indicators
- Manual combine and split functionality for duplicate attendees
- Timeline visualization showing when each participant was present
- Sortable attendance table
- Sticky summary controls for reviewing long attendee lists
- Browser-only processing for improved privacy
Impact
- Reduced manual attendance review effort
- Improved accuracy when calculating total attendee participation
- Made duplicate attendee handling faster and more transparent
- Helped facilitators quickly identify who met credit requirements
- Created a reusable public utility that solves a common administrative pain point
- Demonstrated how a lightweight web tool can simplify a tedious reporting workflow
This project highlights how a focused, browser-based workflow tool can turn a messy exported report into a clear, actionable dashboard without requiring accounts, databases, or file storage.