SharePoint Document Issues

Fix the Missing List Template Option in SharePoint Online

Chanuka GeekiyanageChanuka Geekiyanage Nov 14, 2026 868 views

Question details

The user needs to restore or find an alternative to the missing Save list as template option on SharePoint Online modern sites.

Fix the Missing List Template Option in SharePoint Online
Product
SharePoint Online
Device & OS
not provided
Scenario
The user wants to create a list template on a hub or associated site after enabling custom script with PowerShell.
Observed behavior
The list template option remains missing, and the list template gallery reports a permission error on some sites.
Before you start

Identify the exact site URL that contains the list and confirm you have the permissions needed to manage that site. Enabling custom script changes site security, so check your organization's policy before proceeding.

Solution 1Recommended

Check custom script on the site that contains the list

Use this approach to verify the site-level setting and look for the legacy template option.

Hub and associated sites do not automatically share custom script settings. Enabling the setting on one site does not enable it on another.

The legacy Save list as template option may still be unavailable for some modern lists or configurations, even when custom script is enabled.

1
Connect to SharePoint Online

Open SharePoint Online Management Shell as an authorized administrator and run Connect-SPOService -Url https://<tenant>-admin.sharepoint.com, replacing <tenant> with your tenant name.

2
Check the site setting

Run Get-SPOSite -Identity <SiteURL> | Select-Object Url,DenyAddAndCustomizePages, replacing <SiteURL> with the URL of the site containing the list.

3
Enable custom script if permitted

If your policy allows it, run Set-SPOSite -Identity <SiteURL> -DenyAddAndCustomizePages 0. Repeat for another hub or associated site only if you need the feature on that site.

4
Recheck list settings

Allow time for the change to apply, then open the list and select Settings > List settings. If available, open More list settings and look for Save list as template.

Check custom script on the site that contains the list
The setting may revert: SharePoint Online can reset custom script settings after a limited period, depending on tenant configuration. Recheck the site setting if the option disappears again.
Free Microsoft Office alternative

Use WPS Office to work with list data in spreadsheets

WPS Office is a free, lightweight Office alternative with a familiar interface and Microsoft Office format compatibility for an easier transition. WPS Spreadsheets can help you review and organize exported list data, but it cannot change SharePoint settings or restore the list template option.

Review and organize SharePoint list data exported to a spreadsheetCompatible with Microsoft Excel XLSX filesFamiliar spreadsheet tools make migration easierFree and lightweight for everyday document work
microsoft office alternative - wps office

Frequently Asked Questions

Does enabling custom script on a hub enable it on associated sites?

No. Check each relevant site with Get-SPOSite -Identity <SiteURL> and configure it separately if your organization's policy permits.

Where is the SharePoint list template gallery?

Open the relevant site collection URL followed by /_catalogs/lt/Forms/AllItems.aspx. If access is denied, ask a site collection administrator to check your permissions.

Why is Save list as template still missing after I enable custom script?

The setting may not have applied yet, may have reverted, or may have been changed on a different site. The legacy option may also be unavailable for the list or its configuration. Recheck the site setting and List settings.

Can I reuse a list without saving it as a template?

Yes. On the destination site, select Site contents > New > List > From existing list. This creates a list from the source structure but does not copy its existing items.