What a SharePoint list is and why you'd create one

A SharePoint list is a container for organized data that your team can view, edit, and filter together in one place. Think of it as a shared spreadsheet that lives on your organization's SharePoint site instead of someone's computer. You create a list when you need multiple people to add information to the same collection — a project tracker, an event sign-up sheet, an inventory log, or a client contact database.

The main reason to use a list instead of a shared Excel file is that SharePoint handles permissions, version history, and real-time updates automatically. When one person changes an entry, everyone sees the change immediately. You don't have to email files back and forth or worry about someone accidentally overwriting someone else's work.

Key Takeaways

  • You create a list by going to your SharePoint site, clicking the plus icon, and choosing either a blank list or a template like Tasks or Contacts.
  • After you create the list, you add columns to define what information each entry will hold — title, date, status, person assigned, or any other field your team needs.
  • You can set permissions so only certain people can view or edit the list, and SharePoint tracks who changed what and when.
  • Lists work on phones and computers, and you can view the same list as a calendar, timeline, or board if the columns support it.

Creating a blank list step by step

Start by opening your SharePoint site in a web browser. At the top of the page, you'll see a plus icon (usually labeled "New" or with a plus symbol). Click it and select "List" from the menu that appears.

SharePoint will show you two options: "Blank list" and "From template". Choose "Blank list" if you want to build exactly what you need. Give your list a name — something clear like "Project Tasks" or "Client Contacts" — and optionally add a description so people know what the list is for. Click "Create".

SharePoint will create the list with one default column called "Title". This is where the main entry name or subject goes. You're now ready to add more columns that match what your team needs to track.

Adding columns to hold the information you need

Once your list exists, you need to define what data each entry will contain. Click the plus icon at the right end of the column headers (or click "Add column" if you see that option). SharePoint will ask you to choose a column type.

Common column types include:

  • Single line of text — for names, titles, or short descriptions
  • Multiple lines of text — for longer notes or comments
  • Date — for due dates, start dates, or any calendar date
  • Person or group — to assign tasks or link entries to team members
  • Choice — to create a dropdown menu with set options like "High", "Medium", "Low"
  • Yes/No — for checkboxes or true/false fields
  • Number — for quantities, counts, or scores

Pick the type that matches your data, name the column, and configure any extra settings (for example, if you choose "Choice", you'll type in the options people can pick from). Click "Save". Repeat this for each column your list needs.

Using templates to start faster

If you don't want to build from scratch, SharePoint offers pre-built templates for common needs. When you click the plus icon and select "List", choose "From template" instead of "Blank list". You'll see options like Tasks, Contacts, Calendar, Issues, and others depending on your SharePoint version.

Templates come with columns already set up for their purpose. A Tasks template includes columns for Title, Assigned To, Due Date, and Status. A Contacts template includes Name, Email, Phone, and Company. You can still add, remove, or rename columns after you create the list from a template, so using a template just saves you the initial setup time.

Setting permissions so the right people can see and edit

By default, a new list inherits permissions from the SharePoint site it's on. Everyone with access to the site can view and edit the list. If you need tighter control, click the settings icon (usually a gear) and select "List settings" or "Permissions".

From there you can break inheritance from the site and set custom permissions. You might allow everyone to view the list but only managers to edit it, or you might restrict the entire list to one team. SharePoint shows you exactly who has what level of access and lets you add or remove people by name or group.

Keep in mind that changing permissions after people have already added data doesn't erase their entries — it only changes who can see them going forward.

Adding entries and using views to organize them

Once your columns are set up, you or your team can start adding entries. Click "New" at the top of the list, fill in the fields, and click "Save". Each entry becomes a row in the list.

As your list grows, you can create different views to see the data in different ways. A view is a filtered or sorted version of the same list. For example, you might create a view that shows only tasks assigned to you, or only items with a due date this week, or items sorted by priority. Click the view dropdown (usually near the top) and select "Create new view" to set up a custom view. You can also switch between views like Calendar (if you have a date column), Timeline, or Board (if you have a status column).

Frequently Asked Questions

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

Yes. Open your SharePoint list, click "New", and look for an option like "Import from Excel" or "Upload". Select your Excel file and SharePoint will map the columns. This works best if your Excel file is already organized with headers in the first row and consistent data types in each column.

What happens if I delete a column by mistake?

SharePoint moves deleted columns to the recycle bin for 93 days. Go to your site's recycle bin, find the column, and restore it. After 93 days it's permanently gone, so restore it sooner rather than later if you need it back.

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

SharePoint doesn't lock entries while someone is editing them, so two people can open the same entry at once. The last person to save will overwrite the other person's changes. For sensitive data, you might want to add a rule or note in your team's process to avoid this.

How do I make a column required so people don't leave it blank?

Click the column header, select "Edit", and toggle "Required" to on. SharePoint will then prevent people from saving an entry unless that column has a value. This is useful for fields like "Assigned To" or "Due Date" that your team needs to track.

Can I set up automatic notifications when someone adds an entry to the list?

Yes, through a feature called Power Automate (formerly Flow). Click the automation or flow icon in your list, choose "Automated cloud flow", and select a trigger like "When an item is created". You can then set up an email notification to go to specific people. This requires your organization to have Power Automate licenses available.