How to Create a SharePoint List (Step-by-Step)

A SharePoint list is a simple, flexible way to track information like tasks, inventory, contacts, or project details, right inside your SharePoint site. You can create one in a few clicks from your site’s contents page, or from Microsoft Lists if you’d rather start there and attach it to a site later. This guide walks through both routes.

Quick steps

Go to the SharePoint site where you want the list.
Select Site contents (or New from the site’s home page).
Choose New, then List.
Pick Blank list, a template, or an existing list/Excel file to base it on.
Name your list, add a description if you want, and select Create.
Add columns to match the information you want to track, then start adding items.

Before you start

A few things to check before you create a list:

You need a permission level on the site that allows you to add content, such as Edit or Design. If you only have Read access, you won’t see the option to create a list. You can learn more about how these permission levels work in Microsoft’s documentation on understanding permission levels in SharePoint.
Decide whether you want the list tied to a specific SharePoint site from the start, or whether you’d rather create it in Microsoft Lists and connect it to a site afterward. Both approaches end up creating the same type of list.
If you’re planning to use the list in automations, Power Apps, or Copilot Studio, keep in mind that some of these tools apply their own limits on list size and row counts, so it’s worth thinking about how large the list might grow.
Have a rough idea of the columns you’ll need (text, choice, date, number, person, and so on) since you can add these while setting up the list or later.

Create a list from a SharePoint site

This is the most common way to create a list, and it works the same whether you’re using a team site or a communication site.

Open the SharePoint site where you want the list to live.
In the left navigation, select Site contents. Alternatively, select New near the top of the site’s home page.
Select List from the menu that appears.
In the panel that opens, choose how you want to start:
- Blank list if you want to build columns from scratch.
- A ready-made template if one matches what you’re tracking.
- From an existing list, if you want to reuse the structure of a list already on your site or in your organization.
- From Excel, if you have data in a spreadsheet you’d like to import as a starting point.
Give the list a name. This name is also used in the list’s web address, so keep it short and clear.
Add an optional description to help others understand what the list is for.
Select Create. SharePoint opens the new list so you can start adding columns and items right away.

Create a list in Microsoft Lists

If you’d rather start outside of a specific site, you can create the list in Microsoft Lists and connect it to a SharePoint site as part of the setup.

Open Microsoft Lists.
Select New list.
Choose Blank list, a template, or start From Excel or From an existing list.
Enter a name and, if you want, a description for the list.
Under where to save the list, choose the SharePoint site you want it attached to.
Select Create.

Once it’s created, the list shows up in that site’s Site contents just like a list created directly from the site.

Add and customize columns

After the list exists, you’ll usually want to shape it to match what you’re tracking.

Open the list and select Add column at the right of the column headers.
Choose a column type, such as single line of text, choice, number, date and time, or person.
Name the column and set any options specific to that type (for example, the choices available in a Choice column).
Select Save.
Repeat for any other columns you need, and use Edit in grid view if you want a spreadsheet-style way to fill in data quickly.

If it doesn’t work

You don’t see the option to create a list

This usually comes down to permissions. If your account only has Read access to the site, the New and Site contents options for adding a list won’t appear. Ask the site owner to raise your permission level, as described in Microsoft’s guide to permission levels in SharePoint.

The list isn’t showing up where you expected

If you created the list through Microsoft Lists and picked the wrong site when saving it, it will appear in that site’s content instead of the one you meant. Check Site contents on the site you selected during creation, or create the list again and pick the correct site this time.

Importing from Excel didn’t bring in the data correctly

Make sure your spreadsheet has clear column headers in the first row and that the data below is formatted consistently (for example, dates all in one format). Fix the source file and try the import again if columns come through as the wrong type or data looks jumbled.

A connected app or automation isn’t returning all your list data

Tools that read SharePoint lists, such as Power Apps or Copilot Studio, can apply their own row limits and delegation rules, so very large lists may not return a complete data set in those tools even though the list itself is fine. If you’re hitting this, check the specific limits for the tool you’re using and consider trimming or filtering the data the app needs to pull.

Frequently asked questions

Do I need special permissions to create a SharePoint list?

Yes, you need a permission level that allows adding content, such as Edit or Design, on the site. Members with only Read access won’t see the option to create a new list.

Can I create a list without going into a specific SharePoint site first?

Yes, you can start in Microsoft Lists and choose which SharePoint site to save the list to as part of the creation process. The list then appears in that site’s content.

What’s the difference between creating a list from scratch and from a template?

A blank list gives you a single Title column and lets you build everything yourself, while a template comes with columns already set up for common scenarios like issue tracking or event planning. Either way, you can add, remove, or edit columns afterward.

Can I turn an Excel spreadsheet into a SharePoint list?

Yes, when creating a list you can choose to start from Excel and import a spreadsheet. SharePoint uses your headers as column names, so it helps to have clean, consistent headers before you import.

Is there a limit to how many items a SharePoint list can hold?

SharePoint lists themselves can hold a large number of items, but if you plan to connect the list to tools like Power Apps or Copilot Studio, those tools apply their own row and query limits, so very large lists may not be fully accessible through those integrations.