You can create and share lists that help you track issues, assets, routines, contacts, inventory, and more. Start from a template, Excel file, or from scratch. If you're in Microsoft Teams, seeGet started with Lists in Teams.
Office 2019 - Office 2021 and WebOffice 2016Office for iOSOffice for Android
Create a list
-
From the Lists app in Microsoft 365, select+New list.(To get to the Lists app, at the top of any page, select the Microsoft 365 app launcher
, select All apps, and then select Lists.)
From your SharePoint sitehome page or the Site contents page, select+New>List.
-
From theCreate a listpage, select one of the following options:
Notes:
-
Visual updates for lists are gradually rolling out worldwide, which means that your experience may differ from what's described in this article.
-
2,000 lists and libraries combined per site collection is the limit (including main site and any subsites),after which you will receive error: Sorry, something went wrong. The attempted operation is prohibited because it exceeds the list view threshold. See SharePoint limits.
-
Blank list: Chooseto start a list from scratch. Add alist Name,Description(optional), and select whether you want the list to appear in the left site navigation. When you're finished selecting options, selectCreate.
-
From existing list: Choose this option to save time andcreate a new list based on the columns in another list. Your new list will start with all the same columns, but it won't include any of the data from the original list.
-
From Excel: Choose this option tocreate a list based on an Excel spreadsheet.
-
From CSV: Choose this option to create a list based on a comma-separated values file.
-
Templates: Select a template, for exampleIssue tracker, to see what columns the template contains and scroll through sample data to see what it looks like.If you find a template you like, selectUsetemplate. If you don't see any you want, selectBackto get back to the Create a list page. Learn more about how tocreate a list from a templateor about thelists templates in Microsoft 365.
-
-
When your list opens, add an item to your list by either selecting+ Add new item or Edit in grid view. (Grid view lets you add information freely to different rows or columns.)
To add different types of information to the list, select+ Add column. To learn more, seeCreate a column in a list or library.
Tip:To change the name of your list, select its title, type a new name, and then select Save. Or from the Lists home page, on your list's tile, select Open actions (...),and then select Settings.
To change list properties, delete the list, add permissions, manage columns, andother updates, selectSettings , and then selectList Settings. For more info, see Edit a list.
Create a list on a classicSharePoint or aSharePoint Server 2019 site
-
SelectSettings , and then selectSite contents.
-
Select+ New, and then selectList.
-
Enter a Name for the list, and optionally, a Description.
The name appears at the top of the list and can appearin site navigation to help others find it.
-
SelectCreate.
-
When your list opens, to add room for more types of information to the list, select+ or + Add column.
See AlsoSprint & T-Mobile Merger: Updates and What it Means for YouMore is more: data, legends and maps!Site of Birmingham City's new ground on fire with 999 crews at scene - updatesElection Updates: Trump is attending a U.F.C. fight in New Jersey.For more info aboutadding columns, see Create a column in a SharePoint list or library.
For infoabout creating a list based on an existing list, see Create a new SharePoint list based on the columns in another list.
To change properties, delete the list, add permissions, manage columns, and a number of other updates, selectSettings , and then selectList Settings. For more info, see Edit a list.
Create lists from other types of list templates
You can useSharePoint Server 2019 lists for more than a simple list. You can choose from list templates such as Links, Calendar, Survey, Issue Tracking, Announcements, and more.
Calendar app example
-
In this example, we used calendar and chose the built-in calendar app for SharePoint. You may see other calendars that have been built within your company or offered by a third party.
-
Enter a Name for the app you chose, such as Event calendar, July tasks, or Company Contacts.
The name appears at the top of the list in most views, becomes part of the web address for the list page, and appears in site navigation to help users find the list. You can change the name of a list, but the web address will remain the same.
-
SharePoint returns you to the Site contents page. Find the app you just created in the Site contents list, and open it. SharePoint creates a default version of the app, calendar, task list, or whatever app you created.
-
You can start entering data using +new task, edit this list, Add, or whatever way the specific app provides to add data.
Note:Some list-based apps only appear in the classic environment.
Depending on the type of app you choose, tochange the app's settings, from theribbon at the top of the page,selectList Settings or the List tab. For more info aboutsettings, see Edit list settings in SharePoint.
-
SelectSettings , and then selectAdd an app.
-
Enter the type of list template you want (custom, task, calendar, and so on) into the search box, and selectSearch .
-
Select the List template app you want use.
-
Enter a Name (required).
The name appears at the top of the list in most views, becomes part of the web address for the list page, and appears in site navigation to help users find the list. You can change the name of a list, but the web address will remain the same.
To providean optional Description and additional info, depending on the particular list app, selectAdvanced Options. Advanced Options.
-
SelectOK.
-
On the page that you want to add the list or library, selectPage, and then selectEdit. If you don't see the Page tab, selectSettings , and then selectEdit Page.
Note:If the Edit command is disabled or doesn’t appear, you maynot have permission to edit the page.
-
Select the place on the page where you want the list or library to appear, selectInsert,and then selectApp Part.
-
For the list or library, select the App Part, and then selectAdd. In Add apps,any lists you created should appear.
-
When you’re finished editing the page, selectthe Page tab, and then selectSave. In some cases, you have the option to Save as Draft or Save and Publish.
Important:Some pages can't be edited, such as the Site Contents page.
Using the previous steps, here’s an example of a list that was added to a page.
-
On the page where you want to minimize or restore the list or library, selectPage, and then selectEdit.
-
Point to the list or library, selectthe down arrow, and selectMinimize or Restore depending on the current position of the list or library, and then selectOK.
-
When you’re finished editing the page, selectSave. In some cases, you have the option to Save as Draft or Save and Publish.
-
On the Lists Home page, tap the plus sign to create a new list.
-
Under Create New, tap Blank List to start a list from scratch, or select an option under Templates.
-
Blank list starts a list from scratch.
-
Templates are pre-defined, purpose-based options that have columns already defined for you. Select one to see what it has and whether it is right for you. You may change the columns to fit your needs.
-
Start your blank list
-
Tap Blank List, then give it a Name and a Description.
-
Choose a color and an icon.
-
Choose whether to save it under My Lists or on a specific SharePoint site.
-
Tap Create.
A blank list opens with a standard “Title” column on the left.
-
To add a column, tap More, then tap Add New Column
-
Choose the type of column data you want, then define the columns settings. Tap the check mark to save the column settings.
-
Repeat steps 5 and 6 until you’ve defined all your columns.
-
To add an item to your list, tap New, then enter the data for each column. Select the check mark to save your item (or tap the × to discard the item data without saving).
Start a template-based list
-
After you tap one of the templates,it will open so that you can see the columns and sample data it contains.
-
Scroll through the template to see if it's right for you.
As you scroll horizontally, the left-most column data stays in view, helping to keep the related data in context.
-
When you've found the template you want, tapUse This Template.
Your new list opens with all the predefined columns from the template.
-
Customize the list's name, description, color, icon, and where to save the list.
-
Tap Create.
-
To add a column, tap More, then tap Add New Column.
-
Choose the type of column data you want, then define the columns settings. Tap the check mark to save the column settings.
-
Repeat steps 6 and 7until you’ve defined any additional columns you want.
-
To remove an existing column, tap the column heading, scroll to the bottom of the settings, and tap Delete Column.
-
To add an item to your list, tap New, then enter the data for each column. Select the check mark to save your item (or tap the × to discard the item data without saving).
-
On the Lists Home page, tap New.
-
Under Create New, tap Blank list to start a list from scratch, or select an option under Templates.
-
Blank list starts a list from scratch.
-
Templates are pre-defined, purpose-based options that have columns already defined for you. Select one to see what it has and whether it is right for you. You may change the columns to fit your needs.
-
Start your blank list
-
Tap Blank list, then give it a Name and a Description.
-
Choose a color and an icon.
-
Choose whether to save it under My lists or on a specific SharePoint site.
-
Tap Create.
A blank list opens with a standard “Title” column on the left.
-
To add a column, tap More, then tap Addcolumn.
-
Choose the type of column data you want, then define the columns settings. Tap the check mark to save the column settings.
-
Repeat steps 5 and 6 until you’ve defined all your columns.
-
To add an item to your list, tap New, then enter the data for each column. Select the check mark to save your item (or tap the × to discard the item data without saving).
Start a template-based list
-
After you tap one of the templates,it will open so that you can see the columns and sample data it contains.
-
Scroll through the template to see if it's right for you.
As you scroll horizontally, the left-most column data stays in view, helping to keep the related data in context.
-
When you've found the template you want, tapUse this template.
Your new list opens with all the predefined columns from the template.
-
To add a column, tap More, then tap Addcolumn.
-
Choose the type of column data you want, then define the columns settings. Tap the check mark to save the column settings.
-
Repeat steps 4 and 5 until you’ve defined any additional columns you want.
-
To remove an existing column, tap the column heading, scroll to the bottom of the settings, and tap Delete column.
-
To add an item to your list, tap New, then enter the data for each column. Select the check mark to save your item (or tap the × to discard the item data without saving).
Want to do the same with Libraries?
To create a library, see Create a document library.
Next steps with Lists
Columns Configure what type of infoa list holds by adding and deleting columns. For more information, see Create a column in a list or library.
Views Change how a list is displayed by creating views. For more information, see Create, change, or delete a view of a list or library.
Folders Add a subfolder to a list. For more information, see Create a folder in a list.