To archive SharePoint Online document library content, you must be able to connect to your organization’s SharePoint Online sites. The person archiving SharePoint list content must have either Microsoft Office Excel 2010 or Microsoft Office Access 2010 installed.
The following kinds of SharePoint lists can be linked to Outlook: • Calendar • Contacts • Tasks • Document Libraries • Discussion • Lists
To archive SharePoint list data to Office Excel, follow these steps:
1. Browse to the SharePoint list. 2. On the Office ribbon, select List or Library, and then click Export to Excel. 3. Select Open. 4. Under Import Data, select where you want to put the data (if this is applicable). The list is exported to Excel. 5. You can save the file to your local directory. 6. Repeat this process for every SharePoint list. 7. Note This process will save entries in a list. The actual content such as files and attachments won’t be saved when you use this method.