Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

If your team has info to track, work to organize, or workflows to manage, the Lists app can help. Create a list of company assets to keep track of, for example, or incidents in a work area, or patients in a hospital wing. Customize the list to match how you work and share it so the whole team can keep informed and contribute.

If you've worked with Lists in SharePoint, Lists in Teams will be familiar. If not, we have step-by-step instructions. In either case, this article will get you started with Lists in Teams.

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

In this article

Introduction

Add a new list to a Teams channel

Add a list from a different team or SharePoint site

Introduction

Team members create lists—from scratch, from a handy template, from an existing list, or from an Excel workbook—in the desktop or web version of Teams. On mobile devices, team members can view and edit lists, but not create or add them. All lists are saved to SharePoint, and can be accessed and edited from SharePoint as well as from Teams.

Note: Guests cannot create lists.

Added lists appear as tabs along the top of channel pages.

Add a new list to a Teams channel

  1. Go to the channel of your choosing and select Add a tab  Add button  at the top of the page.

    Add a list icon at top of page

  2. In the Add a tab dialog box, select Lists (you may have to use Search to locate it), and then select Save.

    Add a tab dialog box
     

    Note: If "404 FILE NOT FOUND" appears on the screen after you select Save, you've likely encountered a known issue that the engineering team is currently working on.

  3. Select Create a list on the Teams page.

    Here you'll see your options for list creation.

    The Create a list page

To create a list from scratch

  1. Select Blank list, and then select Save.

  2. Enter a list name. If you'd like, also enter a description and choose a color and icon.

  3. Select Create.

To create a list from a template

Templates offer pre-formatted lists for common info-tracking situations. 

  1. Under Templates, select a template to view.
    Determine if it generally matches your needs. You will, of course, be able to make changes to the template you choose.

  2. If the template looks good, select Use template at the bottom of the page.

  3. On the next page, enter a list name. If you'd like, also enter a description and choose a color and icon.

  4. Select Create.

To create a list based on an existing list

Use the column headings, views, and formatting from another Teams list as the basis of your new list.

  1. Select From existing list.

  2. Select a team, select a list, and select Next.

  3. Enter a list name. If you'd like, also enter a description and choose a color and icon.

  4. Select Create.

To create a list from Excel

When you create a list from Excel, the worksheet headings become columns in the list, and the rest of the data becomes list items. For related information, see the SharePoint article Create a list based on a spreadsheet.

  1. Select From Excel.

  2. Locate and select the Excel file you want to use and then select Next.

  3. Follow the instructions on the Customize page.

Add a list from a different team or SharePoint site

If you have an existing list and the necessary permissions, you can add the list as a tab in a channel so everyone who visits the channel can easily view it. Only lists that are stored in SharePoint can be added—personal lists are not supported.

Note: When you select Add an existing list you will see only "standard" lists in the bottom half of the page. To check whether a list is standard, go to the team's SharePoint site and select Site contents on the left. In the contents list, the Type column indicates "List" for the standard lists.

Add a list from another channel in the same team

  1. Go to the channel of your choosing and select Add a tab  Add button  at the top of the page.

  2. In the Add a tab box that opens, select Lists (you may have to use Search to locate it), and then select Save.

  3. Select Add an existing list.

  4. On the next page, under Select a list from the site, select the list you want to add. The selection includes all the lists in that team that you have access to.

Add a list from a different team

Provide the channel with a related list from a different team that you're a member of.

Note: Adding an existing list from a different team doesn't automatically give your team members access to the list. For more information, see Lists in SharePoint in the admin article.

  1. In Teams, go to the team site containing the list you want to add and open the list.

  2. At the top left of the list, select three horizontal dots  and then select Open in SharePoint.

    3 dots and Open in SharePoint option

  3. Copy the URL of the SharePoint page.

  4. Go to the channel that you want to add the list to and select Add a tab  Add button  at the top of the page.

  5. In the Add a tab box that opens, select Lists (you may have to use Search to locate it), and then select Save.

  6. Select Add an existing list.

  7. On the Add an existing list page, paste the SharePoint URL under Paste a link to a SharePoint list to pin.

Add a list from SharePoint

Your team will be able to view and comment on the list, but not edit it. 

Note: SharePoint custom list views are not transferred to the list in Teams. The list will appear in the default view.

  1. In SharePoint, locate the list you want to add and copy its URL.

  2. In Teams go to the channel of your choosing and select Add a tab  Add button  at the top of the page.

  3. In the Add a tab dialog box, select SharePoint Lists (you may have to use Search to locate it), and then select Add a list from any SharePoint site.

  4. Under Paste a link to a SharePoint list, paste the URL you copied in step 1 and select Save.

Want to know more?

Read more about Lists

What is a list in Microsoft 365?

Data and lists in SharePoint (Create & edit)

Create a list based on a spreadsheet

Note: In the SharePoint articles, not all of the content applies to Teams.

For IT admins

Manage the Lists app for your organization in Microsoft Teams

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!

×