What a SharePoint list actually is

A SharePoint list is a table that lives on your company's SharePoint site — think of it as a shared spreadsheet that multiple people can edit at the same time, with built-in rules about who can see what and what information goes in each column. Unlike a spreadsheet file that one person opens and closes, a list stays in one place. Everyone with permission sees the same version, and changes show up when ready.

Lists are useful when a team needs to track the same information together: project tasks, inventory, customer contacts, meeting notes, or anything else that fits into rows and columns. You can set up a list so that only certain people can edit certain columns, or so that certain fields are required before someone can save a row.

SharePoint is a Microsoft product that most organizations with Office 365 subscriptions already have access to. If your company uses Teams, Outlook, and OneDrive, you likely have SharePoint too.

Key Takeaways

  • You create a list by going to your SharePoint site, clicking "New," and choosing "List" — you can start blank or use a template.
  • You add columns by clicking the plus sign at the end of the existing columns and naming each one, then choosing what type of information it holds (text, numbers, dates, people's names, and so on).
  • You control who can see and edit the list through SharePoint's permission settings, which you reach through the site's Settings menu.
  • Once the list exists, anyone with permission can add rows by clicking "New" at the top of the list and filling in the columns.

Step 1: Open your SharePoint site and start a new list

Log into your organization's SharePoint site using your work email and password. If you do not know the address, ask your IT department or check your Teams sidebar — many organizations pin their main SharePoint site there.

Once you are on the site, look for a button labeled "New" near the top left. Click it and select "List" from the menu that appears. SharePoint will show you two options: "Blank list" or "From template." A blank list is empty and ready for you to build. A template is a pre-made structure for common tasks like tracking issues, managing projects, or keeping an inventory — you can use a template if one matches what you need, or start blank and build it yourself.

Step 2: Name your list and add a description

SharePoint will ask you to name the list. Use a name that tells people what it contains: "Q1 Project Tasks," "Customer Feedback," "Equipment Inventory," or "Meeting Action Items." Avoid vague names like "List 1" or "Data."

You can also add a description — a sentence or two explaining what the list is for and who should use it. This description appears when someone hovers over the list name, so it helps people find the right list if your site has many of them.

Click "Create" and SharePoint will build the list. It starts with one column called "Title" — you can rename this or leave it as is.

Step 3: Add columns that match what you need to track

Your list needs columns for each piece of information you want to record. If you are tracking project tasks, you might need columns for "Task Name," "Assigned To," "Due Date," and "Status." If you are tracking inventory, you might need "Item Name," "Quantity," "Location," and "Last Checked."

To add a column, look at the top of the list and click the plus sign (+) at the far right, after the last existing column. A menu will appear asking you to choose a column type. The most common types are:

  • Single line of text — for short answers like names or titles
  • Multiple lines of text — for longer notes or descriptions
  • Number — for quantities or counts
  • Date and time — for important date or timestamps
  • Person or group — for assigning tasks to team members
  • Choice — for a dropdown menu of fixed options (like "Not Started," "In Progress," "Done")

Pick the type that matches your data, name the column, and click "Save." Repeat this for each column you need. You can add more columns later if you realize you forgot something.

Step 4: Set permissions so the right people can see and edit

By default, a new list inherits the permissions of the SharePoint site it is on. If the site is shared with your whole department, the list is too. If you need tighter control — for example, if only managers should see salary information — you can change the list's permissions.

Click the three dots (•••) at the top right of the list and select "List settings." Scroll down to "Permissions for this list" and click it. From there you can stop the list from inheriting site permissions and set custom rules: you can give "Edit" permission to specific people or groups, "Read" permission to others, and "No access" to the rest.

If you are not sure how to set permissions, ask your IT department or your SharePoint site owner — they can help you lock down sensitive information.

Step 5: Add your first rows of data

Once your columns are set up, you are ready to add information. Click the "New" button at the top of the list. A form will appear with a field for each column you created. Fill in the information and click "Save." The row will appear in the list.

You can also add rows directly in the list by clicking in the first empty row and typing. Either method works — use whichever feels faster to you.

Common things people change after creating a list

After you build a list, you may want to adjust it. You can rename a column by clicking the dropdown arrow next to its name and selecting "Edit." You can delete a column the same way by selecting "Delete." You can reorder columns by dragging the column header left or right.

You can also set up rules: for example, you can make a column required so that people cannot save a row without filling it in, or you can set a default value so that a column automatically fills in with something unless the person changes it. To do this, click the column dropdown and select "Edit," then look for options like "Required" or "Default value."

If your list grows large, you can add filters and sorting so people can see only the rows they care about. Click the filter icon (a funnel shape) at the top of any column to show only rows that match certain criteria.

Frequently Asked Questions

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

Yes. Click "New" on your SharePoint site and select "List," then choose "From template" and look for "From Excel." Upload your Excel file and SharePoint will create a list with the same columns and data. The file and the list stay separate after that — changes to one do not affect the other.

What happens if someone deletes a row by mistake?

SharePoint keeps a version history of lists, so deleted rows can usually be restored. Click the three dots at the top right of the list, select "List settings," then scroll down to "Recycle bin" and click it. Deleted items stay there for 93 days. If you find the row, you can restore it.

Can I make a column show different options depending on what someone picks in another column?

Not with a straightforward dropdown, but you can set up more complex rules using SharePoint's "Flow" feature (part of Microsoft Power Automate) or by using a lookup column that pulls data from another list. This is more advanced — ask your IT department if you need this kind of logic.

How do I prevent people from editing rows they did not create?

SharePoint does not have a built-in "only edit your own rows" setting on lists. You can use item-level permissions (which is complex) or use a form-building tool like Microsoft Forms or Power Apps for more control. Ask your IT department what your organization supports.

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

SharePoint lists handle simultaneous editing better than Excel files do, but if two people edit the exact same cell at the exact same moment, one person's change will overwrite the other's. For heavy collaboration on a single item, use a document or a Teams chat instead.