What a SharePoint List Is and Why You'd Use One

A SharePoint list is a table inside Microsoft SharePoint where your team stores and organizes information together. Unlike a spreadsheet file that one person opens and closes, a list lives in one place online. Everyone with permission sees the same version at the same time, and changes show up when ready for the whole group.

You might use a SharePoint list to track project tasks, manage a contact database, log equipment inventory, record meeting notes, or store customer feedback. The list format works well when you need people to add rows regularly, search for specific information, or filter what they see without stepping on each other's work.

SharePoint lists are part of Microsoft 365, so if your organization uses Teams, Outlook, or OneDrive, you likely have access to SharePoint already. You do not need to know how to code or design databases — the interface walks you through creating columns and adding rows the same way you would in a spreadsheet.

Key Takeaways

  • You create a list by opening your SharePoint site, clicking the plus sign, and choosing either a blank list or a template that matches your purpose.
  • Columns define what information each row will hold — you add them before people start entering data, though you can add more later.
  • Column types (text, number, date, choice, person) determine what kind of information goes in each column and how SharePoint displays it.
  • Once the list exists, you control who can view it, edit it, or manage it by adjusting permissions on the SharePoint site itself.
  • You can view the same list in different ways — as a table, calendar, or chart — without creating separate copies.

Opening Your SharePoint Site and Starting a New List

Log into your Microsoft 365 account and navigate to your SharePoint site. If you do not know the web address, open Microsoft Teams, find the team connected to your SharePoint site, and click the Files tab at the top — that tab opens your SharePoint site in a new window.

Once you are on the SharePoint site, look for a plus sign or New button near the top left of the page. Click it and select List from the menu. SharePoint will show you two paths: start with a blank list, or choose from templates like "Issue tracker," "Asset library," or "Project tasks." If you are not sure which template fits, start blank — you can always add the columns you need.

Give your list a name that describes what it holds. Use something clear like "Q1 Marketing Tasks" or "Client Contact Log" rather than "List 1." You can add a description too, which helps teammates understand the list's purpose when they see it in the site menu.

Adding Columns That Match Your Data

After you name the list, SharePoint creates one blank column called "Title" by default. This column is required — every row must have something in it. You can rename "Title" to match your data (for example, "Task Name" or "Contact Name") or leave it as is and add more columns around it.

To add a new column, click the plus sign at the right edge of the column headers. SharePoint opens a panel where you choose the column type. The most common types are Single line of text (for names, email addresses, or short notes), Number (for quantities or IDs), Date (for important date or event dates), and Choice (for a dropdown list of fixed options like "High," "Medium," or "Low").

Other useful types include Person or group (which lets you assign tasks to teammates and sends them notifications), Yes/No (for checkboxes), and Lookup (which pulls information from another list). For now, focus on the basic types — you can explore advanced ones once the list is working.

Name each column clearly and in the order that makes sense for your workflow. If you are tracking tasks, you might have columns for "Task Name," "Assigned To," "Due Date," "Priority," and "Status." Do not create too many columns at once — you can add more later, and a simpler list is easier for people to use.

Setting Column Rules and Defaults

After you choose a column type, SharePoint asks whether you want to set rules. For example, you can make a column required so people cannot save a row without filling it in. You can set a default value (like today's date for a "Date Created" column) so people do not have to type it every time. You can also limit what people type — for instance, requiring a number to be between 1 and 100.

For a Choice column, you type in the options people will see in the dropdown. If you are creating a "Status" column, you might add "Not Started," "In Progress," "Complete," and "On Hold." You can let people add their own choices later, or lock it so only those four options are available.

For a Person or group column, SharePoint automatically searches your organization's directory when someone types a name. This is useful for assigning work because the person assigned gets a notification and the list shows their name with a small profile picture.

Saving Your List and Adding the First Rows

Once your columns are set up, click Create at the bottom of the panel. SharePoint builds the list and takes you to the empty table view. The list now exists on your SharePoint site and appears in the site's navigation menu on the left.

To add your first row, click the plus sign at the top left or straightforward click in the first empty row. Fill in the columns you created. If a column is required, SharePoint will not let you save the row without it. If a column has a dropdown (Choice type), you will see the options appear as you click the cell.

You do not have to fill every column in every row — only required columns matter. If a row does not need a due date or priority, leave those cells blank. SharePoint saves your changes automatically as you type, so you do not have to click a save button.

Controlling Who Can See and Edit Your List

By default, your list inherits permissions from the SharePoint site itself. Everyone with access to the site can see and edit the list. If you want tighter control — for example, letting some people view only and others edit — you need to adjust the list's permissions.

Click the three dots (menu icon) at the top right of the list and select List settings. Look for Permissions or Sharing options. From there, you can break the list's connection to the site's default permissions and set custom rules. You can give specific people or groups view-only access, editing access, or full control.

If your list contains sensitive information, consider limiting it to a small group. If it is a team resource like a shared task list, you might give everyone on the team editing rights. SharePoint tracks who changed what and when, so you can see the history of edits if you need to.

Viewing Your List in Different Formats

Once your list has data, you can display it in ways beyond the standard table. Click the View menu at the top and select Create new view. SharePoint offers several formats: Grid (the default table), Calendar (if you have a date column), Gallery (cards showing each row), and Chart (a visual summary of your data).

A calendar view is useful if your list tracks events or important date. A gallery view works well for a product catalog or photo library. A chart view can show you how many tasks are in each status or how many items are assigned to each person. All views pull from the same list — changing a row in one view updates it in all the others.

You can also filter and sort any view. Click the filter icon to show only rows that match certain criteria (for example, "Status equals In Progress"). Click the column header to sort by that column. These filters do not change the list itself — they just change what you see on screen.

Frequently Asked Questions

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

Yes. Open your SharePoint list, click the plus sign, and select From Excel. Upload your spreadsheet and SharePoint will create columns matching your Excel headers. The data imports into the new list automatically. Make sure your Excel file has headers in the first row and consistent data types in each column.

What happens if I delete a row by accident?

SharePoint keeps a version history of your list. Click the info icon (i) at the top right, then Version history, and you can restore the list to an earlier state. You can also check who deleted the row and when by looking at the activity log in the same menu.

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

Yes. SharePoint is designed for real-time collaboration. When one person adds or changes a row, everyone else sees the update within seconds. You do not have to worry about conflicting edits or one person's changes overwriting another's.

How do I add a column after people have already started using the list?

Click the plus sign at the right edge of the column headers, set up the new column the same way you did the first time, and click Create. Existing rows will have the new column empty unless you set a default value. New rows will use the default if you created one.

Can I connect a SharePoint list to other Microsoft 365 tools?

Yes. You can link a list to Power Automate to send notifications when rows change, or use Power BI to create dashboards from your list data. You can also embed a list view in a Teams channel so your team sees updates without leaving Teams. These integrations are built into Microsoft 365 and do not require extra software.