Exporting Lists from SharePoint Online

Question

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?

Answer 1

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.

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.

Answer 2

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

But you would have to to that for every list