SharePoint Document Issues

Copy a SharePoint List With Columns and Formatting

Muhammad TalhaMuhammad Talha Nov 22, 2026 868 views

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.
Before you start

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.

Solution 1Recommended

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.

1
Open the site

Go to the SharePoint site where you want the new list, then select New > List.

2
Choose the source list

Select From existing list, choose the source site if prompted, and select the list you want to copy.

3
Create the list

Enter a name and an optional description, then select Create.

4
Check the result

Open the new list and review its columns, views, and formatting. Recreate any settings or integrations that were not carried over.

Create a New SharePoint List From an Existing List
Existing items are not copied: The new list starts without the source items. If you need them, consider the template method when available or copy suitable rows using Edit in grid view.
Free Microsoft Office alternative

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.

Review and edit exported list data in WPS SpreadsheetCompatible with Microsoft Excel XLS and XLSX filesFamiliar spreadsheet interface for an easy transition from Microsoft OfficeFree and lightweight office suite
QA img-9

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.