Feb 09 2021 06:17 AM
Hi
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?
Thanks
Feb 09 2021 09:18 AM
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
Mar 02 2021 04:45 PM
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.