'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Download Microsoft Entra Group Members to a CSV File
Question details
An administrator needs to export the members of a Microsoft 365 or Microsoft Entra group to a CSV file for reporting or directory management.
- Product
- Microsoft Entra
- Device & OS
- not provided
- Scenario
- An administrator is attempting to perform a bulk download of group memberships from the Microsoft 365 admin center.
- Observed behavior
- The user needs to locate the bulk operations feature and successfully generate a downloadable CSV file containing the target group's member details.
Ensure you are signed in with an account that has sufficient directory permissions, such as the Global Administrator, Groups Administrator, or User Administrator role, to perform bulk operations.
Export Group Members via the Microsoft Entra Admin Center
Use the native bulk operations feature within the Microsoft Entra admin center to safely export a complete list of group members directly into a CSV format.
Microsoft provides a built-in bulk download feature that extracts member data—including Display Name, User Principal Name (UPN), and Object ID—straight into a structured CSV file.
This process runs in the background and can handle both assigned and dynamic group memberships seamlessly.
Open the Microsoft 365 admin center in your web browser. Click on 'Show all' in the left navigation pane, then select 'Identity' to open the Microsoft Entra admin center.
In the Microsoft Entra admin center, expand the 'Groups' menu on the left sidebar and select 'All groups'.
Use the search bar or scroll through the list to find and click on the specific group whose membership you want to export.
Click on the 'Members' tab in the group's profile. From the top action menu, click on 'Bulk operations' and choose 'Download members' from the dropdown list.
Click 'Start' to begin generating the export. Once the background operation completes, a notification will appear. Click the notification or open the bulk operation results page, and select 'Download results' to save the CSV file to your local computer.
Open and Analyze Your Exported CSV Files with WPS Office
After successfully downloading your Microsoft Entra group members, you will need a robust spreadsheet application to view and manage the data. WPS Office is a highly compatible, lightweight, and free alternative to Microsoft Office that easily handles large CSV files.
- 1. Launch WPS Spreadsheet: Open WPS Office and select the Spreadsheet application from the main dashboard.
- 2. Open the CSV File: Click on 'Menu' > 'Open', browse to your computer's downloads folder, and select the Microsoft Entra bulk results CSV file.
- 3. Analyze Group Data: Use the built-in sorting, filtering, and conditional formatting tools located in the 'Data' ribbon to organize your group members and review directory information efficiently.
Frequently Asked Questions
Why can't I see the 'Download members' option in Microsoft Entra?
This typically occurs if your account lacks sufficient directory permissions. Ensure you are assigned at least the Groups Administrator, User Administrator, or Global Administrator role in your tenant to access bulk operations.
How long does it take to download a large group membership list?
The bulk download process runs in the background. While small groups are processed almost instantly, larger groups with thousands of members may take a few minutes to generate the CSV. You can monitor the progress on the bulk operation results page.
What specific user data is included in the downloaded CSV file?
The exported CSV file typically contains the member's Display Name, User Principal Name (UPN), Object ID, and their specific member type (such as User, Group, or Service Principal).
Can I download the members of a dynamic group using this method?
Yes, the bulk operations feature in the Microsoft Entra admin center supports downloading members from both assigned and dynamic groups.
