Export SharePoint groups to excel

In this SharePoint tutorial, we will discuss how to export SharePoint groups to excel. We will see how to export SharePoint Online groups to excel.

export sharepoint groups to excel

Here, we will check a simple way to export sharepoint user groups to excel. Here we will see how to export SharePoint Online groups to excel. The same approach will work in SharePoint 2013, SharePoint 2016, and SharePoint 2019 also.

Follow the below steps to export SharePoint groups to excel.

Step 1: Log in to the SharePoint site and go to the People and groups from the Site Settings page.

export sharepoint groups to excel
export sharepoint groups to excel

Step 2: Make sure you have logged in your site using Internet Explorer as the Chrome browser doesn’t support this feature.

Next right-click on the page and there is an option called “Export to Microsoft Excel

export sharepoint user groups to excel
export sharepoint user groups to excel

Step 3: Next it will take some time and after some time your groups will automatically be exported into the excel.

But you have to re arrange the sheet as it is not exported in format way.

export sharepoint online groups to excel
export sharepoint online groups to excel

This way, we can easily export SharePoint groups to excel.

You may like following SharePoint tutorials:

In this tutorial, we learned how to export SharePoint Online groups to excel using internet explorer browser.

Donwload Hub site pdf

Download SharePoint Online Tutorial PDF FREE!

Get update on Webinars, video tutorials, training courses etc.

>