SharePoint Online List Examples [15 Real Examples]

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

SharePoint Online List Examples

Here are the examples of SharePoint lists that we have created on our SharePoint Online team site. All these lists, you can also create 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: Semiconductor Clients list

We have created this list for RENA technologies, a company based out in the United States of America.

Based on the business scenario, the client wanted to store the Semiconductor clients list in SharePoint Online. They wanted to store information like 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 online list examples
Example of SharePoint list containing different columns

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

Now we are Describing each one of the Column lists:

  • Title: By default, the Title column will be created while creating the list. Based on our requirement, we can rename the Title column. So we rename this column to 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
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 -> https://www.amperescientific.com
SharePoint online list example
SharePoint list example
  • Client Address: This 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 as Street Address, City, State, Country or Region, Postal Code, Coordinates, Name, etc
SharePoint Online custom list examples
SharePoint Online custom list examples
  • 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
list in SharePoint example
list in SharePoint example
  • 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.
Example of SharePoint custom list
Example of SharePoint custom list

Here, we create the table which contains information like Column Display Name, Column Internal Name, Data Type, and its 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
Column Name and Column Types with Default values

This is what the SharePoint Custom Semiconductor Clients list looks like.

Example-2: Semiconductor Products list

We have created this list for RENA Technologies, a company based out in the United States of America.

Based on the business scenario, the client wanted to store the Semiconductor products list in SharePoint Online. They wanted to store information like Product ID, Product Name, Product Description, and whether it is available or not, etc. For that we have created a custom SharePoint list and created columns like the below:

SharePoint list example containing different columns
SharePoint list example containing different columns

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

Now we are Describing each one of the Column lists:

  • Title: Here, 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 Multiple lines of text type column in which we have saved the purpose of the product as a 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 custom list example of Currency type
SharePoint custom list example of Currency type
  • 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 which contains information like Column Display Name, Column Internal Name, Data Type, and its 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
Column Name and Column Types with Default values

This is what the SharePoint Custom Semiconductor Products list looks like.

Example-3: Semiconductor Transaction Details list

Similarly, we have created this list for RENA technologies, a company based out in the United States of America.

Based on the business scenario, the client wanted to store the Semiconductor Transaction Details in the SharePoint Online list. They wanted to store information like Transaction ID, Product ID, Supplied Product, Product Supplied Date, Product Cost, the product delivery person, and whether it is paid or not, etc

As per the above examples of the SharePoint list, (i.e, Semiconductor Clients list and Semiconductor Products list), now we are going to create a SharePoint list based on Semiconductor Transaction Details. Where an individual company (Client) purchases a product. Where we retrieve information from one list to another by linking with the Semiconductor Clients list and the Semiconductor Products list.

We will create Semiconductor Transaction Details by using the Lookup column. For that we have created a custom SharePoint list and created columns like the below:

Example of SharePoint list
Example of SharePoint list

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

Now we are Describing each one of the Column lists:

  • Title: Here, 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
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. Based on our requirement, we can also rename this column to the Supplied Product.
  • 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
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.
Example of SharePoint Online list
Example of SharePoint Online list
  • 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
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
Example of SharePoint custom list containing 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 which contains information like Column Display Name, Column Internal Name, Data Type, and its 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

This is what the SharePoint Custom Semiconductor Transaction Details list looks like.

Example-4: Semiconductor Issue Tracker

Here, we have also created this list for RENA technologies, a company based out in the United States of America.

Based on the business scenario, the client wanted to store the Semiconductor Issue Tracker Details in the SharePoint Online list. They wanted to store information like Issue ID, Issue, Issue Description, Issue Status, the Issue Assigned person, and whether it is still active or not, etc. For that we have created a custom SharePoint list and created columns like the below:

sharepoint custom list examples
Example of SharePoint list containing different columns

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

Now we are Describing each one of the Column lists:

  • Issue ID: Here, 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 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 we have saved the information of the Issue Status, that the issue is In Progress, Completed, or won’t Fix. We gave the choices as In Progress, Completed, and won’t Fix. Where the user can select the choice as per their requirement.
  • 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 them from the local system.
sharepoint custom list examples
SharePoint custom list example containing different columns
  • 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 which contains information like Column Display Name, Column Internal Name, Data Type, and its 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
Column Name and Column Types with Default values

This is what the SharePoint Custom Semiconductor Issue Tracker list looks like.

Example-5: Doctors List

We have created this list for Mercy Hospitals, a company based out in the United States of America.

According to the requirements from the client, we wanted to create Doctor related information in a SharePoint Online list. They wanted to store information like Doctor ID, Doctor Name, Contact number, Address, Education, etc. For this we have created a custom SharePoint list and created columns like the below:

  • 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
List Examples of SharePoint Custom List
  • 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
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
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.
Modern SharePoint site List Examples
Modern SharePoint site 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
List examples of SharePoint
  • Education: We have created this as a Single line of text named-‘Education‘ to store the education details of Doctors.
Custom List Examples of SharePoint site
Custom List Examples of SharePoint site
  • 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
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
List Examples of SharePoint Online site
  • Specialty: We have created another Choice column named-‘speciality‘ where we can mention the specialization of Doctors and the choice values are Internal medicine, ENT, Cardiology, Neurology, Oncology, Nephrology, Anesthesia, and Optometry with a display option as a Drop-Down Menu.
sharepoint 2013 list examples
List Columns in a SharePoint Custom list
  • 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
List Examples of SharePoint list
  • 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 Gearicon-List settings-Rating settings).
    • From the Rating settings, where 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
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 List and List Columns of the Mercy Hospitals site.

SharePoint Custom List Example
SharePoint Custom List Example

This is what the Doctor’s list of a Mercy Hospitals site looks like after creating the List.

Example-6: Services List

We have created this list for Mercy Hospitals, a company based out in the United States of America.

According to the requirements from the client, we wanted to create Services provided in the hospital and related information in a SharePoint Online list. They wanted 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
Custom list Examples of SharePoint Team site
  • 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 named-‘ServiceName‘ to store the information of services provided at the hospital.
  • Service Type: Here, we have created a choice column named-‘Service Type, and the chosen values are Test, Treatment, and Service line, Medication, Self-care Practices, Chemotherapy, and Surgery. 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).
  • 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
Look up a column in the SharePoint list of 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.
SharePoint List Examples based on a 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

This is the Overview of the List (Services) and List Columns of the Mercy Hospitals site.

Example-7: Careers List

We have created this list for Mercy Hospitals, a company based out in the United States of America.

According to the requirements from the client, we wanted to create Career opportunities provided in the hospital and related information in a SharePoint Online 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
SharePoint Custom List based on different Columns
  • Job ID: This is the ‘ Title ‘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.
  • Job Role: This is created as a Single line of text named-‘Job Role’ to store the information of JobsRole at the hospital.
  • Job Description: This is created as multiple lines of text named- ‘Job Description ‘to store the information of Job Description Related to the particular Job Role at the hospital. In the multiple lines of text, more than 255 characters are used.
  • Experience Level: We have created a single-line text column named –‘Experience level‘ which is used to store the experience required for the job role’ in the year’s format.
  • Posted Date: We have created a Date and Time column named -‘Posted Date’ Where users can select the date from the date picker as per their requirements.
    • 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: Here, we have created a Date and Time column named Expiry Date Where users can select the date from the date picker as per their requirements.
sharepoint 2019 list examples
Using Different Columns in SharePoint List
  • 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 the following choices like Regular, work from home, and Part-time Where users can select their choices as per their requirements.
  • 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

This is how we created the SharePoint Custom List in the Mercy Hospitals site i.e,(Careers).

Example-8: Patients List

We have created this list for Mercy Hospitals, a company based out in the United States of America.

According to the requirements from the client, we wanted to create a patient list provided in the hospital and related information in a SharePoint Online 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
Examples of Custom list
  • Patient ID: This is the ‘ Title ‘Default Column in the List. Here we rename this to ‘PatientID‘where the Data type is automatically taken as a Single line of text as per our requirement.
  • 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, and Transgender Where users can select their choices as per their requirements.
  • 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-, where users can select their choices as per their requirements.
  • Disease Type: This also in the same way, we have created a Choice column named Disease Type having the following choices Heart Disease, Eye Disease type, Injury and wound care, Endocrine disorder, Cancer, Respiratory, and Pediatric, where users can select their choices as per their requirements.
  • 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, also we 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 how we created the SharePoint Custom List in the Mercy Hospitals site i.e, (Patients list).

Example-9: Furniture Types List

We have created this list for Dutch Crafters, a company based out in the United States of America.

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
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.
Examples of SharePoint Modern list
Examples of SharePoint Modern list
  • Features: We have created a multiple-line of text column to store the furniture’s features.
Example of SharePoint modern list
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
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
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
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
List examples of SharePoint Online
  • 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
Custom list examples of SharePoint Online
  • Image: To provide, furniture images, we can create a column of Image datatype. So that when a user inserts an image while adding the furniture they can either provide an URL or can also upload it from their desktop.
sharepoint online custom list examples
Modern SharePoint 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
List examples of SharePoint custom site

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 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 the SharePoint custom list(Furniture Types).

Example-10: Customer Details List

We have created this list for Dutch Crafters, a company based out in the United States of America.

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
Custom list of SharePoint Online site

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
Custom List example of SharePoint modern site

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

We have created this list for Dutch Crafters, a company based out in the United States of America.

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
Custom List examples of SharePoint Online Site

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
Use different columns in SharePoint List
  • 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
SharePoint list based on different columns
  • 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
Use different types of columns in the SharePoint modern list

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(Order Forms).

Example-12: Company Details List

We have created this list for Dutch Crafters, a company based out in the United States of America.

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(Company Details)

Example-13: Employee Directory List 

We have created this list for the “Mitchell Black” Custom Made Modern Wall & Floor Decor textile manufacturing company located in the United States of America.

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
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
Example of SharePoint 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
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
Custom list example of SharePoint
  • 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
SharePoint Online lists 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
Examples of custom list in SharePoint Online
  • Employee Job Title: Here, we provide job titles to the employees and for that, we have used 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
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

We have created this list for the “Mitchell Black” Custom Made Modern Wall & Floor Decor textile manufacturing company located in the United States of America.

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
SharePoint Wallpaper Custom List Example

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
Custom list example of 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 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 ‘Wallpapers’.

Example-15: Wallmurals List

We have created this list for the “Mitchell Black” Custom Made Modern Wall & Floor Decor textile manufacturing company located in the United States of America.

As per the requirement of our client, we need to store all basic information about the wall murals 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
SharePoint Online Wallmurals Custom 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 what are 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 the material such as Peel & Stick or Premium Paper, so that, users can select as per 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

We have created this list for the “Mitchell Black” Custom Made Modern Wall & Floor Decor textile manufacturing company located in the United States of America.

As per the requirement, we need to store all basic information about the floormats which 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
SharePoint custom list based on a different column

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: For this, we have created the ‘choice’ data type column because the price of a floormat depends on the 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’.

In this SharePoint online tutorial, I have explained 16 lists that we have created for various companies like Mitchell Black, Dutch Crafters, Mercy Hospitals, and RENA technologies based out in the United States of America. Below are examples of SharePoint Online lists.

  1. Semiconductor Clients list
  2. Semiconductor Products list
  3. Semiconductor Transaction details list
  4. Semiconductor Issue Tracker list
  5. Doctors List
  6. Careers List
  7. Patients List
  8. Services List
  9. Furniture Types List
  10. Customer Details List
  11. Order Forms List
  12. Company Details List
  13. Employee Directory List
  14. Wallpapers List
  15. Wallmurals List
  16. Floormats List