I have a SharePoint online list with more than 9000 items and the list is being populated on daily basis. I am taking backup manually every morning by saving the list as excel file in the document Library and in my local Computer.
My question is: How can i automate that function? May be a workflow that save the list as excel file every day in the document library?

3 Answers 3


What do you plan to do with the backups? The format needed in the download will help determine the best solution.

If you are writing a little console application or PowerShell script to run as a Windows scheduled job you could use JSON and bring down the data in XML or REST format. This will also let you choose which columns to bring down, and can support a filter so you can bring down subsets, such as just the last day or the last week.

Something like:


http://yourServer/sites/yourSite/_api/web/Lists/getbytitle('yourList')/items?$select=Id,Color,Title,Category&$filter=Created gt '2016/01/01'&$top=10000

I would use a Timer Job. Just choose the best moment to exec your code and that's all.

Maybe this page will help you.




You can create a powershell script to export list data to csv file and create a windows task to run this daily.

  • 1
    This is a good option but the script is not for SharePoint online. Can you please help me writing the script for SharePoint online .
    – Jenny
    Commented Sep 28, 2015 at 9:00

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.