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.
Hi Michael, thanks for your input. we are moving ahead with the CSOM option.