Exporting Lists from SharePoint Online

sappana 21 Reputation points
2021-07-08T20:30:35.503+00:00

Looking for a simple way to Exporting roughly 100 Lists from SharePoint Online to a file folder every day, we want this to be a simple script that our non tech team can manage. I have seen few CSOM samples, is this the way to go or are there some options in SharePoint online to do this better?

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,805 questions
SharePoint Development
SharePoint Development
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Development: The process of researching, productizing, and refining new or existing technologies.
2,706 questions
0 comments No comments
{count} votes

Accepted answer
  1. MichaelHan-MSFT 18,016 Reputation points
    2021-07-09T06:11:38.643+00:00

    Hi @sappana ,

    The easiest way to export lists in SharePoint is using the default export to excel butto in the UI. Since you have to export 100 lists everyday, it's not doable with this option.

    113205-image.png

    With script, the csom would be your best choice. Just go ahead and feel free to ask here if you have code issues.


    If an Answer is helpful, please click "Accept Answer" and upvote it.
    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.


1 additional answer

Sort by: Most helpful
  1. Sven Sieverding 1 Reputation point MVP
    2021-07-15T12:05:50.33+00:00

    If you have access to Power Automate then you could try to

    • create a Flow that runs once every day,
    • that gets all data from a SharePoint list,
    • converts it into a CSV and
    • stores that as a new File in a SharePoint document library
    • Then you could sync that library to your local computer using OneDrive

    115008-flow.png

    But you would have to to that for every list

    0 comments No comments