I am using SharePoint-2013. I have three lists that I want to move to the sub-site with all the data. How can i do this?


you can export the lists using the SharePoint 2013 Management Shell on a farm server with the command Export-SPWeb, including versions and security settings if you want. Then you can import the lists in the sub-site using the command Import-SPWeb, specifying the subsite url and the export files previously created.

You need to have securityadmin and db_owner roles on the SQL Server instance and you have to run the SharePoint 2013 Management Shell as Administrator.

After you have checked the lists in the subsite, you can delete the ones you don't need anymore.

  • does it keep the information of the lookup columns? – Tarek Salah uddin Mahmud Aug 30 '16 at 8:40
  • It should, if you import the list in the same site collection, because the lookup field "configuration" (lookup list + lokup field name) would be the same. – Davide Franceschelli Sep 7 '16 at 13:10

The simplest way is to

Save list as Template with Content > then at subsite create it from this template.

  • Go to list Setting > Save List as a template .

enter image description here

  • At subsite > Add app > create a list from this template

Also, you can use Export -and Import

Export-SPWeb -Identity http://site -Path c:\export.cmp -IncludeUserSecurity -IncludeVersions All -ItemUrl /lists/yourlistname

Import-SPWeb http://site/subsite –Path c:\export.cmp –UpdateVersions -Overwrite -IncludeUserSecurity

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.