In this SharePoint tutorial, I will explain how to save SharePoint list as a template with or without content to another SharePoint site in SharePoint 2013/2016/Online. We can save a list as a template and we can create another list by using this saved template in SharePoint.
You can follow the below steps to save the list as a template and use it in another site collection in SharePoint 2013/2016/Online.
Open a SharePoint team site or publishing site. Navigate to add an app. Click on “Custom List” to add a list. Give a name and click on Create like below:
In the list, Here am added one more column for filling up some data. The list looks like below:
Now going to save the list as template. Click on list-> list settings from the ribbon. Then Click Save list as template which is under Permissions and Management.
Provide the filename and template name. If you need this list with contents- > Check Include Content. Click on OK.
If you will check Include Content then it will save the list or document library data, else it will just save the list or document library structure.
Then it will show a successful message once it is done.
Now open SharePoint list template gallery under site settings in the Site Settings page.
Download the .stp file we create as a list template
You can go to the other site collection where you want to use this list template. Here I have created one more site collection in SharePoint.
Open the site collection and Click site settings -> navigate to Web Designer Galleries -> Click List template
Click on Files tab in a top ribbon -> Click Upload
Uploaded the .stp file we already downloaded from some other site collection.
Navigate to Add an app -> Click CityDetailsList template to create
If you see save list as template link in SharePoint online is missing, then you have to check if the custom script is enabled or nor in SharePoint Office 365 tenant level.
To verify this open SharePoint Online admin center and then go to settings and you can go the Custom Script section and allow Allow users to run custom script on personal sites and Allow users to run custom script on self-service created sites like below:
You can also access the settings page URL directly like below:
Once you enable, it might take upto 24 hours to reflect the changes in SharePoint Online Office 365.
Alternatively, you can also access the save list as template SharePoint Online URL like below:
https://<Your Site URL>/_layouts/15/savetmpl.aspx?List=<List GUID>
This SharePoint 2013 tutorial explains, how to enable Save site as a template using SharePoint designer 2013 in SharePoint 2013/2016/Online.
To save a site as a template we need to click on “Save Site as Template” which is usually presented under the Site Actions menu. But sometimes you will not get that template there. We can enable that through SharePoint 2013 designer.
Below is the screenshot, you can see Save Site as Template is missing under the Site Actions.
Open your SharePoint 2013 site using SharePoint 2013 designer. Then click on Site Options from the Ribbon as shown in the fig below:
It will open the Site Options dialog box as shown in the fig below. You will able to see an option name as “SaveSiteAsTemplateEnabled” with false as the value.
Now select that and click on Modify and then put the Value as true as shown in the fig below:
Now refresh the SharePoint Online/2013 site, you will be able to see the option under Site Actions as shown in the fig below.
I hope this SharePoint 2013 tutorial explains, how to enable the Save site as a template using SharePoint designer 2013 in SharePoint Online/2013/2016.
Now we will see, how to resolve the access denied issue which comes when we are trying to save a list as a template in SharePoint 2013/2016/Online. Even if you have full control of the site or in subsite sometimes you will get the access denied issue.
Whenever you save the list as a template, the template (.stp) files stored in the top-level site’s List Template Gallery in SharePoint. So if you have only read access to the Gallery then you will not be able to save the list as a template even if you have full control in the subsite where you want to save the list as a template.
We need to provide the user the Full Control or at least the Design role on the List Template Gallery in the top-level site in the SharePoint 2013/2016/Online. Read SharePoint 2016 permission levels.
You can go to the main site and then site settings > Galleries > List template gallery.
This helps to solve the Access denied error when clicking on Save list as a template in SharePoint 2013/2016/Online.
You may like following SharePoint list tutorials:
- Power Automate update SharePoint list item
- How to delete all items from SharePoint list
- How to customize a SharePoint List form
- SharePoint list permissions
- Create SharePoint list view
- SharePoint list delete title column or SharePoint list title column remove
- How to create a calculated column in SharePoint List or Library
Now the list has been moved from one site collection to another site collection with content.
Hope this will be helpful to know how we can save list as a template with content in SharePoint 2013 as well as how we can create another list by using this list template in a different site collection in SharePoint 2013/2016/Online.