How to export SharePoint online Folders list with users permission in CSV file?

Ashutosh Chavda 1 Reputation point
2022-09-05T07:39:19.663+00:00

I have multi pal SharePoint online sites, I want to Export all sites folders and sub folders lists with users permission in CSV file. Is that possible? with power shell.

Thanks
Ashu

Microsoft 365 and Office SharePoint For business Windows
Windows for business Windows Server User experience PowerShell
{count} votes

2 answers

Sort by: Most helpful
  1. Renjie Sun-MSFT 2,861 Reputation points Microsoft Employee
    2022-09-06T09:15:15.263+00:00

    Dear @Ashutosh Chavda ,

    Thank you for your post in our forum.

    According to the test and research, unfortunately there is no way to export folders and sub-folders across sites. I tried to make the list name into a csv table as the basis for the PowerShell loop to read, but it still could not be achieved.
    Currently you could get all folder and sub folder from a single list or library. It is recommended that you could first export the folders to csv of each list, and then combine them into one.

    For more information about export list folders to csv:
    SharePoint Online: Get All Folders from List or Library using PowerShell

    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.

    Hope it could help you a little.
    Should you have any questions or concerns, please do feel free to contact me.

    Yours sincerely,
    Renjie Sun


    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.


  2. Limitless Technology 39,916 Reputation points
    2022-09-09T08:35:20.827+00:00

    Hello

    Thank you for your question and reaching out. I can understand you are having query related to export SharePoint permissions,

    You can find script in below similar thread as your to Export all sites folders and sub folders lists .

    https://learn.microsoft.com/en-us/answers/questions/658773/sharepoint-online-get-permission-from-each-documen.html

    -------------------------------------------------------------------------------------------------------------------------------------------

    --If the reply is helpful, please Upvote and Accept as answer--

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.