How to Download Attendance Reports for Microsoft Bookings Meetings
Question details
The user needs to download an attendance report showing the actual participants of a Microsoft Teams meeting that was created through Microsoft Bookings.
- Product
- Microsoft Bookings and Teams
- Device & OS
- not provided
- Scenario
- Attempting to track actual meeting attendance for a group booking event, rather than just viewing the initial registration data.
- Observed behavior
- Microsoft Bookings only displays registration information and fails to provide a report of which registered participants actually attended the associated Teams meeting.
Ensure you are logged into Microsoft Teams as the meeting organizer, as only organizers have the necessary permissions to download attendance reports.
Download the Attendance Report via Microsoft Teams
Because Microsoft Bookings cannot track actual attendance, you must use Microsoft Teams to download the attendance report either during or after the live meeting.
Microsoft Bookings currently only tracks registration at the time of booking. It does not sync back with Teams to confirm who clicked the link and joined. To get your attendance data, you need to rely on the built-in tracking features of Microsoft Teams.
Launch your Microsoft Teams desktop or web application and sign in with the account that was used to organize the Bookings meeting.
If the meeting is currently taking place, click the 'People' (Participants) icon in the top meeting controls. Click the three-dot menu (More actions) in the participants pane, and select 'Download attendance list'.
If the meeting has already concluded, go to your Teams Calendar. Double-click the meeting event to open its details, and select the 'Attendance' tab to view and download the report as a CSV file.
Analyze Your Attendance Reports with WPS Office
Once you download your Microsoft Teams attendance report as a CSV file, use WPS Office to quickly open, format, and analyze your attendee data. WPS Office is a lightweight, fully-featured suite that provides a seamless alternative to Microsoft Office.
- 1. Install WPS Office: Download and install WPS Office for free to access its powerful Spreadsheet application.
- 2. Open Your Attendance Report: Launch WPS Spreadsheet, go to 'Menu' > 'Open', and select the .CSV attendance report you downloaded from Microsoft Teams.
- 3. Sort and Filter Data: Use the intuitive 'Data' tab to apply filters, helping you easily see join times, leave times, and total duration for each attendee.
Frequently Asked Questions
Why doesn't Microsoft Bookings show actual meeting attendees?
Microsoft Bookings currently functions primarily as a scheduling tool. It captures user registration data at the time of booking but does not sync with Microsoft Teams to verify which users successfully joined the live meeting.
Can attendees download the Microsoft Teams attendance report?
No. For privacy and security reasons, only the meeting organizer and specifically designated co-organizers have the required permissions to view and download the attendance report in Microsoft Teams.
In what file format is the Teams attendance report downloaded?
The attendance report is downloaded as a .CSV (Comma Separated Values) file. You can easily open and format this file using spreadsheet software like WPS Spreadsheet or Microsoft Excel.
