Backup and Restore (Export-Import) Lists in SharePoint 2013 using PowerShell
Requirement: Backup and restore a SharePoint 2013 list between sites.
Solution: While saving a list as template, including its content is one solution, it doesn’t work for lists larger than 50 MB! So, follow below steps to export-import lists in SharePoint 2013 using PowerShell.
Export a SharePoint list using PowerShell:
Use Export-SPWeb cmdlet with ItemURL parameter to export a SharePoint list.
Syntax:
Export-SPWeb <Site URL> -Itemurl <Relative path of List or Library> -path <Backup-path>
E.g.
Export-SPWeb "https://crescent.com/HRv2" -itemurl "/Lists/Invoice" -path "D:\Invoice.bak"
You can also export a SharePoint list from SharePoint 2013 central administration site.
Restore (Import) SharePoint lists using PowerShell:
Now, to import lists to SharePoint 2013, use: Import-SPWeb cmdlet
Import-SPWeb "https://intranet.crescent.com/HRv3" -Path "D:\Invoice.bak"
TechNet Articles: Import-SPWeb, Export-SPWeb
Related post: Export and Import All SharePoint Lists using PowerShell
Hi…I am facing issue while using the import command for the list having more than 5000 items. While using this command..only the structure of the list gets created while the data is not imported
Well, Raise the List view threshold limit in Central Admin: How to Increase List View threshold limit in SharePoint