{"id":1732,"date":"2019-06-26T06:05:21","date_gmt":"2019-06-26T11:35:21","guid":{"rendered":"https:\/\/www.filerepairtools.com\/tips\/?p=1732"},"modified":"2019-06-26T06:05:21","modified_gmt":"2019-06-26T11:35:21","slug":"easy-method-to-export-office-365-distribution-group-members-to-csv-file","status":"publish","type":"post","link":"https:\/\/filerepairtools.com\/tips\/easy-method-to-export-office-365-distribution-group-members-to-csv-file\/","title":{"rendered":"Easy Method to Export Office 365 Distribution Group Members to CSV File"},"content":{"rendered":"\n<p>While migrating from One Office 365 to another Office 365 platform, organizations make sure that each and every piece of information is transferred. Individuals working in Microsoft Teams have important Office 365 Group Members features. When these groups are transferred it is necessary to transfer the related information too. Users can export the office 365 distribution groups to CSV files using Powershell and Exchange Admin Center.<\/p><div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_1 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/filerepairtools.com\/tips\/easy-method-to-export-office-365-distribution-group-members-to-csv-file\/#Export_Distribution_list_using_Office_365_Admin_Center\" >Export Distribution list using Office 365 Admin Center<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-1'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/filerepairtools.com\/tips\/easy-method-to-export-office-365-distribution-group-members-to-csv-file\/#Conclusion\" >Conclusion<\/a><\/li><\/ul><\/nav><\/div>\n\n\n\n\n<p>In addition to Distribution group migration, the information of members, their ownership details, and other particulars are needed to be transported. So, if moving from Office 365, remember to migrate the Office 365 Distribution Group Member&#8217;s Information. As to provide reports it is presented in the CSV file. Here we will know the steps to convert the Office 365 Distribution Group Members to the CSV file.<\/p>\n\n\n\n<p>A distribution group (or distribution list) in Office 365 makes the task of sending the same email to multiple people easy. It brings multiple accounts to the same place where the creator of the group can share the information collected. It is organized by a single subject like meetings, Training, Reporting, Planning, etc. In a distribution list, the Admin can also forward an email automatically to the members.<\/p>\n\n\n\n<p>The distribution list and a distribution group are used for the same term, so there should be no confusion in using either of them.<\/p>\n\n\n\n<p><em><strong>Third-Party Options<\/strong><\/em><\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><a href=\"https:\/\/secure.2checkout.com\/order\/checkout.php?PRODS=6138450&amp;QTY=1&amp;AFFILIATE=110194&amp;CART=1&amp;COUPON=FRT10&amp;__c=1\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" src=\"https:\/\/www.filerepairtools.com\/tips\/wp-content\/uploads\/2017\/06\/download.png\" alt=\"\" class=\"wp-image-18\"\/><\/a><\/figure>\n\n\n\n<p class=\"has-text-align-center\"><a href=\"https:\/\/secure.2checkout.com\/order\/checkout.php?PRODS=6138450&amp;QTY=1&amp;AFFILIATE=110194&amp;CART=1&amp;COUPON=FRT10\" target=\"_blank\" rel=\"nofollow noopener sponsored\" data-wplink-edit=\"true\">Download Office 365 Backup and Restore&nbsp;<\/a><\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<p><strong>How to access Distribution list members?<\/strong><\/p>\n\n\n\n<p>The Admin of the group can check the members of the list in Office 365 Admin Center, but if you require the same set of users for a different task or some other kind of data sharing, then PowerShell comes for your help. There is a series of PowerShell cmdlets that export the member\u2019s details in an external CSV file.<\/p>\n\n\n\n<ol class=\"wp-block-list\" type=\"1\"><li>Run the Windows PowerShell as an Administrator and write the first command to connect Office 365 account with PowerShell.<\/li><\/ol>\n\n\n\n<p><em>$UserCredential = Get-Credential &nbsp;&nbsp;&nbsp;&nbsp;<\/em><\/p>\n\n\n\n<p>A wizard will open where it will require you to input the credentials (email address and password) of the distribution list admin.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Create a new session for the whole Office 365 environment.<\/li><\/ul>\n\n\n\n<p><em>$Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https:\/\/outlook.office365.com\/powershell-liveid\/ -Credential $UserCredential -Authentication Basic \u2013AllowRedirection<\/em><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Import the session into a variable that will help run other cmdlets.<\/li><\/ul>\n\n\n\n<p><em>Import-PSSession $Session \u2013DisableNameChecking<\/em><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>After importing the session into the variable, the Office 365 account will connect with the PowerShell and you can check the Group and its member list.<\/li><li>Run the following cmdlet-<\/li><\/ul>\n\n\n\n<p><em>Get-UnifiedGroupLinks \u2013 Identity \u201cDistribution-List-Name\u201d \u2013 LinkType Members \u2013 ResultSize Unlimited<\/em><\/p>\n\n\n\n<p>It will retrieve the name of all the members present in the list. Then, you can choose such members whom you want to export to the CSV file.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Run the cmdlet to export the members-<\/li><\/ul>\n\n\n\n<p><em>Get-DistributionGroupMember -Identity \u201cDistribution-Group-Name\u201d | Select Name, PrimarySmtpAddress | Export-csv members.csv \u2013NoTypeInformation<\/em><\/p>\n\n\n\n<p>The CSV file will be exported quickly.<\/p>\n\n\n\n<h1 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Export_Distribution_list_using_Office_365_Admin_Center\"><\/span><strong>Export Distribution list using Office 365 Admin Center<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h1>\n\n\n\n<p>Using PowerShell cmdlets, you can export the members to the CSV file, but if you want to export the entire list, then Admin Center has a simple feature for it.<\/p>\n\n\n\n<ol class=\"wp-block-list\" type=\"1\"><li>In Office 365 Admin Center, open the Admin center for the Exchange option.<\/li><li>Go to the Groups category and click on the Distribution list. Select the groups that you want to export.<\/li><li>Click on Export and it will bring two options \u2013 \u2018Export groups in this list, and \u2018export all groups.\u2019 Select a single option.<\/li><li>The wizard will open the available exporting options based on your selection.<\/li><li>The CSV file will be saved in the Downloads folder containing all the details and members of the distribution group.<\/li><\/ol>\n\n\n\n<h1 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Conclusion\"><\/span><strong>Conclusion<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h1>\n\n\n\n<p>The two manual methods to export distribution lists to CSV are pretty different and there are lesser filter options too. If you do not want to face such complexities, then use a professional Office 365 Backup software that offers separate backups of Office Distribution Lists. The professional software will also provide more formats other than CSV files to save the group member details.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><a href=\"https:\/\/secure.2checkout.com\/order\/checkout.php?PRODS=6138450&amp;QTY=1&amp;AFFILIATE=110194&amp;CART=1&amp;COUPON=FRT10&amp;__c=1\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" src=\"https:\/\/www.filerepairtools.com\/tips\/wp-content\/uploads\/2017\/06\/download.png\" alt=\"\" class=\"wp-image-18\"\/><\/a><\/figure>\n\n\n\n<p class=\"has-text-align-center\"><a href=\"https:\/\/secure.2checkout.com\/order\/checkout.php?PRODS=6138450&amp;QTY=1&amp;AFFILIATE=110194&amp;CART=1&amp;COUPON=FRT10\" target=\"_blank\" rel=\"nofollow noopener sponsored\">Download Office 365 Backup and Restore&nbsp;<\/a><\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<p class=\"has-text-align-center\">&nbsp;<\/p>\n\n\n\n<p class=\"has-text-align-center\">&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>While migrating from One Office 365 to another Office 365 platform, organizations make sure that each and every piece of information is transferred. Individuals working in Microsoft Teams have important Office 365 Group Members features. When these groups are transferred it is necessary to transfer the related information too. Users can export the office 365 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":2219,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[5],"tags":[],"class_list":["post-1732","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-how-to"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/filerepairtools.com\/tips\/wp-json\/wp\/v2\/posts\/1732","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/filerepairtools.com\/tips\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/filerepairtools.com\/tips\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/filerepairtools.com\/tips\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/filerepairtools.com\/tips\/wp-json\/wp\/v2\/comments?post=1732"}],"version-history":[{"count":0,"href":"https:\/\/filerepairtools.com\/tips\/wp-json\/wp\/v2\/posts\/1732\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/filerepairtools.com\/tips\/wp-json\/"}],"wp:attachment":[{"href":"https:\/\/filerepairtools.com\/tips\/wp-json\/wp\/v2\/media?parent=1732"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/filerepairtools.com\/tips\/wp-json\/wp\/v2\/categories?post=1732"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/filerepairtools.com\/tips\/wp-json\/wp\/v2\/tags?post=1732"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}