Recently due to an O365 tenant to tenant migration, we wanted to create distribution lists that were on tenant A, on tenant B. Creating a single distribution list with number of users in M365 admin center alone is a cumbersome task. As per our requirement, DL count is more than 100 with some have more than 50 users as members.
In a scenario like this, Powershell and Excel are your friends. I will explain how I achieved the goal.