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