Export and Import Sharepoint lists

Brass 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?



2 Replies



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

It might not exactly solve your problem, but it could help others who searched for "export modern sharepoint lists" to excel.


The easiest way is to open excel and switch to the data-tab and choose to import from sharepoint.