Template Issues

Import SharePoint Lists and Save Them as Templates

Huma Ashraf ChHuma Ashraf Ch Nov 18, 2026 869 views

Question details

The user wants to import a list and save it as a reusable SharePoint list template.

Import SharePoint Lists and Save Them as Templates
Product
Microsoft SharePoint
Device & OS
not provided
Scenario
Create a SharePoint list from an Excel worksheet and reuse its structure, and optionally its content, on another site.
Observed behavior
A supported SharePoint site can save a list as an .stp template for upload to a destination site's template gallery.
Before you start

Confirm that both sites support classic list templates and that you have permission to manage lists and the destination template gallery. If the template commands are unavailable, ask your SharePoint administrator whether custom scripting is permitted; group-connected SharePoint Online team sites may not support this feature.

Solution 1Recommended

Import an Excel worksheet and save the SharePoint list as a template

Use this method to create a list from Excel and export it as an .stp file on a supported site.

1
Import the worksheet

On the source SharePoint site, select New > List > From Excel. Upload or choose the workbook, select the table, review the column types, and select Create.

2
Open list settings

Open the new list, select Settings (the gear icon), and choose List settings. If needed, open the classic settings page.

3
Save the template

Under Permissions and Management, select Save list as template. Enter a file name and template name, optionally select Include Content, and select OK.

4
Download the template

Open Site settings > List templates in the site collection's Web Designer Galleries, find the saved template, and download its .stp file.

Import an Excel worksheet and save the SharePoint list as a template
List size and view thresholds: A SharePoint list can contain more than 500 items. The SharePoint Online list view threshold is typically 5,000 items processed by a view or query; it is not a 500-item total list limit.
Free Microsoft Office alternative

Prepare SharePoint List Data with WPS Spreadsheet

WPS Office is a free, lightweight alternative with a familiar interface for preparing spreadsheet data before a SharePoint import. Its Excel format compatibility helps you move existing workbooks into your workflow. WPS does not create SharePoint list templates or change SharePoint site settings.

Organize worksheet columns and rows before importing them into a SharePoint listOpen and edit Microsoft Excel XLSX filesWork with a familiar spreadsheet interface for an easier transition from Microsoft OfficeUse a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Can a SharePoint list contain more than 500 items?

Yes. A SharePoint list can contain far more than 500 items. In SharePoint Online, the list view threshold is typically 5,000 items processed by a view or query, not a 500-item limit on the list itself.

Why can't I find Save list as template?

The command depends on the site and its settings. Check List settings under Permissions and Management, then ask your administrator whether the site supports list templates and whether custom scripting is permitted.

Can I upload several .stp templates at once?

There is no standard out-of-the-box method described here for importing multiple list templates together. Open the destination site's List Template Gallery and upload each .stp file separately.

Does a list template include the list's items?

Items are included only if you select Include Content when saving the list as a template, subject to SharePoint's template limitations.

Can I use a list template on a group-connected SharePoint Online team site?

Group-connected team sites may not support classic list templates. Check the destination site's available creation options or ask your SharePoint administrator before relying on an .stp template.