Formatters & Code
Merge Teams Attendance Reports — Free Multi-Meeting CSV Merger
Merge Microsoft Teams attendance CSV reports locally. Consolidate multi-session meetings, eliminate rejoin duplicates, and export a master attendance matrix.
Attendance reports & roster
or click to browse your device (select multiple files from recurring meetings)
If provided, enrolled participants missing from an export are explicitly recorded as Absent.
Results
What the result means
Microsoft Teams generates a separate attendance CSV export for every occurrence in a recurring meeting series. This merger combines multiple attendance exports into a unified attendance matrix without uploading files to any external server. It parses standard Teams header metadata and participant lists, aggregates repeated join and leave events per participant into a single total duration, supports optional student or staff roster CSV matching to flag unexcused absences, and generates an exportable multi-session attendance register with individual dates, join timestamps, and overall completion percentages.
Related tools
Guides
Questions
How does this tool combine attendance for recurring Microsoft Teams meetings?
The merger parses multiple individual Teams attendance CSV exports, extracts meeting timestamps, links participant records using their email or display name, merges multiple join/leave events, and outputs a single combined attendance register.
What happens if a student leaves and reconnects to the meeting?
Teams exports record a new row each time someone reconnects. The merger detects these duplicate rows within the same session, calculates the first join and last leave times, and sums the active duration so each person is counted once.
Does my attendance or student data leave the browser?
No. All parsing, decoding, and matrix calculations run entirely locally in your web browser using client-side JavaScript. No participant data or meeting information is sent to our servers.