Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
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 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

    Note: Lists that contain automated rules will only include the first two rules in the new list. You will need to add new rules manually after list creation.

  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.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!