How to Duplicate a SharePoint List Structure Without Template Permissions
Question details
A SharePoint site owner needs to recreate an identical list structure across multiple lists but does not have the permissions to save the existing list as a template.

- Product
- Microsoft SharePoint
- Device & OS
- not provided
- Scenario
- Attempting to copy an existing SharePoint list structure to a new list when the 'Save list as template' option is unavailable.
- Observed behavior
- Using the standard 'Export to Excel' workaround successfully duplicates basic text columns but strips out advanced configurations, converting choice, calculated, and person fields into plain text, and losing column descriptions.
Verify if you only need basic text columns or if your list relies heavily on complex data types like Choice, Person, or Calculated fields, as this dictates the best duplication method.
Method 1: Create a New List from an Excel Export
Use this method for simple lists. It quickly replicates column names but converts advanced field types into basic text columns.
By exporting your existing SharePoint list to a spreadsheet, you can use the column headers as a foundation for a new list. Note that this method does not preserve choice field options, column descriptions, or calculation formulas.
Navigate to the source SharePoint list, click on 'Export' in the top command bar, and select 'Export to Excel'.
Open the downloaded Excel file. Delete all the existing row data but carefully retain the top row containing your column headings. Save the file as a standard .xlsx workbook.
Go to Site Contents in SharePoint, click 'New', select 'List', and then choose 'From Excel'. Upload the file you just saved.
SharePoint will attempt to map your columns. Review the column types and adjust them where possible, then click 'Create'.
Method 2: Use Power Automate for Advanced Structural Copying
Use a Power Automate flow to programmatically copy advanced list structures, bypassing the need for template permissions.
Manage Exported SharePoint Lists Easily with WPS Office
When exporting SharePoint lists to Excel as a workaround for missing template permissions, you need a reliable spreadsheet editor to clean up the data. WPS Office provides a free, lightweight, and highly compatible alternative to Microsoft Office. It natively handles exported .xlsx and .csv files, making it effortless to prepare your column headers for a new SharePoint import.
- 1. Download and Install: Get WPS Office for free from the official website and install it on your device.
- 2. Open Exported List: Launch WPS Spreadsheet and open the .xlsx file exported from your SharePoint list.
- 3. Clean List Data: Delete the existing row data while keeping your column headers intact for a clean import.
- 4. Save and Import: Save the file and upload it back to SharePoint using the 'Create from Excel' feature.

Frequently Asked Questions
Why do Choice and Person fields convert to plain text when creating a list from Excel?
When SharePoint exports a list to Excel, it only outputs the visible text values of the cells, stripping away backend metadata and configuration settings. When you import that Excel file back into SharePoint, it defaults to creating standard Single Line of Text columns because the advanced configuration data no longer exists.
Where did the 'Save list as template' option go in modern SharePoint?
In modern SharePoint Online sites, a security feature called 'Custom Scripting' is disabled by default. Disabling custom scripts automatically hides the 'Save list as template' option in the List Settings. A global or SharePoint administrator must run a PowerShell command to allow custom scripts on the site to restore this button.
Can I copy a SharePoint list structure using PowerShell without being an admin?
No. While the PnP PowerShell command `Get-PnPProvisioningTemplate` is highly effective at copying list structures perfectly, it requires elevated permissions to authenticate and execute against the SharePoint environment. Standard site owners without admin rights generally cannot use this method.
Do column descriptions transfer when exporting a list to Excel?
No, column descriptions are considered list metadata. The 'Export to Excel' function only exports the column names (headers) and the row data. Any descriptive text configured in the column settings must be manually re-entered after recreating the list.




