SharePoint Document Issues

Restore Missing List Templates in SharePoint Online Site Settings

Phi Hung VoPhi Hung Vo Nov 13, 2026 868 views

Question details

The user needs to access the List Templates gallery when it is missing from SharePoint Online Site Settings.

Restore Missing List Templates in SharePoint Online Site Settings
Product
Microsoft SharePoint Online
Device & OS
not provided
Scenario
Accessing classic list templates on a modern SharePoint Online site and using PowerShell to adjust the site's custom script setting.
Observed behavior
The List Templates gallery may be hidden because custom script is disabled. PowerShell commands may also fail if the specified site URL does not exist or points to the wrong site.
Before you start

Confirm the exact SharePoint site URL and have a SharePoint administrator review whether enabling custom script is permitted. Use the SharePoint Online Management Shell with an account authorized to change site settings.

Solution 1Recommended

Verify the site URL and enable custom script for the affected site

Use this method when the classic List Templates gallery is unavailable because custom script is disabled.

The List Templates gallery is a classic SharePoint feature. Allowing custom script can restore access where the site supports it, but it does not turn classic list templates into modern list templates.

1
Copy the affected site's address

Open the affected SharePoint site and copy its root URL, such as https://contoso.sharepoint.com/sites/project. Do not use a document-library URL, a list URL, or a Site Settings page URL.

2
Connect to SharePoint Online

Open the SharePoint Online Management Shell and run Connect-SPOService -Url https://contoso-admin.sharepoint.com. Replace the example address with your tenant's SharePoint admin URL, then sign in with an authorized administrator account.

3
Verify that the site exists

Run Get-SPOSite -Identity https://contoso.sharepoint.com/sites/project using the actual site URL. If the site cannot be found, check the address in the SharePoint admin center under Active sites and confirm that you connected to the correct tenant.

4
Allow custom script

After security approval, run Set-SPOSite -Identity https://contoso.sharepoint.com/sites/project -DenyAddAndCustomizePages 0, replacing the example URL with the verified site address.

5
Check the List Templates gallery

Return to the site, select Settings > Site information > View all site settings, and look under Web Designer Galleries for List templates. Refresh the page if it was already open.

Verify the site URL and enable custom script for the affected site
Custom script affects security and may be reset: Allowing custom script changes the site's security posture. In SharePoint Online, custom script is generally blocked again within 24 hours, so treat this as a temporary change rather than a permanent fix. Organizational restrictions and site capabilities can also limit access.
Free Microsoft Office alternative

Use WPS Office for Documents Stored in SharePoint

WPS Office does not restore SharePoint List Templates or change tenant settings. For working with documents downloaded from SharePoint, it offers free, lightweight editing tools, Microsoft Office format compatibility, and a familiar interface that makes migration straightforward.

Edit documents downloaded from SharePoint without relying on the List Templates gallery.Work with Microsoft Word, Excel, and PowerPoint formats, including .docx, .xlsx, and .pptx.Use familiar document, spreadsheet, and presentation tools in one lightweight suite.Move existing Office files into WPS without rebuilding them from scratch; review complex formatting before sharing.
microsoft office alternative - wps office

Frequently Asked Questions

Why is List Templates missing from my SharePoint Online site?

Custom script being disabled is a common cause. Open Settings > Site information > View all site settings and check Web Designer Galleries. If List templates is absent, ask a SharePoint administrator to review the site's custom script setting, your permissions, and whether the site supports the classic gallery.

Why does Set-SPOSite report that my site cannot be found?

The command may contain an incorrect URL or be connected to the wrong tenant. Connect using Connect-SPOService with your tenant's admin URL, then verify the site with Get-SPOSite -Identity <SiteURL>. Use the site's root address listed in SharePoint admin center > Active sites.

Does enabling custom script permanently restore List Templates?

Not necessarily. SharePoint Online generally resets custom script to blocked within 24 hours. The command can provide temporary access where supported, but administrators should account for security restrictions and avoid relying on it as a permanent configuration.

Can WPS Office fix the missing SharePoint List Templates gallery?

No. The gallery is controlled by SharePoint site settings, permissions, and service restrictions. WPS Office can edit compatible Office documents downloaded from SharePoint, but it cannot manage SharePoint list templates or enable custom script.