SharePoint Document Issues

How to Duplicate a SharePoint List Structure Without Template Permissions

Chanuka GeekiyanageChanuka Geekiyanage Nov 3, 2026 868 views

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.

How to Duplicate a SharePoint List Structure Without Template Permissions
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.
Before you start

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.

Solution 1Recommended

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.

1
Export the source list

Navigate to the source SharePoint list, click on 'Export' in the top command bar, and select 'Export to Excel'.

2
Clean the spreadsheet data

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.

3
Create list from Excel

Go to Site Contents in SharePoint, click 'New', select 'List', and then choose 'From Excel'. Upload the file you just saved.

4
Map the columns

SharePoint will attempt to map your columns. Review the column types and adjust them where possible, then click 'Create'.

Manual Reconfiguration Required: You will need to manually recreate choice dropdown options, re-link Person fields, and rewrite formulas for calculated columns after the new list is generated.
Free Microsoft Office alternative

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. 1. Download and Install: Get WPS Office for free from the official website and install it on your device.
  2. 2. Open Exported List: Launch WPS Spreadsheet and open the .xlsx file exported from your SharePoint list.
  3. 3. Clean List Data: Delete the existing row data while keeping your column headers intact for a clean import.
  4. 4. Save and Import: Save the file and upload it back to SharePoint using the 'Create from Excel' feature.
Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv).Lightweight software ensures large exported lists open instantly.Familiar ribbon interface guarantees a seamless transition with zero learning curve.Completely free to use for basic data cleaning and structural editing.
microsoft office alternative - wps office

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.