How to Enable Teams Meeting Attendance List Download in Microsoft 365
Tags: office365, outlook, modernworkplace, collaboration
Published: 2024-01-24 16:21:50

---
title: How to Enable Teams Meeting Attendance List Download in Microsoft 365
published: true
date: 2020-09-20 20:07:53 UTC
tags: Office365,Outlook,ModernWorkplace,Collaboration
canonical_url: https://blogit.create.pt/miguelisidoro/2020/09/20/how-to-enable-teams-meeting-attendance-list-download-in-microsoft-365/?utm_source=rss&utm_medium=rss&utm_campaign=how-to-enable-teams-meeting-attendance-list-download-in-microsoft-365
---

This post explains how we can enable the possibility of Meeting Organizers in [Microsoft Teams](https://www.microsoft.com/en-us/microsoft-365/microsoft-teams/group-chat-software) being able to download the meeting attendance list to Excel.

## Introduction

Recently, someone asked me if it was possible to export a Microsoft Teams Meeting Attendance List to Excel while in the meeting!

My first reaction was that I hadn’t seen that possibility in my tenant and that probably this wasn’t possible. The truth is that Microsoft Teams has added a new feature that allows organizers to download and view the attendees that are attending a meeting. However, this option is not enabled by default.

After googling a bit, I found a [Microsoft support article](https://support.microsoft.com/en-ie/office/download-attendance-reports-in-teams-ae7cf170-530c-47d3-84c1-3aedac74d310) that pointed me into the right direction.

## Pre-Requisites and How-To Steps

Unfortunetaly, this configuration isn’t available in Teams Admin Center and in order to enable this meeting policy, we have to use PowerShell.

### Pre-Requisites

The first step is to install Microsoft Teams and Skype for Business PowerShell modules:

- **Microsoft Teams** – just run the following command in a PowerShell console: Install-Module MicrosoftTeams
- **Skype for Business:** [download](https://www.microsoft.com/en-us/download/details.aspx?id=39366)and install the PowerShell Module

### How-To Steps

After installing the required PowerShell modules, we are ready for the fun part! Just run the PowerShell commands below (ensure that you run using the “Run as Adminstrator” option). In my example, I will change the Global meeting policy, that can make sense if we want to enable this policy for all users but you may want to create a new policy instead if we want to enable meeting attendance download to a restricted set of users. Check [this Microsoft article](https://docs.microsoft.com/en-us/microsoftteams/meeting-policies-in-teams#meeting-policy-settings---meeting-attendance-report) for details.

1. Import-Module SkypeOnlineConnector
2. Connect-MicrosoftTeams  
  
This step will allow ask for credentials of a Global Admin user. This authentication method works fine if you have Multi-Factor Authentication enabled (MFA) in your tenant.  
  
 ![](https://i2.wp.com/blogit.create.pt/wp-content/uploads/2020/09/Teams_Login.jpg?resize=568%2C345&ssl=1)  
3. $sfbSession = New-CsOnlineSession
4. Import-PSSession $sfbSession  
  
Lines 3 and 4 are required to avoid an error saying Get-CsTeamsMeetingPolicy is not available in the next command.  
5. Get-CsTeamsMeetingPolicy -Identity “Global”  
  
After running this command, we can see that the “AllowEngagementReport” property which enables/disables the meeting attendance download is disabled.  
  
 ![](https://i1.wp.com/blogit.create.pt/wp-content/uploads/2020/09/Teams_AllowEngagementReport_False.jpg?resize=511%2C132&ssl=1)  
6. Set-CsTeamsMeetingPolicy -Identity “Global” -AllowEngagementReport Enabled  
  
This command will enable the the meeting attendance download  
  
7. Get-CsTeamsMeetingPolicy -Identity “Global”

After running this command, we can see that the “AllowEngagementReport” property is now enabled.

![](https://i0.wp.com/blogit.create.pt/wp-content/uploads/2020/09/Teams_AllowEngagementReport_True.jpg?resize=503%2C132&ssl=1)

## Testing The Results

To test if the configuration was successful, just schedule a meeting and check if while in the meeting, you are able to download the meeting attandance list.

You now should have a new option named “Download attendance list” and you should be able to download the meeting’s attendance list. The list will contain all users that are effectively attending the meeting and will not contain the attendees that were invited that are not attending the meeting, even if they accepted the meeting request.

![](https://i1.wp.com/blogit.create.pt/wp-content/uploads/2020/09/Teams_Meeting_Presence_Download.png?resize=526%2C417&ssl=1)

## Related Articles

To learn why your business should migrate to SharePoint Online and Office 365, click [here](https://dev.to/mlisidoro/why-you-should-migrate-to-office-365-part-1-264l) and [here](https://dev.to/mlisidoro/why-you-should-migrate-to-office-365-part-2-5943).

If you want to learn how you can rename a modern SharePoint site, click [here](https://dev.to/mlisidoro/how-to-rename-a-modern-sharepoint-site-url-in-office-365-595d).

If you want to learn how to save time time scheduling your meetings, click [here](https://blogit.create.pt/miguelisidoro/2020/04/12/save-time-scheduling-microsoft-teams-meetings-using-findtime/).

If you want to modernize your SharePoint classic root site to a modern SharePoint site, click [here](https://dev.to/mlisidoro/how-to-convert-your-classic-root-site-collection-in-office-365-to-modern-sharepoint-7jo).

If you are a SharePoint administrator or a SharePoint developer who wants to learn more about how to install a SharePoint 2019 farm in an automated way using PowerShell, I invite you to click [here](https://dev.to/mlisidoro/how-to-install-a-sharepoint-2019-farm-using-powershell-and-autospinstaller-part-1-5bjp) and [here](https://dev.to/mlisidoro/how-to-install-a-sharepoint-2019-farm-using-powershell-and-autospinstaller-part-2-1b9k).

If you learn how to greatly speed up your SharePoint farm update process to ensure your SharePoint farm keeps updated and you stay one step closer to start your move to the cloud, click [here](https://dev.to/mlisidoro/how-to-speed-up-the-installation-of-sharepoint-cumulative-updates-using-powershell-step-by-step-434c).

If you prefer to use the traditional method to update your farm and want to learn all the steps and precautions necessary to successfully keep your SharePoint farm updated, click [here](https://dev.to/mlisidoro/how-to-install-sharepoint-cumulative-updates-in-a-sharepoint-farm-step-by-step-f50).

If you want to learn how to upgrade a SharePoint 2013 farm to SharePoint 2019, click [here](https://dev.to/mlisidoro/how-to-upgrade-from-sharepoint-2013-to-sharepoint-2019-step-by-step-part-1-2jkn)and [here](https://dev.to/mlisidoro/how-to-upgrade-from-sharepoint-2013-to-sharepoint-2019-step-by-step-part-2-feo).

If SharePoint 2019 is still not an option, you can learn more about how to install a SharePoint 2016 farm in an automated way using PowerShell, click [here](https://dev.to/mlisidoro/how-to-install-a-sharepoint-2016-farm-using-powershell-and-autospinstaller-part-1-54m5) and [here](https://dev.to/mlisidoro/how-to-install-a-sharepoint-2016-farm-using-powershell-and-autospinstaller-part-2-5e36).

If you want to learn how to upgrade a SharePoint 2010 farm to SharePoint 2016, click [here](https://dev.to/mlisidoro/sharepoint-upgrade-upgrading-a-sharepoint-2010-farm-to-sharepoint-2016-step-by-step-part-1-55n7)and [here](https://dev.to/mlisidoro/sharepoint-upgrade-upgrading-a-sharepoint-2010-farm-to-sharepoint-2016-step-by-step-part-2-4f18).

If you are new to SharePoint and Office 365 and want to learn all about it, take a look at these [learning resources](https://dev.to/mlisidoro/sharepoint-and-office-365-learning-resources-162e).

If you are work in a large organization who is using Office 365 or thinking to move to Office 365 and is considering between a single or multiple Office 365 tenants, I invite you to read [this article](https://dev.to/mlisidoro/pros-and-cons-of-single-tenant-vs-multiple-tenants-in-office-365-2hd9).

If you want to know all about the latest SharePoint and Office 365 announcements from Ignite and some more recent announcements, including Microsoft Search, What’s New to Build a Modern Intranet with SharePoint in Office 365, Deeper Integration between Microsoft Teams and SharePoint and the latest news on SharePoint development, click [here](https://dev.to/mlisidoro/whats-new-for-sharepoint-and-office-365-after-microsoft-ignite-2018-7ga).

If your organization is still not ready to go all in to SharePoint Online and Office 365, a hybrid scenario may be the best choice. SharePoint 2019 RTM was recently announced and if you to learn all about SharePoint 2019 and all its features, click [here](https://dev.to/mlisidoro/meet-the-new-modern-sharepoint-server-sharepoint-2019-rtm-is-here-2oak).

Happy Scheduling!

The post [How to Enable Teams Meeting Attendance List Download in Microsoft 365](https://blogit.create.pt/miguelisidoro/2020/09/20/how-to-enable-teams-meeting-attendance-list-download-in-microsoft-365/) appeared first on [Blog IT](https://blogit.create.pt).