You might use that output in another script, but in this example we’ll create aĬustom CSV file that’s not only easy to read and edit in Microsoft Excel, butĬan also be re-imported after editing for further scripting.īefore we dive into the PowerShell scripting, we’ll take a quick look at what to expect once the output is open in Excel. Interrogate each group to retrieve membership and owner lists.

Information, and then after getting the list of groups in your tenant, The Exchange Online PowerShell module to easily collect Office 365 Group Or, you might want to simply provideĪ weekly report on Office 365 Group membership as part of your efforts to trackĪ great way to do this is by using PowerShell.

Require exports of membership information.

Membership, so that you can plan migrations and update the target groups will Office 365 migration then being able to provide reports on current group As Office 365 Groups is one of the core foundations for services like Microsoft Teams, you may need to retrieve information not only about the group, but also about group members and owners and share that with others.įor example – if you need to perform a tenant to tenant As part of day to day administration, or as part of a migration project, exporting information from your Office 365 tenant is a common requirement.

Export office 365 contacts to csv