How to populate Group collections using a CSV import file (4345958)

How to create Group Collections via an CSV import file

1.) Create a new collection
2.) Select the new collection in the upper-right of the portal, under your login
3.) Select Dashboard in the upper-left of the main pane
4.) Locate the FILL FROM FILE option, we will need this later

To create the actual CSV file for Distribution Lists:

1.) Create a PowerShell connection to Office 365
2.) Use the following example command to obtain a list of Groups

Get-DistributionGroup | Select ExternalDirectoryObjectId, Name | Export-Csv C:\temp\DLGroupExport.csv

Note: The export location above will need to be customized for your environment. As noted in the PowerShell command above, it is the "ExternalDirectoryObjectId" that is required.

3.) The step above will create a master list of groups that you can split up as necessary
4.) Column A should be re-named to "objectId".
5.) Import the file using the FILL FROM FILE in the previous section.

A sample group collection CSV file is attached to this KB article.