Add Bulk Members to Distribution Groups from CSV in Office 365

In the Microsoft 365 environment, administrators can easily add or remove members from distribution groups using the Microsoft 365 admin center. However, the process of adding multiple users or mail contacts to multiple distribution lists can be a time-consuming task for administrators.

Specmasoft’s Office 365 Manager tool allows for the bulk import of users or mail contacts into distribution groups from a CSV file, offering this functionality without the need for a PowerShell script.

Follow these steps to add multiple users as members to multiple distribution groups in bulk from a CSV file.

  • Launch the UI console of the Office 365 Manager application.
  • Navigate to the Exchange page within the interface.
  • Go to the Distribution Groups tab, within this tab, under the Update Members/Owners section, select the Import Members from CSV action.
  • In the next UI pop-up, click on the “Download sample CSV file” link to get a template CSV file for importing distribution group members.
  • Subsequently, replace the group name or group email address, along with the user or mail contact email addresses, in the provided sample CSV file. Alternatively, you can modify your existing CSV file to conform to the template CSV file’s format.
  • Select your CSV file by clicking on the Browse button. This action will populate the grid with the details from your CSV file.
  • Click the Import Users button to start the process of adding group memberships.
  • Monitor the progress and status of the action within the action result window. If necessary, you can export the action results by clicking the Export button.
Add Bulk Users to Distribution Groups from CSV in Office 365