What is a SharePoint List? [With SharePoint List Examples]

If your organization wants to implement SharePoint, you should be familiar with SharePoint lists and libraries. These are very useful and important for storing items or documents. In this tutorial, we will focus on the SharePoint list, how to create a list in SharePoint Online, and some SharePoint list examples.

What is a SharePoint List?

A SharePoint Online list is a collection of data that’s organized in rows and columns, similar to a table in a database or a spreadsheet. Each row is referred to as a list item, and each column is known as a field or property. SharePoint lists are used to store, share, and manage structured data, and they offer a flexible way for teams to collaborate on information within the SharePoint environment.

You can also customize a SharePoint list by adding different types of columns and creating list views to display information according to your business needs.

Now, let us see how to create a list in SharePoint Online with the latest changes from Microsoft.

How to Create a List in SharePoint

Microsoft provides different ways to create a list in SharePoint. Like, you can create a list:

  • From Blank List
  • From Existing List
  • From Excel
  • From CSV
  • From Templates

1. Create a SharePoint list from a Blank list

You can create a list in SharePoint from a blank list template. In this case, it will create a custom list having one column as “Title.” it will also create a few mandatory columns like Created By, Created Date, Modified By, Modified Date, etc.

Follow the below steps:

  • Open the SharePoint Online list, then click on + New -> List like the screenshot below.
create a list in sharepoint online
  • Then, it will show a list of options here. Select + Blank list to create a list from scratch, as shown in the figure below:
create a list in sharepoint
  • Then, it will ask you to provide the list Name and Description and select the “Site navigation” checkbox if you want to display this list in the left navigation or quick launch. Then click on the “Create” button. Always provide a meaningful name for the list.
create a SharePoint list from a Blank list

Then, it will create a custom SharePoint list with the Title column, as shown in the figure below:

create a SharePoint online list from a Blank list

This is how to create a list in SharePoint list from the blank list option.

See also  Create an Anchor link on SharePoint Site Page

Here is also a video I made, you can have a look at it.

2. Create a List from an Existing List in SharePoint

This is another useful option for creating a list in SharePoint from an existing list. It works the same way as creating a list from a list template, which we usually use in the previous options of SharePoint.

This is the ideal scenario when you have a list in a SharePoint site and you want to create a list by using that list.

Now, let us see how to create a SharePoint list from an existing list. In the same screen, choose the “From existing list” option like below:

create a list from an existing list sharepoint
  • Now select an existing list from the Team or the Site to use the template for the new list. It will copy only the columns and views from the existing list to the newly created list. It will not copy the list items to the new list. Click on the next.
create list from existing list sharepoint online
  • You can see here I have selected a list from another SharePoint team site. Then, as usual, it will ask you to provide a list name, description, etc.
  • Select Create, and the SharePoint list will be created.
create a new sharepoint list from an existing list

The below image represents the newly created list from an existing SharePoint list.

create a new sharepoint online list from an existing list

This is how to create a SharePoint list from an existing list and remember it will not add the data, it will just create the structure of the list.

3. Create a SharePoint list from Excel or CSV file

You can also create a list from an Excel or CSV file in SharePoint Online.

To create a list in SharePoint from an Excel file, choose the “From Excel” option in the “Create a list” dialog box. The screenshot below is for your reference.

create new sharepoint list from excel
  • You can directly upload the Excel file or select it from the document library if you have already kept it somewhere on the SharePoint site.
create new sharepoint list from excel
  • To import an Excel file as a list, make sure that you have created the Excel file in Table format with the columns. If the, first format the Excel in Table format.
  • If the Excel file is not in the table format, then we can see, that the Next button is disabled.
create a sharepoint list from csv
  • Once you changed the excel file to the Table format, you can see that the Next button is enabled. Now click on the Next button.
create a sharepoint list from excel file
  • Now add a SharePoint list Name, which is required.
  • Add a Description of the list which is optional, if you want to show the list in the SharePoint site Navigation, select the Show in Site Navigation check box.
  • Select Create, and the SharePoint list will be created.
create a sharepoint list from excel

The below screenshot represents the newly created list from an Excel file.

create a sharepoint list from csv

This is how to create a SharePoint list from an Excel file. The exact same steps, you can follow to create a list in SharePoint Online from a CSV file.

See also  How to update SharePoint Multiselect column in Power Automate

4. Create a SharePoint list from a Template

Microsoft provides different useful templates and you can also use those templates to create a list in SharePoint. In the same, “create a list” dialog box, you can see a lot of templates like: Issue tracker, Employee onboarding, Event itinerary, Asset manager, etc.

In this example, I am going to use the Employee onboarding template list.

create a sharepoint list from template

Once you select the SharePoint template list, click the Use Template button.

create a sharepoint online list from template
  • Then, it will ask you to provide the details like list name, description, etc.
  • Select Create, and the SharePoint list will be created.
To create a SharePoint list from a Templates

You can see the screenshot below for the newly created SharePoint list which is created from a Template.

create a SharePoint online list from a Templates

This is how to create a SharePoint list from a Template.

SharePoint list examples

Now, let us check out a few SharePoint list examples that you can create and use in various examples. Here are 9 SharePoint list examples. For each examples, I have added a small description and also what will be column names and the corresponding data types. You can also customize, and add/remove columns to these SharePoint lists.

1. Employee Directory

Description: A SharePoint list you can create to keep track of employee information within your organization.

  • Columns:
    • Employee ID (Number)
    • Full Name (Single line of text)
    • Department (Choice)
    • Position (Single line of text)
    • Email (Single line of text)
    • Phone Number (Single line of text)
    • Start Date (Date and Time)

2. Project Tasks

Description: Project tasks lists are very important while working on a project in an organization. You can create a SharePoint list for managing tasks associated with different projects.

  • Columns:
    • Task ID (Number)
    • Title (Single line of text)
    • Description (Multiple lines of text)
    • Assigned To (Person or Group)
    • Priority (Choice)
    • Status (Choice)
    • Due Date (Date and Time)

3. Inventory Tracking

Description: Here is another SharePoint list example. You can create a SharePoint Online list to track inventory items, quantities, and related details. Check out the following details:

  • Columns:
    • Item ID (Number)
    • Item Name (Single line of text)
    • Category (Choice)
    • Quantity Available (Number)
    • Reorder Level (Number)
    • Supplier (Single line of text)
    • Last Ordered (Date and Time)

4. Event Planning

Description: If you are working in event planning and then here is another SharePoint list example. A list for organizing details about upcoming events.

  • Columns:
    • Event ID (Number)
    • Event Name (Single line of text)
    • Location (Single line of text)
    • Organizer (Person or Group)
    • Start Date (Date and Time)
    • End Date (Date and Time)
    • Budget (Currency)
See also  Code blocks are not allowed in this file SharePoint error

5. IT Support Tickets

Description: In an organization, you can create a SharePoint list to manage IT support requests and track their resolution. Below are the columns and data types.

  • Columns:
    • Ticket ID (Number)
    • Summary (Single line of text)
    • Description (Multiple lines of text)
    • Submitted By (Person or Group)
    • Priority (Choice)
    • Status (Choice)
    • Resolution Date (Date and Time)

6. Sales Leads

Description: For your sales department, you can create a list in SharePoint to track potential sales leads and their statuses.

  • Columns:
    • Lead ID (Number)
    • Company Name (Single line of text)
    • Contact Person (Single line of text)
    • Contact Email (Single line of text)
    • Lead Source (Choice)
    • Status (Choice)
    • Estimated Value (Currency)

7. Travel Requests

Description: This is another SharePoint Online list example, You can create a list for employees to submit travel requests for approval.

  • Columns:
    • Request ID (Number)
    • Employee Name (Person or Group)
    • Destination (Single line of text)
    • Purpose (Multiple lines of text)
    • Departure Date (Date and Time)
    • Return Date (Date and Time)
    • Status (Choice)

8. Asset Management

Description: You can create a SharePoint list for tracking company assets and their allocation. Here are the details:

  • Columns:
    • Asset ID (Number)
    • Asset Name (Single line of text)
    • Type (Choice)
    • Assigned To (Person or Group)
    • Purchase Date (Date and Time)
    • Warranty Expiry (Date and Time)
    • Condition (Choice)

9. Customer Feedback

Description: This is another SharePoint list example, that can be used to help businesses keep track of customer feedback. Below are the columns with data types.

  • Columns:
    • Feedback ID (Number)
    • Customer Name (Single line of text)
    • Contact Information (Single line of text)
    • Product/Service (Choice)
    • Rating (Number)
    • Feedback Date (Date and Time)
    • Comments (Multiple lines of text)
    • Follow-Up Needed (Yes/No)
    • Follow-Up Date (Date and Time)

I hope this will be helpful to you to create different types of lists in SharePoint.

Conclusion

Now, I hope you got a complete idea of what is a list in SharePoint and what are the different ways to create a list in SharePoint Online. I have also explained a list of 9 SharePoint list examples that you can follow to create different types of list in SharePoint sites.

You may also like:

  • >