Copy a SharePoint List With Columns and Formatting
Question details
The user wants to duplicate a SharePoint list without manually rebuilding its columns, views, and formatting, and optionally copy its items.
- Product
- Microsoft SharePoint Lists
- Device & OS
- not provided
- Scenario
- Create a second list on the same SharePoint site based on an existing list.
- Observed behavior
- The desired new list retains the original structure and formatting, with existing items copied if needed.
Check that you can access the source list and create a list on the destination site. Note whether you need the existing items as well as the list structure, because copying from an existing list does not copy its items.
Create a New SharePoint List From an Existing List
Use the modern list creation option to copy columns, views, and formatting without recreating them manually.
Go to the SharePoint site where you want the new list, then select New > List.
Select From existing list, choose the source site if prompted, and select the list you want to copy.
Enter a name and an optional description, then select Create.
Open the new list and review its columns, views, and formatting. Recreate any settings or integrations that were not carried over.

Save the SharePoint List as a Template With Content
Use a list template when the option is available and you want to include existing items in the copy.
Work With Exported List Data in WPS Spreadsheet
WPS Office is a free, lightweight alternative for working with spreadsheet data in a familiar interface. Open an Excel workbook containing exported list data to continue editing it, but use SharePoint to duplicate the list itself; WPS does not copy SharePoint views or list settings.

Frequently Asked Questions
Does creating a SharePoint list from an existing list copy the items?
No. New > List > From existing list copies the list structure, including columns, views, and formatting, but the new list starts without items.
How can I copy items if Save list as template is unavailable?
Create the new list with From existing list, then try copying suitable rows from the source list and pasting them into the new list using Edit in grid view. Check the results carefully; some column types and attachments may require separate handling.
Why can't I see Save list as template?
The option may be unavailable because of the site configuration, list type, or organizational policy. Ask a SharePoint administrator whether list templates and custom scripting are supported and permitted for your site.
Will the new list have the same permissions and integrations?
Do not assume permissions, flows, or other integrations are duplicated. After creating the list, review Settings > List settings and test any connected automation separately.




