Export and Import Sharepoint lists

Frequent Contributor


In Sharepoint Online classic you used to be to export a list as a template and then import this back into a different 365 tenant and import the list.


However with Sharepoint modern you don't seams to be able to do this


Anyone any idea how you can export and import a list?



1 Reply



This perplexed me for some time as well.


For Modern SharePoint sites you need to use PowerShell (command below) to turn on the templates gallery.  This'll turn on the Gallery in Site Collection Options.  You'll need to generate the SP in the list settings of your source list still.


Set-SPOSite "https://yourtenantURL/sites/yoursite -DenyAddAndCustomizePages 0