'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Import a Microsoft Lists Template in SharePoint
Question details
The user needs to import a shared Microsoft Lists template (.stp file) into a SharePoint site, which requires administrative configuration.
- Product
- Microsoft SharePoint
- Device & OS
- not provided
- Scenario
- Importing and using a shared .stp list template file to create a new list in a SharePoint site.
- Observed behavior
- The .stp template does not appear in the List Template Gallery by default because custom scripts and list templates are disabled on the site.
Ensure you have SharePoint Administrator or Global Administrator privileges and have installed the latest SharePoint Online Management Shell on your device.
Enable Custom Scripts and Upload the .stp Template
Use the SharePoint Online Management Shell to enable custom scripts, which allows you to upload and apply custom .stp list templates.
By default, modern SharePoint sites do not allow custom scripts, which hides the List Template Gallery. Administrators must override this setting using PowerShell before the template can be uploaded and applied.
Open the SharePoint Online Management Shell as an administrator and run the command: Set-SPOSite <SiteURL> -DenyAddAndCustomizePages 0 (replace <SiteURL> with your actual SharePoint site URL).
Navigate to your SharePoint site in a web browser, click the gear icon to open 'Site Settings', and select 'List templates' under the Web Designer Galleries section.
Click the 'Files' tab on the ribbon, select 'Upload Document', and choose your .stp template file from your computer to add it to the gallery.
Go to 'Site contents', select 'New' > 'App' (or select Apps), and click the link to switch to the classic experience. Search for your uploaded template name and click it to create your new list.
Looking for a Lightweight Alternative for Document Management?
While SharePoint handles list templates and intranet sites, WPS Office provides a seamless, free alternative for your everyday document, spreadsheet, and presentation needs with full Microsoft format compatibility.
- 1. Download WPS Office: Visit the official WPS website and download the free installation package for your operating system.
- 2. Install the Software: Run the downloaded installer and follow the simple on-screen instructions to complete the setup.
- 3. Open Your Files: Launch WPS Office to easily open, edit, and collaborate on any existing Microsoft Office documents.
Frequently Asked Questions
Why is the 'List templates' option missing from my SharePoint Site Settings?
The 'List templates' option is hidden on modern SharePoint sites because custom scripting is disabled by default. An administrator must enable custom scripts using the Set-SPOSite PowerShell command to make the gallery visible.
Can I import a list template without SharePoint admin rights?
No, if custom scripts are not already enabled on the site, you cannot enable them or access the List Template Gallery without SharePoint Administrator or Global Administrator privileges.
How do I switch to the classic experience to find my template?
When you navigate to 'Site contents' and click to add an App, look for a 'classic experience' link typically located at the top or bottom of the App page. Clicking it will load the legacy view where custom .stp templates are displayed.
