SharePoint List Examples [15 Real Examples]

In this SharePoint tutorial, we will discuss a few SharePoint list examples. These are the list examples that we have created using different types of data types to store various information.

SharePoint List Examples

Here are the examples of SharePoint lists that we have created on our SharePoint Online team site. You can also create all these lists in a SharePoint on-premise environment, like SharePoint Server 2019 or SharePoint Server subscription editions. Check out these 15 useful SharePoint lists.

After reading this tutorial, you will learn how to create a custom list in SharePoint Online as well as how we can add various columns of different data types to a SharePoint Online list.

Example-1: Clients list

This is a SharePoint list example where one of our clients in the USA wanted to show their clients list. The client wanted to store the following information:

  • Client ID
  • Client Names
  • Contact Information
  • Client Addresses, etc.

For that, we have created a custom SharePoint list and created columns like the below:

sharepoint list examples

Here are the column details:

  • Title: The Title column is created by default when creating a SharePoint list. Based on our requirements, we can rename it to store the Client ID.
  • Client Name: This single line of text type column in which we have saved the client’s name.
  • Client Phone Number: This Number type column in which we have saved the client’s Phone Number. But if we choose datatype as a number, by default, it previews with a comma of Thousand Separator (1,000). To remove a thousand separators from the number, expand More options and deselect the toggle option ‘Use thousands Separator’ (Ex: 1000) as shown below:
SharePoint custom list examples
  • Client Website: This Hyperlink type column, in which we have saved the client’s Website URL. For Example: https://<CompanyDomainName>.com
sharepoint lists examples
  • Client Address: This is a Location type column in which we have saved the client’s location. Also, it shows linked columns in the current view contains as we can choose additional information to show, such as Street Address, City, State, Country or Region, Postal Code, Coordinates, Name, etc
sharepoint list example
  • Is Still Client Active: This Yes/No type column in which we have saved the information on the client, whether they are still active or not, so select Data type as Yes/No
SharePoint list examples
  • Client Rating: This Rating type column is not available in the see-all column type. To add Ratings to our list, the following steps are:
    • Go to List settings -> Select Rating Settings
    • That appears with the choice column as Yes/No -> Select Yes and Select Star Ratings experience, which you would like to enable for the list.
sharepoint list design examples

Here, we create the table containing information like Column Display Name, Column Internal Name, Data Type, and Default Value.

Column Display NameColumn Internal NameData TypeDefault Value
Client ID Title A single line of TextNA
Client NameClientsA single line of TextNA
Client Phone NumberClientPhoneNumberNumberNA
Client WebsiteClientWebsiteHyperlinkNA
Client AddressClientAddressLocationNA
Is Still Client ActiveIsStillClientActiveYes/NoYes
Client RatingAverageRatingRating (0-5)0 or empty

This is an example of a SharePoint list where you can store this information.

Example-2: Products list

Here is another SharePoint Online list example, where one of our clients wanted to store information about their product details. They wanted to save information like:

  • Product ID
  • Product Name
  • Product Description
  • Is Product Available, etc.

The SharePoint list with a few records looks like below:

sharepoint list examples

Here are the columns with the data types we created for the SharePoint list.

  • Title: We renamed the default ‘Title‘ column to the Product ID.
  • Product Name: This is a single line of text type column in which we have saved the Product’s name.
  • Product Description: This is a Multiple lines of text type column storing the Product Description.
  • Product Cost: This is a Currency type column in which we have saved the cost of the product as Product Cost in the currency format of the United States.
sharepoint list examples
  • Product Quantity: This is a Number type column in which we have saved the number of products as Product Quantity. But if we choose datatype as a number, by default it previews with a comma of Thousand Separator (1,000). To remove a thousand separators from the number, expand More options and deselect the toggle option ‘Use thousands Separator’ (Ex: 1000)
  • Is Product Available: This Yes/No type column in which we have saved the information of the product, whether the product is available or not, so select Data type as Yes/No
  • Product Rating: This Rating type column is not available in the see all column type, To add Ratings to our list, the following steps are:
    • Go to List settings -> Select Rating Settings
    • That appears with the choice column as Yes/No -> Select Yes and Select Star Ratings experience which you would like to enable for the list.

Here, we create the table containing information like SharePoint list Column Display Name, Column Internal Name, Data Type, and Default Value.

Column Display NameColumn Internal NameData TypeDefault Value
Product IDTitleA single line of TextNA
Product NameProductNameA single line of TextNA
Product DescriptionProductDescriptionMultiple lines of textNA
Product CostProductCostCurrencyNA
Product QuantityProductQuantityNumberNA
Is Product AvailableIsProductAvailableYes/NoYes
Product RatingAverageRatingRating (0-5)0 or empty

This is what the SharePoint Custom Products list looks like.

Example-3: Transaction Details list

If you have a requirement to store transaction details, then this SharePoint Online list example is for you. We have the same client from the USA and wanted to store a few transaction details.

They wanted to store information like

  • Transaction ID
  • Product ID
  • Supplied Product
  • Product Supplied Date
  • Product Cost
  • Product delivery person
  • Paid or not, etc
sharepoint lists examples

According to the above columns, you can enter the items in the respective columns of the SharePoint list.

Here are the column details:

  • Title: We renamed the default ‘Title‘ column to the Transaction ID.
  • Product ID: This is a Lookup type column in which we have selected a list as a source from the Semiconductor Products column -> Select a Column from the list above (By default Title will be chosen) -> Expand More Options, to add additional columns from the source list looks like a Choice column, displaying multiple options for the user to choose from which Semiconductor Products column, Choose Product Name as shown below:
SharePoint custom list example
  • Product ID: ProductName:- Here, we have created a Lookup type column by taking the columns (Product ID and ProductName) from the above-mentioned SharePoint lists. We can also rename this column to the Supplied Product based on our requirements.
  • Product Supplied Date: This is the Date and time type column in which we have saved the date of the Product Supplied using Calendar.
Example of SharePoint Online custom list
  • Product Cost: This is a Currency type column in which we have saved the cost of the product as Product Cost in the currency format of the United States.
  • Client ID: This is a Lookup type column in which we have selected a list as a source from the Semiconductor Clients column -> Select a Column from the list above(By default Title will be chosen) -> Expand More Options, to add additional columns from the source list.
sharepoint list example
  • Product Delivery Person: This is a Person type column in which we have added the person who delivers the product.
SharePoint Online custom list example
  • Is Paid or Not: This is the Choice type column in which we have saved the information of the transaction that the client is paid, or kept balance, or else it is in Draft. We gave the choices as paid, Balance, and Draft. Where the user can select the choice as per their requirement.
Example of SharePoint custom list containing of different columns
  • Digitally Paid: This Yes/No type column in which we have saved the information of the Transaction, whether the transaction is digitally paid or not, so select Data type as Yes/No.

Here, we create the table containing information like Column Display Name, Column Internal Name, Data Type, and Default Value.

Column Display NameColumn Internal NameData TypeDefault Value
Transaction IDTitleA single line of TextNA
Product IDProductIDLookupNA
Supplied ProductSuppliedProductLookupNA
Product Supplied DateProductSuppliedDateDate and TimeNA
Product CostProductCostCurrencyNA
Client IDClientIDLookupNA
Product Delivery PersonProductDeliveryPersonPerson or GroupNA
Is Paid Or NotIsPaidOrNotChoiceNA
Digitally PaidDigitallyPaidYes/NoYes
Column Name and Column Types with Default values

I hope you got some ideas from this SharePoint list example.

Example-4: Issue Tracker

This is a common requirement to store issue details in SharePoint. Here, the organization wants to store information like:

  • Issue ID
  • Issue
  • Issue Description
  • Issue Status
  • Issue Assigned person
  • Is still active or not, etc.

For this, we have created a custom SharePoint list and created columns like the below:

sharepoint custom list examples

Here are the SharePoint list column details:

  • Issue ID: We renamed the default ‘Title‘ column to the Issue ID.
  • Issue: This is a single line of text type column in which we have saved the Issue of a Product Supplied.
  • Issue Description: This is a Multiple lines of text type column in which we have saved the purpose of the Issue as an Issue Description.
  • Issue Status: This is the Choice type column in which added choice options like In Progress, Completed, and Won’t Fix.
  • Issue Assigned To: This is a Person type column in which we have added the person who can resolve this Issue of the Product.
  • Issue Image: This is an Image type column in which we have stored the image of an Issue in the product by uploading it from the local system.
sharepoint custom list examples
  • Is Still Issue is Active: This Yes/No type column in which we have saved the information of an Issue, whether the Issue is still active or not, so select Data type as Yes/No.
  • Issue Resolved Date: This is the Date and time type column in which we have saved the date of the Issue got Resolved using Calendar.

Here, we create the table containing information like Column Display Name, Column Internal Name, Data Type, and Default Value.

Column Display NameColumn Internal NameData TypeDefault Value
Issue IDTitleA single line of TextNA
IssueIssueA single line of TextNA
Issue DescriptionIssueDescriptionMultiple lines of textNA
Issue StatusIssueStatusChoiceNA
Issue Assigned ToIssueAssignedToPersonNA
Issue ImageIssueImageImageNA
Is Still Issue is ActiveIsStillIssueIsActiveYes/NoYes
Issue Resolved DateIssueResolvedDateDate and timeNA

I hope you got an idea of how to create an issue list from this SharePoint list example.

Example-5: Doctors List

Here is an example of a SharePoint list where one of our clients wanted to store doctor’s information in SharePoint.

They wanted to store pieces of information like:

  • Doctor ID
  • Doctor Name
  • Contact number
  • Address
  • Education, etc.

Here are the column details:

  • Title: This is the Default Column in the List. Here, we rename this to Doctor ID, where the Data type is automatically taken as a Single line of text.
  • Doctor Name: We have created a single line of text named ‘Doctor Name’ to store the name of the Doctors where the Maximum number of characters is up to 255.
sharepoint list examples
  • Country And Areacode: We have created a single-line text column as a data type named-‘Country and Areacode’ to store the country and Area code.
SharePoint Online List Example
  • Mobile Number: We have created the Number type column named- ‘Mobile Number’, but it is shown in the format as shown in the example : (25,000).To disable this use the thousands separator option in the Edit column.To remove a thousand separators from the number, expand More options, and deselect the toggle option ‘Use thousands Separator’ (Ex: 25000).
  • Alternate Mobile Number: we have created a Number type column named –‘Alternate Mobile Number’ i.e, used to store information like Doctor Contact Numbers by deselecting the toggle option ‘Use thousands Separator’.
Online SharePoint List Example
  • Email Address: We have created this as a Single line of text named-‘Email Address’i.e, used to store the Doctor’s email address.
sharepoint list examples
  • Board of Certification: Here, we have created a choice column for the Board of Certification and we have inserted the choice options like The American Board of Internal Medicine, American Board of Orthopedic Surgery, American Board of Anesthesiology, American Board of General Medicine, American Board of Pathology, and American Board of Surgery.
  • Along with this, we have a display choice that will be a Drop-Down menu ( To Allow multiple selections, click on more options and enable it)where we can use various choices from the choice list options.
sharepoint list examples
  • Education: We have created this as a Single line of text named-‘Education‘ to store the education details of Doctors.
sharepoint list examples
  • Address: Here, We have created the Location column named – ‘Address’ and selected linked columns in the Edit column for example, state, Country, or region, It will automatically create the columns of Address of State and Address of Country or Region in the List.
SharePoint site List Examples
  • Languages known: Here, we have created another choice column named-‘Languages known, and the chosen values are English, Spanish, and French. It allows displaying choices in Different ways like the Drop-Down menu or Radio buttons.
    • Along with this, there is another option of Allow Multiple selections(by enabling Allow multiple selections where the user can choose more than one option from the choice values).
sharepoint 2013 list examples
  • Specialty: We have created another Choice column named-‘speciality‘ where we can mention the specialization of Doctors and the choice values with a display option as a Drop-Down Menu like below.
sharepoint 2013 list examples
  • Experience: We have created a single-line text column named –‘Experience’ is used to store the experience of Doctors’ in year’s format.
sharepoint 2013 list examples
  • Rating Column: Here we have created a Rating column for the Doctors Review. The column is taken from the Rating settings (This option is not available in the Types of columns, we can reach the Rating settings with these steps Gear icon -> List settings -> Rating settings).
    • From the Rating settings, we can select the option of Star ratings or likes. Here, we have used the star mark option in it.
Custom List Example of SharePoint Online site

Below, we have created the Table that will display the information on this list, such as Column Display Name, Column Internal Name, Column Data Type, and Default value. The table format is given below:

Column Display NameColumn Internal NameColumn Data Type Default value
Title-we have renamed this to Doctor IDTitleSingle line TextNA
Doctor NameDoctorNameSingle line TextNA
Country and Area codeCountry and Area codeSingle line TextNA
Mobile NumberMobileNumberNumberNA
Alternate Mobile NumberAlternateMobile NumberNumberNA
Email AddressEmailAddressSingle line TextNA
Board CertificationBoardCertificationChoiceNA
EducationEducationSingle line textNA
AddressAddressLocationNA
Languages knownLanguages knownChoiceNA
SpecialitySpecialityChoiceNA
ExperienceExperienceSingle line textNA
RatingRatingNANA

This is the Overview of the SharePoint List example.

SharePoint Custom List Example

Example-6: Services List

One of our clients, based in the USA, wanted to store the Services they provide to the clients in their SharePoint site portal. They want to store information like:

  • ServiceID
  • Service Name
  • Service Type
  • Primary care
  • Disease Type, etc.

For this, we have created a custom SharePoint list and created columns like the below:

sharepoint 2016 list examples
  • Service ID: We have renamed this column to Service ID as the client requires.
  • Service Name: This is created as a Single line of text to store Service Name.
  • Service Type: Here, we have created a choice column to store different types of Services. It allows displaying choices in different ways, like the Drop-Down menu or Radio buttons.
    • There is another option of “Allow Multiple selections” (by enabling Allow multiple selections where the user can choose more than one option from the choice values).
  • Primary Care: We have created a single-line text column named -‘Primary Care‘ is used to store the Primary care taken for the particular Service type.
  • Disease Type: Here, we have created this as a Single line of text named-‘Disease Type‘i.e, used to store the Type of Disease that is treated by the Hospital.
  • Specialized Doctor: We have created a Lookup column named-‘Specialized Doctor‘ that is used to store the information related to Doctors who are specialized in a particular disease type.
  • Here, in the look-up column, we can select the list source and list columns from the previously stored list.
    • We have selected a list source and list column regarding the requirement from the client i.e,(List source: Doctors, List column: Doctor Name).
    • It will create a Lookup column with Doctor names.
sharepoint 2016 list examples
  • Health Insurance: We have created a yes/No type column named -‘ Health Insurance’ is used to store the Health Insurance taken for the particular Service type.
    • By default, it will display a yes value in the edit column.
SharePoint List Examples based on different column.
  • Service Cost: We have created a Currency column named- ‘Service Cost‘ that allows all the currency formats, but as per our requirement, we have to use United States currency in the Service Cost.

Below we have created the Table that will display the information on this list such as Column Display Name, Column Internal Name, Column Data Type, and Default value. The table format is given below:

Column Display NameColumn Internal NameColumn Data TypeDefault value
Title- we have renamed this to the Service IDTitleSingle line textNA
Service NameService NameSingle line textNA
Service TypeServiceTypeChoiceNA
Primary CarePrimary CareSingle line textNA
Disease TypeDiseaseSingle line textNA
Specialized DoctorAssignedDoctorLookupNA
Health InsuranceHealth Insuranceyes/NoYes
Service CostService CostCurrencyNA

I hope you get some idea from this list example in SharePoint.

Example-7: Careers List

The same client wanted to store career opportunities like Jobs for various roles in a SharePoint list.

They wanted to store information like Job ID, Job Role, Job Description, Experience level, Posted Date, Expiry Date, Job Location, etc. For this, we have created a custom SharePoint list and created columns like the below:

sharepoint 2016 list examples
  • Job ID: This is the ‘ Title ‘Default Column in the List. Here we rename this to Job ID.
  • Job Role: This column we created to store Job Roles.
  • Job Description: This is a multiline text column to store the Job Description. More than 255 characters can be used in the multiple lines of text.
  • Experience Level: This column can be a choice or single line of column to store the experience level.
  • Posted Date: We have created a column for the posted date to track the job posting date. You can also use the Created Date default column.
    • Here, in the Date and Time Type Column, we can also Select the Include Time option by clicking on the toggle selection.
    • Thus, we can select the Date from the calendar icon.
  • Expiry Date: We have created a Date and Time column named Expiry Date. Users can select the date from the date picker as per their requirements.
sharepoint 2019 list examples
  • Location: Here, We have created the Location column named – ‘Location‘ and selected linked columns in the Edit column for example state, Country, or region, It will automatically create the columns of Address of State and Address of Country or Region in the List.
  • Job Type: We have created a Choice column named Job Type having choices like Regular, work from home, and Part-time.
  • No Of Vacancies: We have created a Number column named No Of Vacancies. By default, the Number column comes with a thousand separators. As per requirement, we need to display the No of Vacancies without separators. So, here we have disabled the option “Use a thousand separators”.
  • Annual CTC: We have created a Currency column named- ‘Annual CTC’ that allows all the currency formats but as per our requirement, we have to use United States currency in the Annual CTC.
Column Display NameColumn Internal NameColumn Data TypeDefault Value
Title-we have renamed this to the Job IDTitleSingle line textNA
Job RoleJobRoleSingle line textNA
Job DescriptionJob DescriptionMultiple lines of textNA
Experience levelExperience levelSingle line textNA
Posted DatePosted DateDate and TimeNA
Expiry DateExpiry DateDate and TimeNA
LocationLocationLocationNA
No Of VacanciesNo Of VacanciesNumberNA
Annual CTCAnnual CTCCurrencyNA

I hope you now understand this SharePoint list example.

Example-8: Patients List

From the same client, we got another requirement to store patient details in a SharePoint list. They wanted to store information like:

  • Patient ID
  • Patient Name
  • Contact number
  • Address
  • Gender, etc.

For this, we have created a custom SharePoint list and created columns like the below:

Examples of Custom list in SharePoint
  • Patient ID: This is the ‘ Title ‘Default Column in the List. Here we rename this to ‘Patient ID‘.
  • Patient Name: This is created as a Single line of text named-‘Patient Name’to store the name of the Patient as per our requirements. In Single line text, the Maximum number of characters is up to 255.
  • Gender: Here, We have created a Choice column named Gender having the following choices like Male, Female, etc.
  • Patient Age: We have created a Number column named Patient Age. By default, the Number column comes with a thousand separators. As per requirement, we need to disable the Thousand separators option.
  • Blood Group: Here, we have created a Choice column named Blood Group having the following choices such as O+, O-, A+, A-, B+, B-, AB+, and AB-, etc.
  • Disease Type: In the same way, we have created a Choice column named Disease Type with the following choices: Heart Disease, Eye Disease type, Injury and wound care, Endocrine disorder, Cancer, Respiratory, and Pediatric.
  • Country and Area Code: We have created a single-line text column as a data type named-‘Country and Areacode‘ to store the codes of country and Area.
  • Mobile Number: We have created a Number column named Mobile Number. Here, we also disabled the option to display a thousand separators within the number.
  • Email Address: we have created this as a Single line of text named-‘Email Address‘i.e, used to store the patient’s email addresses.
  • Permanent Address: Here, we have created the Location column named – ‘ Permanent Address’ and selected linked columns in the Edit column for example state, Country, region, and City. It will automatically create the columns of Address of State and Address of Country or Region in the List.
Column Display NameColumn Internal NameColumn Data TypeDefault Value
Title-we have renamed this to the Patient IDTitleSingle line textNA
Patient NamePatientNameSingle line textNA
Patient AgePatientAgeNumberNA
GenderGenderChoiceNA
Blood GroupBloodGroupChoiceNA
Disease TypeDiseaseTypeChoiceNA
Country And Area CodeCountryAndArea CodeSingle line textNA
Mobile NumberMobileNumberNumberNA
Email AddressEmailAddressSingle line textNA
Permanent AddressPermanentAddressLocationNA

This is another SharePoint Online list example.

Example-9: Furniture Types List

According to the requirements from the client, we wanted to store furniture types in a SharePoint Online list. They wanted to store information like Furniture name, price, category, color, etc. For this we have created a custom SharePoint list named Furniture Types and created columns like the below:

SharePoint modern custom List example

Here, we have created the different types of columns for the SharePoint custom list, such as:

  • Title: We rename this default Title column to Furniture ID as per our requirement.
  • Furniture Name: This single line of text column will be used to store the furniture name.
sharepoint list examples
  • Features: We have created a multiple-line of text column to store the furniture’s features.
Example of SharePoint modern list
  • Color: We have created a Choice column named Color having the choices Brown, Black, White, Yellow, Red, and Blue. Once we enable Allow multiple selections, the user can select multiple colors.
SharePoint modern custom list examples
  • Category: We have created a Choice column named Category having the choices Dining-Kitchen, Office, Outdoor, Living, Bedroom, and Children. Where the user can select the Category as per their requirement.
Examples of SharePoint List
  • Price: We have created a Currency column named Price that allows all the currency formats; but as per our requirement, we have used United States currency.
Examples of SharePoint custom list
  • Quantity: We have created a Number column named Quantity. By default, the Number column comes with a thousand separators. As per requirement, we need to display the product’s quantity without separators. So, here we have disabled the option”Use a thousand separators”.
sharepoint 2019 list examples
  • Locations: We have created a Choice column named Locations having the choices Florida, Indiana, and Georgia. We enabled the Allow multiple selections where the user can select multiple locations.
sharepoint online list examples
  • Image: To provide furniture images, we can create a column of the Image datatype. When a user inserts an image while adding the furniture, they can either provide a URL or upload it from their desktop.
sharepoint online custom list examples
  • Style: We have created a Choice column named Style having the choices Colonial American Furniture, Contemporary Furniture, Country, and Farmhouse. From where the user can select the Style as per their requirement
sharepoint online custom list examples

Here, we have created a Table with column information such as Column Display Name, Column Internal Name, Data Type, and Default Value.

Column Display NameColumn Internal NameData TypeDefault Value
Title Column – We rename this column to Furniture IDTitleSingle Line TextNA
Furniture NameFurnitureNameSingle Line Text
NA
ColorColorChoiceNA
FeaturesFeaturesMultiple lines of textNA
PricePriceCurrencyNA
CategoryCategoryChoiceNA
QuantityQuantityNumberNA
StyleStyleChoiceNA
ImageImageImageNA
LocationsLocationsChoiceNA

This is how we created a SharePoint custom list.

Example-10: Customer Details List

According to the requirements from the client, we wanted to store Customer Details in a SharePoint Online list. They wanted to store information like Customer ID, Customer Name, Gender, Mobile number, Permanent Address, etc. For this we have created a custom SharePoint list named Customer Details and created columns like the below:

sharepoint custom list examples

Here, we have created the different types of columns for the SharePoint custom list such as:

  • Customer ID: We rename this default Title column to Customer ID as per our requirement.
  • Customer Name: This single line of text column will be used to store the customer name.
  • Gender: We have created a Choice column named Gender having the choices Male, Female, and Others. Where the user can select the Gender as per their requirement.
  • Country And Area Code: This single line of text column will be used to store the customer’s country and area code.
  • Mobile Number: We have created a Number column named Mobile Number. By default, the Number column comes with a thousand separators. As per requirement, we need to display the Phone Number without separators. So, here we have disabled the option”Use a thousand separators”.
  • Emergency Number: We have created a Number column named Emergency Number. Here, also we disabled the option to display a thousand separators within the number.
  • Email: This single line of text column will be used to store the customer’s Email ID.
  • Permanent Address: This Location type column in which we will save the Customer’s permanent address. Also, it shows linked columns in the current view contains as we can choose additional information to show as Street Address, City, State, Country or Region, Postal Code, Coordinates, Name, etc
sharepoint custom list examples

Here, we have created the Table having column information like Column Display Name, Column Internal Name, Data Type, and Default Value.

Column Display NameColumn Internal NameData TypeDefault Value
Title Column – We rename this column to a Customer IDTitleSingle Line TextNA
Customer NameCustomerNameSingle Line Text
NA
GenderGenderChoiceNA
Country And Area CodeCountryAndAreaCodeSingle Line TextNA
Mobile NumberMobileNumber NumberNA
Emergency NumberEmergencyNumberNumberNA
EmailEmailSingle Line TextNA
Permanent AddressPermanentAddressLocationNA

This is another SharePoint Online list example that we have created from a custom list.

Example-11: Order Forms List

According to the requirements from the client, we wanted to store Order Forms in a SharePoint Online list. They wanted to store information like Customer ID, Furniture ID, Order Date, Delivery Date, Order Quantity, Payment, Discount, etc. For this we have created a custom SharePoint list named Order Forms and created columns like the below:

sharepoint list examples

Here, we have created the different types of columns for the SharePoint custom list such as:

  • Customer ID: We rename this default Title column to Customer ID as per our requirement.
  • Furniture ID: We have created a Lookup column named Furniture ID. It provides all the information about the Furniture. In the look-up column, we can select the list source and list columns from the previously stored list(Furniture Type).
sharepoint list examples
  • Order Date: We have created a Date and Time column named Order Date. Where users can select the date from the date picker as per their requirements.
  • Delivery Date: We have created a Date and Time column named Delivery Date. Where users can select the date from the date picker as per their requirements.
  • Order Quantity: We have created a Number column named Order Quantity. By default, the Number column comes with a thousand separators. As per requirement, we need to display the Order Quantity without separators. So, here we have disabled the option Use a thousand separators.
  • Payment: We have created a Choice column named Payment having the choices Online, and Offline. Where the user can select the Payment as per their requirement.
  • Discount: We have created a Number column named Discount. Here, we have selected a Preview as a percent(%) in the Number column. Where the user can select Discount as per their requirement.
sharepoint 2013 list examples
  • Quality: We have created a Choice column named Quality having the choices Good, Better, and Excellent. Where the user can select the Quality as per their requirement.
  • Door Delivery: We created a Yes/No column named Door Delivery. Here, the user can select the option Yes/No as per their requirement.
  • Rating: This Rating type column is not available in the all column type, to add Ratings to our list, the following steps are:
    • Go to List settings and select Rating Settings.
    • It will appear with the choice column as Yes/No. If we Select Yes and select Star rating/Likes. Then the Rating option appears in the list columns.
sharepoint 2016 list examples

Here, we have created the Table having column information like Column Display Name, Column Internal Name, Data Type, and Default Value.

Column Display NameColumn Internal NameData TypeDefault Value
Title Column – We rename this column to a Customer IDTitleSingle Line TextNA
Furniture IDFurnitureIDLookup
NA
Order DateOrderdateDate and TimeNA
Delivery DateDeliverydateDate and TimeNA
Order QuantityOrderQuantity NumberNA
PaymentPaymentChoiceNA
DiscountDiscount NumberNA
QualityQualityChoiceNA
Door DeliveryDoorDeliveryYes/NoYes
RatingAverageRatingRatingNA

This is how we created the SharePoint custom list.

Example-12: Company Details List

According to the requirements from the client, we wanted to store Company Details in a SharePoint Online list. They wanted to store information like Company ID, Company Name, Opening Time, Closing Time, Contact Number, Email, etc. For this we have created a custom SharePoint list named Company Details and created columns like the below:

SharePoint Online custom list based on different columns
SharePoint Online custom list based on different columns

Here, we have created the different types of columns for the SharePoint custom list such as:

  • Company ID: We rename this default Title column to Company ID as per our requirement.
  • Company Name: This single line of text column will be used to store the Company name.
  • Opening Time: We have created a Single line of text column named Opening Time. Here, we don’t use the Date and Time column. Once we are using the Date and Time column it will appear with the date also. So, we have used the Single line of text column for Opening Time.
  • Closing Time: We have created a Single line of text column named Closing Time. Here, users can select the Closing Time as per their requirements.
  • Contact Number: We have created a Number column named Contact Number. Here, also we disabled the option to display a thousand separators within the number.
  • Email: This single line of text column will be used to store the Company Email ID.
  • Video Library: We have created a Hyperlink or Picture column named Video Library. Here, users can provide a hyperlink for Company Details as per their requirements.
  • Locations: We have created a Choice column named Locations having the choices Florida, Indiana, and Georgia. Where users can select the Location as per their requirements.
  • Address: We have created a multiple-line of text column to store the Company address.
  • Visitor ID: We have created a Number column named Visitor ID. Here, also we disabled the option to display a thousand separators within the number.

Here, we have created the Table having column information like Column Display Name, Column Internal Name, Data Type, and Default Value.

Column Display NameColumn Internal NameData TypeDefault Value
Title Column – We rename this column to a Company IDTitleSingle Line TextNA
Company NameCompanyNameSingle Line Text
NA
Opening TimeOpeningtimeSingle Line TextNA
Closing TimeClosingtimeSingle Line TextNA
Contact NumberContactnumber NumberNA
EmailEmailSingle Line TextNA
Video LibraryVideoLibrary Hyperlink or ImageNA
LocationsLocationsChoiceNA
AddressAddressMultiple lines of textNA
Visitor IDVisitoridNumberNA

This is how we created the SharePoint custom list.

Example-13: Employee Directory List 

As per the requirement of our client, we need to store all basic information about the members of the company, including their ID, Name, Job Title, Contact Information, etc. For this, we have created an ‘Employee Directory’ custom SharePoint online list as shown below:

SharePoint online custom list

Let’s see the list of columns and their data types, that we have used in the above SharePoint list as shown below:

  • Employee ID: Here, we have renamed the default ‘Title’ column to Employee ID.
  • Employee Name: We have taken a ‘single line of text’ data type column to store the employees’ names.
Example of SharePoint list
list
  • Employee Image: We have created the ‘image’ data type to store images of the employees by uploading them from the local system.
Custom SharePoint List
  • Employee Email: Here, we have used a ‘Single lines of text’ data type column to provide the Employee’s Email.
sharepoint 2019 list examples
  • Employee Contact Number: We have created this column using the ‘Number’ data type and disabled the ‘Use thousands separator‘ toggle because if it is enabled then it shows a comma after every 3 digits (like this 123,567).
SharePoint online list examples
  • Employee Location: Here, we have used the ‘location’ data type to create this column. We can select the linked columns from the current view such as Street Address, City, State, Postal Code, and so on. Suppose, we want to display the Country or Region and Postal Code then, for this, we have selected the linked columns from the list and click on Save.
sharepoint online custom list examples
  • Employee Job Title: Here, we provide the employees’ job titles using a ‘Single line of text.’
SharePoint Online custom list example
SharePoint Online custom list example
  • Employee Department: Here we have created the ‘choice’ data type column that contains Sales, Marketing, Design, Trading & Conversion, and Brand & Content. Also, we enabled Allow multiple selections so that the user can select multiple departments.
Examples of lists in SharePoint online site

Here we have created a table that contains the name of the column, the internal name of the column, what data type we have used, and what is the default value of the column.

Column NameInternal NameData TypeDefault Value
Employee IDTitleSingle line of textNA
Employee NameEmployeeNameSingle line of textNA
Employee ImageEmployeeImageImageNA
Employee EmailEmployeeEmailSingle line of textNA
Employee Contact NumberEmployeeContactNumberNumberNA
Employee LocationEmployeeLocationLocationNA
Employee Job TitleEmployeeJobTitleSingle lines of textNA
Employee DepartmentEmployeeDepartmentChoiceNA
SharePoint Online Lists Examples

This is how we have created our custom SharePoint list ‘Employee Directory’.

Example-14: Wallpapers List

As per the requirement of our client, we need to store all basic information about the wallpapers which are manufactured by the company, including their ID, Name, Color, Style, Collection, etc. For this we have created a ‘Wallpapers’ custom SharePoint online list and created columns as shown below:

sharepoint 2019 list examples

Let’s see the list of columns and their data types, that we have used in the above SharePoint list as shown below:

  • Wallpaper ID: Here, we have renamed the default ‘Title’ column to Wallpaper ID.
  • Wallpaper Name: We have taken a ‘single line of text’ data type column to store the wallpapers’ names.
  • Wallpaper Color: Here, we have created a ‘choice’ data type column that contains different types of colors for the wallpaper such as black, brown, yellow, green, etc.
  • Wallpaper Collection: Here, we have taken a ‘choice’ data type column that contains different types of wallpaper such as ABRA I&II, Blush Label, Gray Malin, etc.
  • Wallpaper Style: We have taken the ‘choice’ data type column with different types of wallpaper styles like Kid+Baby, Abstract, Animal, Organic, etc.
  • Wallpaper Size: For this, we have taken the ‘choice’ data type column. This will provide different sizes of wallpapers like 2 ft * 10 ft Premium Paper, Sample-Peel & Stick, etc.
  • Wallpaper Quantity Available: Here, we have taken the ‘Number’ data type column to have a record of the wallpaper in stock.
  • Wallpaper Price: For this, we have created the ‘choice’ data type column because the price depends on the material and size of the wallpaper.
  • Wallpaper Is Available: We have created the Yes/No data type column. It shows whether the item is available or not. The default value of this column is Yes if we didn’t select the option it will by default takes the option Yes.
sharepoint 2016 list examples

Here we have created a table that contains the name of the column, the internal name of the column, what data type we used, and what is the default value of the column.

Column NameInternal NameData TypeDefault Value
Wallpaper IDWallpaperIDSingle line of textNA
Wallpaper NameWallpaperName Single line of textNA
Wallpaper ColorWallpaperColorChoiceNA
Wallpaper CollectionWallpaperCollection ChoiceNA
Wallpaper StyleWallpaperStyle ChoiceNA
Wallpaper SizeWallpaperSize ChoiceNA
Wallpaper Quantity AvailableWallpaperQuantityAvailableChoiceNA
Wallpaper PriceWallpaperPrice ChoiceNA
Wallpaper Is AvailableWallpaperIsAvailableYes/NoYes
SharePoint list based on different data types

This is how we have created our custom SharePoint list.

Example-15: Wallmurals List

As per the requirement of our client, we need to store all basic information about Wallmurals which are manufactured by the company, including their ID, Name, Material, Size, etc. For this, we have created a ‘Wallmurals’ custom SharePoint online list and created columns as shown below:

sharepoint online list examples

Let’s see the list of columns and their data types, that we have used in the above SharePoint list as shown below:

  • Wallmural ID: Here, we have renamed the default ‘Title’ column to Wallmural ID.
  • Wallmural Name: We have taken a ‘single line of text’ data type column to store the wall murals’ names.
  • Wallmural Available in 2 Sizes: Here, we have created the ‘Multiple lines of text’ data type column to describe the 2 sizes of wall murals briefly as listed below:
    • 9 ft tall x 10 ft wide – consists of 5 strips of wallpaper, each measuring 2ft wide.
    • 9 ft tall x 6 ft wide – consists of 3 strips of wallpaper, each measuring 2ft wide.
  • Wallmural Material: We have created the ‘choice‘ data type column for materials such as Peel & Stick or Premium Paper so that users can select according to their needs.
  • Wallmural Size: For this, we have created the ‘choice’ data type column. This will provide different sizes of wall murals. (i.e 6 ft wide and 10 ft wide).
  • Wallmural Quantity Available: Here, we have created the ‘Number’ data type column to have a record of the wall murals available in stock.
  • Wallmural Price: For this, we have created the ‘choice’ data type column because the price depends on the material and size of the wall mural.
  • Wallpaper Is Available: We have taken the Yes/No data type column. It shows whether the item is available or not. The default value of this column is Yes if we didn’t select the option it will by default takes the option Yes.
Column NameInternal NameData TypeDefault Value
Wallmural IDWallmuralIDSingle line of textNA
Wallmural NameWallmuralNameSingle line of textNA
Wallmural Available in 2 SizesWallmuralAvailablein2SizesMultiple lines of textNA
Wallmural MaterialWallmuralMaterialChoiceNA
Wallmural SizeWallmuralSizeChoiceNA
Wallmural Quantity AvailableWallmuralQuantityAvailableChoiceNA
Wallmural PriceWallmuralPriceChoiceNA
Wallpaper Is AvailableWallpaperIsAvailable Yes/NoYes
SharePoint list based on a different column

This is how we have created our custom SharePoint list ‘Wall murals’.

Example-16: Floormats List

As per the requirement, we need to store all basic information about the floormats that are manufactured by the company, including their ID, Name, Price, Color, etc. For this, we have created a ‘Floormats’ custom SharePoint online list and created columns as shown below:

sharepoint online list examples

Let’s see the list of columns and their data types, that we have used in the above SharePoint list as shown below:

  • Floormat ID: Here, we have renamed the default ‘Title’ column to Floormat ID.
  • Floormat Name: We have taken a ‘single line of text’ data type column to store the wallpapers’ names.
  • Floormat Size: For this, we have taken the ‘choice’ data type column. This will provide different sizes of Floormats such as 20in.*30in. , 3ft * 7ft, 4ft * 6ft, etc.
  • Floormat Color: Here, we have taken a ‘choice’ data type column that contains different types of colors for the floormat such as BlueGreen, YellowGreen, Royal, Moon, etc.
  • Floormat Price: We have created the ‘choice’ data type column because the price of a floormat depends on its color, material, and size.
  • Floormat Quantity Available: Here, we have created the ‘Number’ data type column to have a record of the floormats in stock.
  • Floormat Is Available: We have taken the Yes/No data type column. It shows whether the item is available or not. The default value of this column is Yes which means if we didn’t select the option it will by default takes the option Yes.

Here we have created a table that contains the name of the column, the internal name of the column, what data type we used, and what is the default value of the column.

Column NameInternal NameData TypeDefault Value
Floormat IDTitleSingle line of textNA
Floormat NameFloormatNameSingle line of textNA
Floormat SizeFloormatSizeChoiceNA
Floormat Color FloormatColorChoiceNA
Floormat PriceFloormatPriceChoiceNA
Floormat Quantity AvailableFloormatQuantityAvailableChoiceNA
Floormat Is AvailableFloormatIsAvailableYes/NoYes
SharePoint Online list based on a different column

This is how we have created our custom SharePoint list ‘Floormats’.

Conclusion

I hope you can follow these SharePoint list examples. We have also mentioned all the columns and the data types in SharePoint lists.

You may also like the following tutorials: