SharePoint lists are the simplest way to store and share structured information with your team

A SharePoint list is a container for information — think of it as a spreadsheet that lives on the web and lets multiple people add, edit, and see the same data at the same time. Unlike a document editor, a list is built for data: names, dates, status updates, inventory counts, anything that fits into rows and columns. You create one directly in SharePoint itself, not by uploading a file.

The basic steps are the same whether you are using SharePoint Online (the cloud version most organizations use now) or SharePoint Server (an older on-premises version). You start from your team site, click to create a new list, choose a template or start blank, add your columns, and invite people to view or edit it. The whole process takes five to ten minutes for a straightforward list.

Key Takeaways

  • You create a list directly in SharePoint from your team site — no file upload needed — and it stores data in rows and columns that multiple people can edit at once.
  • SharePoint offers pre-built templates for common lists like tasks, contacts, and calendars, or you can start with a blank list and add your own columns.
  • Each column has a data type (text, number, date, choice, person) that controls what kind of information goes in it and how SharePoint displays it.
  • You control who sees and edits the list by setting permissions on the site itself, not on individual items — everyone with site access sees the same list.
  • Lists are stored on SharePoint servers, not on your computer, so the data persists even if someone leaves the team or deletes their local files.

Starting a new list from your team site

Open your SharePoint team site in a web browser. Look for a button or link labeled New or Create — the exact location varies by how your organization set up SharePoint, but it is usually near the top of the page or in the left sidebar. Click it and select List from the menu.

SharePoint will show you a choice: use a template or start from blank. Templates include Tasks (for to-do items with due dates and assigned owners), Contacts (for names, emails, phone numbers), Calendar (for events with dates and times), and a few others depending on your version. If none of the templates match what you need, choose Blank list and you will add columns yourself.

Give your list a name — something your team will recognize, like "Q1 Project Tracker" or "Client Feedback". You can add a description too, which shows up when people hover over the list name. Click Create and SharePoint builds the list in seconds.

Adding and configuring columns

When your blank list opens, you will see one empty column labeled Title. This is the main column — every item in the list has a title. To add more columns, click the + button at the right edge of the column headers, or click Add column if that option appears.

Choose a data type for the new column. Single line of text works for names, descriptions, or short notes. Number is for quantities or scores. Date is for important date or event dates — SharePoint will show a calendar picker when someone clicks the cell. Choice lets you define a dropdown list of options (like "Not Started", "In Progress", "Done"). Person is for team members — when you select this type, SharePoint shows a list of people in your organization and stores their name and email.

Give each column a name and configure any settings specific to that type. For a Choice column, you type in the options. For a Person column, you decide whether people can pick one person or multiple people. For a Number column, you can set decimal places or a minimum and maximum value. Click Save and the column appears in your list.

Adding items and understanding permissions

To add an item to your list, click New or + New item at the top. A form opens with a field for each column. Fill in the information and click Save. The item appears as a row in your list. You can edit any item by clicking on it and changing the fields, or by clicking directly in a cell if your list view allows inline editing.

Everyone who has access to your SharePoint site can see and edit the list by default — there is no separate permission step for the list itself. If you want some people to see the list but not edit it, or if you want to hide the list from certain people, you change the permissions on the entire site, not on individual lists. Talk to your SharePoint administrator about setting up a separate site if you need different access levels for different groups.

Using views to organize what you see

A view is a filtered or sorted version of your list — it does not change the data, only how you look at it. By default, SharePoint shows you all items in the order they were created. You can create a view that shows only items assigned to you, or only items with a status of "In Progress", or sorted by due date.

Click Create view or look for a view menu near the top of your list. Choose Standard view to start. Give it a name like "My Tasks" or "Overdue Items". Then set filters (show only rows where Status equals "Overdue") and sorting (sort by Due Date, newest first). Click Save and the view appears as a tab or option in your list. You can switch between views without changing the underlying data.

Connecting your list to other tools

SharePoint lists can send information to other applications your team uses. You can set up a flow (using Microsoft Power Automate) that sends an email to someone when a new item is added, or creates a task in Microsoft Teams when a list item status changes. These connections are optional — your list works fine on its own — but they reduce manual work if you are using multiple tools.

To set up a flow, click the Automate button in your list toolbar and choose a template like "Send an email when an item is created". Fill in the details (who to email, what to say) and save it. The flow runs automatically from then on. You do not need to be a programmer — SharePoint provides pre-built templates for the most common workflows.

Data storage and what happens to your list

Your list lives on SharePoint servers, not on anyone's computer. This means the data stays there even if someone leaves your team, deletes their browser history, or stops using SharePoint. It also means you can access it from any device with a web browser — phone, tablet, laptop — as long as you have internet and permission to view the site.

If your organization deletes the SharePoint site, the list goes with it. Most organizations have a retention policy that keeps deleted sites in a recycle bin for 93 days before permanently removing them, but check with your administrator about your organization's specific policy. If you need to keep a list long-term, make sure the site itself is not scheduled for deletion.

Frequently Asked Questions

Can I import data from an Excel spreadsheet into a SharePoint list?

Yes. Open your SharePoint list, click New, and look for an option to import from Excel or upload a file. You select your Excel file, map the columns (tell SharePoint which Excel column goes into which list column), and it creates items from each row. This works best if your Excel file is already organized with headers in the first row and one type of data per column.

What is the difference between a SharePoint list and a Teams channel tab?

A Teams channel can display a SharePoint list as a tab, so your team sees it without leaving Teams. But the list itself still lives in SharePoint — Teams is just showing it. If you want the list to exist only in Teams, you can create a table in a Teams channel instead, though it has fewer features than a full SharePoint list.

Can I make a list read-only so people can see it but not edit it?

You cannot make a single list read-only while keeping the rest of the site editable. You would need to create a separate SharePoint site with read-only permissions for that group, or use a view that shows the data but ask people not to edit it. Talk to your SharePoint administrator about the best approach for your situation.

How many items can a SharePoint list hold?

SharePoint lists can hold millions of items, but performance slows down once a list grows beyond 5,000 items. If you expect your list to get very large, ask your administrator about indexing columns (which speeds up filtering and sorting) or archiving old items to a separate list.

Can multiple people edit the same item at the same time?

No. When one person opens an item to edit it, SharePoint locks it so others see a message that it is being edited. Once that person saves and closes the item, the next person can edit it. This prevents conflicting changes, but it means people have to take turns editing the same item.