Create a new list based on the columns in another list

Create a new list based on the columns in another list

When you need a consistent and reliable approach to creating similar lists, you can create one from an existing list. When you do this, the entire list structure is copied, including views, formatting, and columns. However, the actual content of the original list isn't be copied.

You can create lists in Microsoft SharePoint, the Lists app in Microsoft 365, or Teams. Learn to get started with Lists in Microsoft Teams.

Note: You can also create new lists based on a list template or an Excel file, or create a list from scratch

The following steps use the modern Microsoft 365 experience. Sites shown are lists from an example site.

  1. From the Lists app in Microsoft 365, select +New list or from your site's home page, select + New > List.

  2. On the Create a list page, select From existing list.

    Create from existing list
  3. Select the site that has the existing list, select the list and then Next.

    Select an existing list

  4. Enter the name for the new list, and if you want add an optional description.

    Note: If you want the new list to appear in the site navigation, check the box Show in site navigation.

  5. Select Create.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×