SharePoint 2010: Exporting a List

To export a list from a SharePoint site you can follow the steps below.

• Ensure that the user account performing the process is a member of the farm administrator group
  
• In Central Administration, on the Home page, click Backup and Restore on the left hand menu.
  
• On the Backup and Restore page, in the Granular Backup section, click on the Export a site or list option.
  

• On the Site or List Export page, select the appropriate web application, site collection and list that you want to export.
  

• In the file location section enter the UNC path of the export folder. This should be a share on either the server or another network location.
  
• If the file already exists and you want to overwrite this, then select the overwrite existing file option.
  
• Select the export full security check box if you want to export all the security and permissions settings with the select list or library.
  
• When you are happy with the selected options click on the start export button