Export and Import a SharePoint List

Export and Import a SharePoint List

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 "
C:\SharePoint Backup\StudentsList.cmp"
For more info read the TechNet Articles.
Export
Import

Reference:

http://prabathf.blogspot.in/2012/02/export-and-import-sharepoint-list.html