Add bulk users in a Distribution List Group

Scenario: Add bulk users to a distribution group.

Note: We need to use PowerShell.

Here are the detailed steps:

1. Prepare a CSV file to contain each user’s information, including Display name, Alias, E-mail address, and then store it in local disk (for example, D:\list.csv )

2. CSV sheet format example in words mentioned below:

Example:
Display name, Alias, E-mail address
Member1, member1, *** Email address is removed for privacy ***
Member2, member2, *** Email address is removed for privacy ***

CSV sheet format example in figure mentioned below:

3. Connect to Exchange Online PowerShell:

https://docs.microsoft.com/en-us/powershell/exchange/connect-to-exchange-online-powershell 

4. Import the CSV file to Exchange Online via PowerShell.
Run the cmdlet:
Import-Csv “D:\list.csv” | foreach{Add-DistributionGroupMember -Identity “GroupName” -Member $_.alias}

Important: Please replace “GroupName” with your actual distribution group email address.