Is there still a way to export a SharePoint site's Members list to CSV?

Question

Hello All,

I am working on a request to pull all users that have access to a specific SharePoint Online site.

Every where I look it seems that I will either have to use powershell or Excel and OData Feed. Which aren't very viable since I'm remote support and don't have access to their network via vpn. Did MS get rid of the SUPER useful "Export to Excel" button? Why?

Answer 1

Hi @Aaron Mack ，

Microsoft did not remove the "Export to Excel" button. In SharePoint , you can directly export list /library items shown in the current view to Excel so that you can work with the data in a workbook.

Here is the shortcut to export SharePoint users and groups permission to Excel (But this is only for Internet Explorer):

Reference: https://www.sharepointdiary.com/2015/05/export-sharepoint-users-and-group-permissions-to-excel.html#ixzz7vLNluBtX

Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

You can also use View Source in your browser and clip out the table text into your favorite HTML editor, which then can imported into Word/Excel. A little extra work, but it does work.

I agree, even though I have the function listed on the right-click, it does not work.