This was a requirement one of my clients faced few days back. So I thought of writing blog post on it so anybody can refer to it when needed .
Exporting a SharePoint List can be done with the OOB feature given in SharePoint Central Administration.
Central Administration >> Backup and Restore >> Export a site or list
In the above image you can see…
1. You can backup a site
2. You can backup a list
3. It supports of exporting with full security
4. Exporting with the item versioning (Major / Minor / Both / Current)
OK fine exporting can be done through the UI. How about Importing? Time to move on to PowerShell. Prior to that let’s see how to achieve the Exporting through PowerShell.
Export-SPWeb “http://spdev:4422/netassist/” –ItemUrl “Lists/Students” –Path “C":\SharePoint Backup\StudentsList.cmp”
Now the Importing.. (I’ve used a SubSite “network” for the clarity)
PS C:\Users\SPAdmin> Import-SPWeb “http://spdev4422/netassist/network/” -Path "