Import SharePoint Lists and Save Them as Templates
Question details
The user wants to import a list and save it as a reusable SharePoint list template.

- 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.
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.
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.
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.
Open the new list, select Settings (the gear icon), and choose List settings. If needed, open the classic settings page.
Under Permissions and Management, select Save list as template. Enter a file name and template name, optionally select Include Content, and select OK.
Open Site settings > List templates in the site collection's Web Designer Galleries, find the saved template, and download its .stp file.

Upload the list template to a destination site
Use the downloaded .stp file to make the template available on another supported SharePoint site.
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.

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.




