Auto Attendance

Saba Ahmed 0 Reputation points
2026-04-13T05:20:23.8666667+00:00

Is it possible that we are able to get a consolidated file that consist of the montly report of the online classses conducted via Teams?

Microsoft Teams | Microsoft Teams for education | Meetings and calls | Other
0 comments

3 answers

Sort by: Oldest
Most helpful Newest Oldest

  1. AI answer

    2026-04-13T05:20:33.81+00:00

    A single, automatic monthly “consolidated” attendance file for all Teams classes is not available directly in Teams.

    For Microsoft Teams meetings and classes, attendance is provided per meeting instance:

    1. For each class session, the organizer or co-organizer can download an attendance report:
      • During the meeting: open People → More actions → Download attendance list.
      • After the meeting: go to Chat → open the meeting chat → Attendance tab → Download (.csv file).
    2. To get a monthly view, export the attendance report for each class meeting and then manually consolidate the .csv files (for example, in Excel or Power BI) into a single monthly report.

    For education tenants, Insights’ Digital activity report can show meeting attendance and duration over a selected time range (for example, a month), but it is a visual/reporting view inside Insights, not a single downloadable “all-classes” attendance file. Data may take several hours (up to 24 hours) after a meeting to appear.

    If a consolidated, automated monthly file is required, it must be built by combining the per-meeting attendance .csv exports or by using Insights data in a reporting tool.

    References:

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

  2. Darren-Ng 12,770 Reputation points Microsoft External Staff Moderator
    2026-04-13T06:05:55.6833333+00:00

    Dear @Saba Ahmed,

    Thank you for posting your question in the Microsoft Q&A forum.

    Based on your description, you wonder if it is possible to generate a consolidated monthly report for all online classes conducted via Microsoft Teams.

    Unfortunately, Microsoft Teams does not provide a built‑in consolidated monthly report of all meetings/classes in a single file by default.

    However, here are some workarounds you can refer to:

    Attendance Report for Each Online Class

    You can refer to this article Manage meeting attendance reports in Microsoft Teams

    This report can be:

    Viewed during or after the meeting

    Downloaded from the Attendance tab of the meeting invite or meeting chat

    Exported as a.CSV file (Excel‑readable)

    For recurring classes, Teams generates:

    A separate attendance report for each instance of the recurring meeting series

    Or you can contact to your IT/admin to do organizational‑Level Usage Reports:

    You can give your IT these articles for reference

    Microsoft Teams analytics and reporting

    Microsoft Teams webinar usage report

    Besides that, in case you need this feature and want to help Microsoft improve this update, I recommend submitting it through Microsoft Ideas · Community, which is the official feedback channel reviewed by Microsoft's engineering and product teams. If multiple customers submit the same idea, it can increase the likelihood that it will be considered in future updates.

    How to submit your feedback:

    Go to Microsoft Ideas · Community

    Select Send Feedback

    Share your idea and describe how it would improve your experience

    Once submitted, your feedback will be reviewed by the responsible engineering teams and may be considered for inclusion in future product enhancements.

    I hope information above meet your expectations, please feel free to reach out if you have any other questions.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    Was this answer helpful?

  3. Oliver Bennett 0 Reputation points
    2026-08-07T08:38:53.61+00:00

    Currently, Teams does not offer a native feature to automatically export a single consolidated monthly attendance file for recurring classes. However, you can manage and streamline this workflow with a few options:

    Use Microsoft Viva Insights: If your school tenant has Insights enabled, navigate to the Class Insights tab in your team channel. It gives a visual overview of student engagement and attendance trends over a custom 30-day window.

    Consolidate with Power BI / Excel: Download the individual .csv files from each class session's Attendance tab, place them into a single OneDrive folder, and use Power Query in Excel to combine them automatically into a master monthly sheet.

    Automate via Power Automate: You can set up a basic flow that triggers whenever a meeting ends to push attendance data directly into a master SharePoint list or Excel table.

    For teachers or students tracking class attendance thresholds against strict school policies, relying on manual file merging can be tedious. Using an online attendance calculator makes it much simpler to input total classes held versus attended, helping you instantly calculate exact percentages and required attendance targets without constantly sifting through raw log files.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.