SharePoint Online List [Complete tutorial]

In this SharePoint tutorial, we will learn what is a SharePoint Online list? How to create and use a list in SharePoint Online. I will also show you, how to add columns to a SharePoint Online list.

We will also check how to insert, update and delete SharePoint list items. We will cover the below topics:

  • What is a list in SharePoint Online?
  • How to create a SharePoint Online list
  • Create a SharePoint list from a Blank list
  • Create a SharePoint list from Excel
  • Create a SharePoint list from an existing list
  • Create a SharePoint list from a Template
  • How to Rename SharePoint Online List title
  • How to update SharePoint Online list description
  • Add a column to a SharePoint Online list
  • SharePoint Online List Column limit
  • Rename SharePoint Online List Title column
  • How to Change SharePoint Online list column width
  • How to favorite a SharePoint Online list
  • How to insert an item into the SharePoint Online list
  • How to Update an item in the SharePoint Online List
  • How to delete an item from the SharePoint Online list
  • How to delete multiple items in the SharePoint Online list
  • Attach a document to a SharePoint Online list
  • SharePoint Online list attachments size limit
  • SharePoint Online List Templates
  • Show/Hide Columns in a Modern SharePoint Online List
  • How to delete a column from a SharePoint online list
  • SharePoint online list Remove Title Column
  • How to create an index column in SharePoint online list
  • SharePoint Online List id
  • Export SharePoint online list to excel
  • SharePoint online lists Multiple lines of the text character limit
  • SharePoint Online list item comments
  • SharePoint online list column names escape codes
  • How to create an attachment column in SharePoint online list
  • Add Folders in SharePoint online list
  • SharePoint online list hide folders
  • Display attachment name in SharePoint online list
  • How to enable the geolocation field in the SharePoint online list

Table of Contents

What is a list in SharePoint Online?

  • SharePoint Online list a Collection of information or data, it is used to store information like the first name, last name, email address, etc., We can also add attachments to the SharePoint list.
  • We can Share the SharePoint list with the team or an organization or with the users who you have given access.
  • Once the SharePoint Online List is created, we can add columns to the list, and also we can filter and sort the list information.

For example, If we are creating an employee list, then we can store the employee attributes like employee name, employee id, employee join date, employee role, etc.,

Read SharePoint Online List Web Part

How to create a SharePoint Online list

Let us see how to create a SharePoint Online list, and what are the ways that we can create a SharePoint Online list.

There are four ways that we can create a SharePoint list, they are

  1. To create a SharePoint list from a Blank list.
  2. To create a SharePoint list from Excel.
  3. To create a SharePoint list from an existing list.
  4. To create a SharePoint list from a Template.

Create a SharePoint list from a Blank list

Now let us see how can we create a SharePoint list from a Blank list,

  • Open the Modern SharePoint Home page, Select +New and click on the List.
Create a SharePoint list from a Blank list
Create a SharePoint list from a Blank list
  • Select + Blank list to create a list from scratch.
Create a SharePoint list from Blank list
Create a SharePoint list from a Blank list
  • Now add a SharePoint list Name which is required and also add a Description of the list which is optional, if you want to show the list in the SharePoint site Navigation, select the Show in Site Navigation check box.
  • Select Create, and the SharePoint list will be created.
create a SharePoint list from a Blank list
create a SharePoint list from a Blank list

The below screenshot represents the newly created list from a Blank list.

create a SharePoint online list from a Blank list
create a SharePoint online list from a Blank list

This is how to create a SharePoint Online list from a Blank list.

Read Power Automate Create SharePoint List

Create a SharePoint list from Excel

Now let us see how to create a SharePoint list from Excel,

  • Open the Modern SharePoint Home page, Select + New, and click on the List.
create a SharePoint list from Excel
create a SharePoint list from Excel
  • Select From Excel option.
create a SharePoint list from an excel
create a SharePoint list from an excel
  • There are two options that we can select an excel file, Either we can upload the excel file from the local system or we can select the excel file available on the current SharePoint site.
  • To Upload an excel file from the local system, select the Upload file option, else choose the existing excel file presented on the current site.
  • Click Next.
create SharePoint list from excel
create a SharePoint list from excel
  • To import an excel file as a list, make sure that you have created an excel file in the Table format with the columns. If not add a table in the excel file.
  • If the excel file is not in the table format then we can see, that the Next button is disabled.
create the SharePoint list from excel
create the SharePoint list from excel
  • Once you changed the excel file to the Table format, you can see that the Next button is enabled. Now click on the Next button.
create the SharePoint list from an excel
create the SharePoint list from excel
  • Now add a SharePoint list Name which is required we can also rename the List Name as per our requirement.
  • Add a Description of the list which is optional, if you want to show the list in the SharePoint site Navigation, select the Show in Site Navigation check box.
  • Select Create, and the SharePoint list will be created.
create the SharePoint online list from an excel
create the SharePoint online list from an excel

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

create a SharePoint online list from an excel
create a SharePoint online list from excel

This is how we can create a SharePoint list from Excel.

Read Power Automate export SharePoint list to excel and send an email

Create a SharePoint list from an existing list

Now let us see how can we create a SharePoint list from an existing list,

  • Open the Modern SharePoint Home page, Select +New and click on the List.
create a SharePoint list from an existing list
create a SharePoint list from an existing list
  • Select From an existing list option.
create a SharePoint list from an existing lists
create a SharePoint list from an existing lists
  • Now select an existing list from the Team or the Site to use the template for the new list. It will copy only the columns and views from the existing list to the newly created list. It will not copy the column items to the new list. Click on the next.
To create a SharePoint list from an existing list
To create a SharePoint list from an existing list
  • Now add a SharePoint list Name which is required we can also rename the List Name as per our requirement.
  • Add a Description of the list which is optional, if you want to show the list in the SharePoint site Navigation, select the Show in Site Navigation check box.
  • Select Create, and the SharePoint list will be created.
To create a SharePoint list from an existing lists
To create a SharePoint list from an existing list

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

create a SharePoint online list from an existing lists
create a SharePoint online list from an existing lists

This is how we can create a SharePoint list from an existing list.

Read Power Automate delete all items in SharePoint list

Create a SharePoint list from a Template

Now let us see how can we create a SharePoint list from a Blank list,

  • Open the Modern SharePoint Home page, Select +New and click on the List.
To create a SharePoint list from a Template
To create a SharePoint list from a Template
  • Under Templates choose the template list option that you want to use. In this example, I am going to use the Employee onboarding template list.
create a SharePoint list from a Template
create a SharePoint list from a Template
  • Once you selected the SharePoint template list, click on the Use Template button.
To create a SharePoint list from Templates
To create a SharePoint list from Templates
  • Now add a SharePoint list Name which is required we can also rename the List Name as per our requirement.
  • Add a Description of the list which is optional, if you want to show the list in the SharePoint site Navigation, select the Show in Site Navigation check box.
  • Select Create, and the SharePoint list will be created.
To create a SharePoint list from a Templates
To create a SharePoint list from a Templates

The below picture represents the newly created list from Templates.

create a SharePoint online list from a Templates
create a SharePoint online list from a Templates

This is how we can create a SharePoint list from a Template.

These are the four ways that we can create a modern SharePoint Online list.

Read Convert SharePoint list item to PDF using Flow or Power Automate

How to Rename SharePoint Online List title

Let us see how we can rename the SharePoint Online List title and what are the ways we can rename the SharePoint Online List title,

There are two ways that we can rename the SharePoint online list title, they are

  1. By Clicking on the List title
  2. Through List settings

By Clicking on the List title

  • Open the SharePoint Online list and click on the List Header.
  • A Popup appears to rename the List title, Rename it and Click on the Save button.

In this example, I am going to rename the EmployeeList title to EmployeeListDetails.

Rename the SharePoint Online List title
Rename the SharePoint Online List title
  • Click on the EmployeeList, change the list title name that you want to display as shown below, and click on the Save button.
Rename SharePoint Online List title
Rename SharePoint Online List title

In the below screenshot, you can see that the SharePoint Online list title is renamed as EmployeeListDetails.

Rename a SharePoint Online List title
Rename a SharePoint Online List title

This is the one way that we can rename the SharePoint Online list title.

Through List settings

  • In this example, I am going to rename the SharePoint Online Web Parts title to Modern SharePoint Web Parts
Rename SharePoint Online List title example
Rename SharePoint Online List title example
  • Open the SharePoint Online list and click on the Settings Gear Icon and select the List Settings.
SharePoint Online Rename the List title
SharePoint Online Rename the List title
  • Under General settings, click on the List name, description, and navigation option.
SharePoint Online Rename a List title
SharePoint Online Rename a List title
  • In the Name field, change the list title name that you want to display as shown below, and click on the Save button.
SharePoint Online Rename a List title example
SharePoint Online Rename a List title example

In the below screenshot, you can see that the SharePoint Online list title is renamed like Modern SharePoint Web Parts.

SharePoint Online Rename the List title example
SharePoint Online Rename the List title example

This is another way that we can rename the SharePoint Online list title.

These are the two ways that we can rename the SharePoint online list title.

Read Power Automate update SharePoint list increment integer field

How to update SharePoint Online list description

Let us discuss how to view and update the SharePoint Online list description,

We know the description field is optional while creating the SharePoint online list. But later it is possible to newly add the description for the list or we can update the previously added list description.

In this example, I am going to update the TaskList description (below screenshot highlighted in Red).

update SharePoint Online list description
update SharePoint Online list description

Follow the below steps to update the SharePoint online list description:

  • Open the SharePoint Online list that you want to add or update the list description and click on the Settings Gear Icon and select the List Settings.
how to update SharePoint Online list description
how to update SharePoint Online list description
  • Under General settings, click on the List name, description, and navigation option.
SharePoint Online update list description
SharePoint Online update list description

In the Description field, we can newly add the description of the list that we want to display, or else we can update the previously added list description, and click on the Save button to commit your changes.

SharePoint Online update list description example
SharePoint Online update list description example

In the below screenshot, we can the SharePoint Online list description is updated.

Example to update SharePoint Online list description
Example to update SharePoint Online list description

This is how we can view and update the SharePoint Online list description.

Read How to Customize SharePoint Modern list form using JSON

Add a column to a SharePoint Online list

Let us see how we can add and edit a column to a SharePoint Online list,

In the SharePoint list column, we can choose the data type of the column that we want. For example, if we want to add two or more options in the column then we can select the Choice as the column type.

Below mentioned are the available Column data types:

  • A single line of text
  • Multiple lines of text
  • Yes/No
  • Person/Group
  • Choice
  • Hyperlink
  • Location
  • Date and time
  • Lookup
  • Currency
  • Image

Follow the below steps to add a column to a SharePoint Online list

  • Open the SharePoint Online list, where you want to add a column. In this example, I am going to add a column to the Employee List.
  • Now Select the +Add column and choose the data type of the column.
add a column to a SharePoint list
add a column to a SharePoint list

In the below screenshot, you can see that I have created a column with the choice column type.

  • Enter the column name in the Name field which is required. The description field is optional.
  • We can add the choices based on our requirements, by default it displays 3 Choices, if we want to add many choices we can add them by selecting the +Add Choice option.
add a column to SharePoint list
add a column to the SharePoint list
  • We can also set the default value for the column, by enabling the More options we can choose the display choices.
  • There are two ways that we can display the choices, the one way we can display them is by using the Dropdown menu and the other way is using the Radio buttons we can display the choices.
  • By default, it will be displaying the choices using the dropdown menu.
  • Click on the Save button to add a column to the SharePoint list.
add a column to the SharePoint list
add a column to the SharePoint list

In the below screenshot, you can see that the EmployeerRole column is added to the SharePoint Online list.

added a column to the SharePoint list
added a column to the SharePoint list

Now select the item and click on the I circled icon to choose the EmployeerRole for the Employees.

added a column to a SharePoint list
added a column to a SharePoint list

In the below screenshot, you can see a new column is added to a SharePoint list.

added a column to a SharePoint list example
added a column to a SharePoint list example

Once the column is added we can edit the column by selecting the Column settings.

edit the column by selecting the Column settings in modern SharePoint
edit the column by selecting the Column settings in modern SharePoint

This is how we can add and edit a column to a SharePoint Online list.

Read Power Automate create an HTML table from SharePoint List

How to make the field required in SharePoint online list

Let us see how can we make the field required in the SharePoint Online list,

  • Open the SharePoint Online list and select the settings gear icon and click on the List settings as shown below:
How to make the field required in SharePoint online list
How to make the field required in SharePoint online list

In this example, I am going to change the Task Description field as a required field. When we try to add a new item to the SharePoint Online list. In the below screenshot, we can see that the Task Description field is not in the required field.

How to make the field required in the SharePoint online list
How to make the field required in the SharePoint online list
  • In the list setting page, under columns select the field name that you want to change as a required field. Here, I am going to choose the Task Description field.
make the field required in the SharePoint online list
make the field required in the SharePoint online list

In the Edit column settings, Select Yes in the Require that this column contains information, scroll down and click on the Ok button to save your changes

make the field required in the SharePoint online list example
make the field required in the SharePoint online list example

Now if you navigate to the SharePoint list, you can see that the Task Description field has changed as a required field.

make the field required in SharePoint online list example
make the field required in SharePoint online list example

In the below screenshot, you can see the asterisk symbol in the Task Description field which defines the required field item.

How to make the field required in SharePoint online list example
How to make the field required in SharePoint online list example

This is how we can make the field required in the SharePoint Online list.

SharePoint Online List Column limit

The below-mentioned table represents the SharePoint Server 2013 column limits,

The total count of all columns in a SharePoint list cannot surpass 8000 bytes. Each and every column has a size value detailed in bytes.

LimitMaximum ColumnsSize per column
A single line of text 25530 bytes
Multiple lines of text35022 bytes
Yes/No10007 bytes
Person/Group75010 bytes
Choice25530 bytes
Date and time55014 bytes
Lookup75010 bytes
SharePoint Online List Column limit

Rename SharePoint Online List Title column

Let us see how to rename the SharePoint Online list title column and will also see what are the ways that we can rename the SharePoint online list title column,

There are two ways that we can rename the SharePoint Online list column, they are,

  1. By Clicking on the List title column
  2. Through List settings

By Clicking on the List title column

  • Open the SharePoint Online list and select the title column dropdown.
  • Now click on the Column settings and select the Rename option.

In this example, I going to rename the TaskList list title column to Employee Name in the SharePoint Online TaskList.

Rename SharePoint Online List Title column
Rename SharePoint Online List Title column
  • A Popup appears to rename the list title column, Rename it and Click on the Save button.
SharePoint Online Rename List Title column
SharePoint Online Rename List Title column

In the below screenshot, you can see that the list title column is renamed as Employees Name.

SharePoint Online Rename List Title column example
SharePoint Online Rename List Title column example

This is the one way that we can rename the SharePoint Online list title column.

Through List settings

  • In this example, I going to rename the EmployeeListDetails list title column to Employee Name in the SharePoint Online TaskList.
  • Open the SharePoint Online list and click on the Settings Gear Icon and select the List Settings.
SharePoint Online Rename a List Title column
SharePoint Online Rename a List Title column
  • Under Columns, Select the Title option.
SharePoint Online Rename the List Title column
SharePoint Online Rename the List Title column

In the Column name field, change the list title column name that you want to display as shown below, and scroll down and select the Ok button to save your changes.

how to rename SharePoint Online List Title column
how to rename the SharePoint Online List Title column

In the below screenshot, you can see that the list title column is renamed as Employees Name.

rename the SharePoint Online List Title column
rename the SharePoint Online List Title column

This is another way that we can rename the SharePoint Online list title column.

These are the two ways that we can rename the SharePoint online list title column.

Read Power Automate update SharePoint list item

How to Change SharePoint Online list column width

Let us see how we can change or increase the SharePoint Online list column width,

We can increase or change the column width of the list. To achieve this, follow the below steps:

  • Select Site contents from the SharePoint page, and select the SharePoint Online list that you want to change or increase the column width.
  • Expand the column width, using the mouse, the list view will be saved automatically.
Change SharePoint Online list column width
Change SharePoint Online list column width

This is how we can change or increase the SharePoint Online list column width.

How to favorite a SharePoint Online list

Let us see how we can add, remove and view a SharePoint Online List to favorites,

Add SharePoint online lists to Favorites

  • To add a SharePoint list to favorites, Initially Open the SharePoint Online list and Select the Star icon presented next to the SharePoint online list title.
  • Once you selected it, it automatically adds the SharePoint list to the favorites.
Add SharePoint online lists to Favorites
Add SharePoint online lists to Favorites

This is how to add a SharePoint Online list to favorites.

Remove SharePoint online lists from Favorites

  • To remove a SharePoint list to favorites, Open the SharePoint Online list and Select the Star icon presented next to the SharePoint online list title.
  • Once you selected it, it automatically removes the SharePoint list from the favorites.
remove SharePoint online lists from Favorites
remove SharePoint online lists from Favorites

This is how to remove a SharePoint Online list from favorites.

View the Favorites SharePoint online lists

  • To view the favorites SharePoint online lists, initially log in to Microsoft Office365 using your SharePoint credentials -> Select Office365 App Launcher and then click on the Lists.
view Favorites SharePoint online lists
view Favorites SharePoint online lists

Under Favorites, we can view the SharePoint online list which is added as favorites as shown below:

view Favorites SharePoint online lists example
view Favorites SharePoint online lists example

This is how we can view the SharePoint online list which is added as favorites.

This is how we can add, remove and view the SharePoint Online List to favorites.

Read How to customize a SharePoint List form

How to insert an item into the SharePoint Online list

Let us see how we can insert an item into the SharePoint Online list,

  • Open the SharePoint list, Where you want to insert an item, and Select the +New option.
insert an item into the SharePoint Online list
insert an item into the SharePoint Online list

A New item screen appears to insert an item, enter the values and then Click on the Save button. The New item will be inserted into the SharePoint Online list.

insert an item in the SharePoint Online list
insert an item in the SharePoint Online list

In the below screenshot you can see the newly created item is inserted into the SharePoint Online list.

insert an item in SharePoint Online list
insert an item in the SharePoint Online list

This is how we can insert an item into the SharePoint Online list.

How to Update an item in the SharePoint Online List

Let us see how we can Update an item into the SharePoint Online list,

There are two ways that we can edit and update an item in the SharePoint Online list, they are

  1. By selecting the Edit option
  2. By selecting i circled option

By Selecting the Edit option

  • Open the SharePoint Online list and select the item that you want to Update.
  • Now click on the Edit option Presented in the toolbar.

In this example, I am going to update an EmployeerRole from PowerApps Developer to the Python Developer for the employee called Shivam Dorga.

update an item in SharePoint Online list
update an item in the SharePoint Online list

Now select an item and click on the Edit option as shown below:

update an item in the SharePoint Online list
update an item in the SharePoint Online list

Edit the value that you want to update and click on the Save button to save the changes.

update an item into the SharePoint Online list
update an item into the SharePoint Online list

In the below screenshot you can see the selected item is updated and reflected in the SharePoint Online list.

update an item to the SharePoint Online list
update an item to the SharePoint Online list

This is one way that we can update an item in the SharePoint online list

By selecting i circled the option

  • Open the SharePoint Online list and select the item that you want to Update.
  • Now click on the I circled option, in the properties pane we can edit the value that we want to update, it automatically updates the edited value.

In this example, I am going to update an EmployeerRole from Python Developer to the SharePoint Developer for the employee called Sonam.

update a item to the SharePoint Online list
update an item to the SharePoint Online list
  • Now select the item and click on the I circled option.
  • In the properties pane, edit the value that you want to update, it automatically updates the edited value.
SharePoint Online list update an item
SharePoint Online list updates an item

In the below screenshot, you can see that the selected item is updated and reflected in the SharePoint Online list.

updates an item in SharePoint Online list
updates an item in the SharePoint Online list

This is another way that we can update an item into the SharePoint Online list.

These are the two ways that we can update an item into the SharePoint Online list.

How to delete an item from the SharePoint Online list

Let us see how we can delete an item from the SharePoint Online list,

There are two ways that we can delete an item from the SharePoint Online list, they are

  1. By selecting the Delete option
  2. By selecting the Vertical ellipsis option

By selecting the Delete option

  • Open the SharePoint Online list and select the item that you want to delete.
  • Now click on the Delete option Presented in the toolbar.
delete an item from SharePoint Online list
delete an item from the SharePoint Online list

In the Confirmation box, Select Delete to remove or delete an item from the list.

delete an item from the SharePoint Online list
delete an item from the SharePoint Online list

In the below screenshot, you can see the selected item is deleted from the SharePoint Online list.

delete an item from a SharePoint Online list
delete an item from a SharePoint Online list

This is one way that we can delete an item from the SharePoint online list

By selecting the Vertical ellipsis option

  • Go to the SharePoint Online list and select the item that you want to delete.
  • Now click on the Vertical ellipsis option and Select Delete.
delete a item from the SharePoint Online list
delete an item from the SharePoint Online list

In the Confirmation box, Select Delete to remove or delete an item from the list.

delete the item from SharePoint Online list
delete the item from the SharePoint Online list

In the below screenshot, you can see the selected item is deleted from the SharePoint Online list.

SharePoint Online list delete an item
SharePoint Online list delete an item

This is another way that we can delete an item from the SharePoint Online list.

These are the two ways that we can delete an item from the SharePoint Online list.

Read How to delete all items from SharePoint list

How to delete multiple items in the SharePoint Online list

Let us see how we can delete multiple items from the SharePoint Online list,

There are two ways that we can delete multiple items from the SharePoint Online list, they are

  1. By selecting the Delete option
  2. By selecting the Vertical ellipsis option

By selecting the Delete option

  • Open the SharePoint Online list and select the items that you want to remove from the list.
  • Now click on the Delete option Presented in the toolbar, we can also able to view the selected items count on the toolbar.
delete multiple items from SharePoint Online list
delete multiple items from the SharePoint Online list

In the Confirmation box, Select Delete to remove or delete an item from the list.

delete multiple items from the SharePoint Online list
delete multiple items from the SharePoint Online list

In the below screenshot, you can see the selected items are deleted from the SharePoint Online list.

SharePoint Online list delete multiple items
SharePoint Online list delete multiple items

This is one way that we can delete multiple items from the SharePoint online list

By selecting the Vertical ellipsis option

  • Go to the SharePoint Online list and select the items that you want to delete or remove from the list.
  • Now click on the Vertical ellipsis option and Select Delete.
delete multiple items from a SharePoint Online list
delete multiple items from a SharePoint Online list
  • In the Confirmation box, Select Delete to remove or delete an item from the list.
delete multiple items from the SharePoint list
delete multiple items from the SharePoint list

In the below screenshot, you can see the selected item is deleted from the SharePoint Online list.

SharePoint list delete multiple items
SharePoint list delete multiple items

This is another way that we can delete multiple items from the SharePoint Online list.

These are the two ways that we can delete multiple items from the SharePoint Online list.

Read SharePoint Online image column

Attach a document to a SharePoint Online list

Let us see how we can attach a document to the SharePoint Online list,

  • Open the SharePoint Online list and select the item for which you want to add an attachment file.
  • Now click on the Edit option Presented in the toolbar.
attach a document to the SharePoint Online list
attach a document to the SharePoint Online list
  • Select the Add attachments option where we can add one or more attachments. We can also remove the attachments by selecting the X icon.
  • Click on the Save button to commit your changes.
attach a document into the SharePoint Online list
attach a document to the SharePoint Online list

Once the file is attached you can see the attachment symbol under the Attachments column as shown below:

attach a document in the SharePoint Online list
attach a document to the SharePoint Online list

This is how we can attach a document to the SharePoint Online list.

SharePoint Online list attachments size limit

  • The maximum size limit for the files attached to the SharePoint Online list or the Microsoft list is 250 MB.
  • The maximum size limit for the files uploaded to the SharePoint Online document library or the Microsoft team’s file tab or one drive folders is 250 GB.
  • The File path filename cannot include more than 400 characters for one drive and SharePoint.
  • A SharePoint list can have a maximum of 30 million items, and a SharePoint document library can have a maximum of 30 million files and folders.

SharePoint Online List Templates

Let us discuss what is list templates and why we use the list templates in the SharePoint Online list templates,

  • SharePoint Online list templates help to use the predefined or pre-configured list layouts which include columns and the structure of the data.
  • We can customize the pre-configured list as per our necessity.
  • We can select any one of the list templates to create a new list from the templates as shown below:
SharePoint Online List Templates
SharePoint Online List Templates

In this example, I am going to select and use the Issue Tracker template list which helps to track and manage the issues. In the below screenshot, you can see that I used the issue tracker template and by default, columns are added to the list.

SharePoint Online List Templates examples
SharePoint Online List Templates examples

List Column details

We can also customize the list template columns. The below explains the issue tracker list column details:

List ColumnColumn typeDescription
IssueSingle line text Issue Name.
Issue descriptionMulti-line textIssue Description.
PriorityChoiceTo track the priority of the issues as high, low, and medium.
StatusChoiceTo track the status of the issues as completed, in progress, and not yet started.
Assigned toPersonassigned to the person to track the issue
Data reportedDate and timeDate, when the issue is reported
Issue sourceHyperlinkSource URL where the issues are documented
SharePoint Online List Templates

In the same manner, the remaining SharePoint Online list templates have the list column details, which you can choose based on the requirement and customize the list columns.

This is how we can use and work with the list templates in SharePoint Online.

Show/Hide Columns in a Modern SharePoint Online List

Let us see how we can Show /Hide Columns in the modern SharePoint online list,

Show a Column in the Modern SharePoint

  • Open the SharePoint list, Expand the Column and click on the Column settings, and select the show/hide Columns option.
Show Columns in the Modern SharePoint Online List
Show Columns in the Modern SharePoint Online List
  • Now it will redirect to the edit view columns properties pane.
  • Here we can select or choose the columns that we want to display in the SharePoint Online List view.

In this example, I have selected the ID and Created columns to be shown in the SharePoint online list.

Show Columns in Modern SharePoint Online List
Show Columns in Modern SharePoint Online List
  • We can also reorder the items by easily dragging and dropping columns in the position we want to display, else we can use Move up and Move down the columns using up and down buttons.
  • Select Apply to save your changes, so that they will reflect on your modern SharePoint online list.
Show Columns in a Modern SharePoint Online List
Show Columns in a Modern SharePoint Online List

In the below screenshot, you can see that the ID and Created columns are displayed in the SharePoint Online list.

Show Columns in the SharePoint Online List
Show Columns in the SharePoint Online List

This is how we can Show a Column in the Modern SharePoint online list.

Hide a Column in the Modern SharePoint

  • Open the SharePoint list, Expand the Column and click on the Column settings, and select the show/hide Columns option.
Hide Columns in the Modern SharePoint Online List
Hide Columns in the Modern SharePoint Online List
  • Now it will redirect to the edit view columns properties pane.
  • Now uncheck the columns that you don’t want to display in the SharePoint Online List view.

In this example, I have unchecked the EmployeeCode and Attachments columns to be hidden in the SharePoint online list.

Hide Columns in Modern SharePoint Online List
Hide Columns in Modern SharePoint Online List
  • We can also reorder the items by easily dragging and dropping columns in the position we want to display, else we can use up and down buttons next to each column.
  • Select Apply to save your changes, so that they will reflect on your modern SharePoint online list.
Hide Columns in the SharePoint Online List
Hide Columns in the SharePoint Online List

In the below screenshot, you can see that the employee code and Attachments columns are hidden in the SharePoint Online list.

Hide Columns in a SharePoint Online List
Hide Columns in a SharePoint Online List

This is how we can hide a Column in the Modern SharePoint list.

This is how we can Show / Hide Columns in the modern SharePoint online list.

How to delete a column from a SharePoint online list

Let us see how we can delete a column in the modern SharePoint online list,

  • Open the SharePoint list, Expand the Column that you want to delete or remove from the list and click on the Column settings, and select the Edit option.

In this example, I am going to delete the EmployeeRole column as shown below:

how to delete a column in sharepoint online list
how to delete a column in the SharePoint online list
  • An Edit column window appears, click on the Delete option presented at the bottom.
how to delete a column in the sharepoint online list
how to delete a column in the SharePoint online list
  • In the Confirmation box, select Delete, it will remove or delete the column with data available on that column.
delete a column in the sharepoint online list
delete a column in the SharePoint online list

In the below screenshot, you can see that the EmployeerRole column was deleted.

delete a column in sharepoint online list
delete a column in the SharePoint online list

This is how we can delete a column in the modern SharePoint online list.

SharePoint online list Remove Title Column

Let us see how we can remove the title column from the SharePoint Online list,

  • Once the SharePoint list is created by default the Title Column appears as the Required field as shown below:
SharePoint online list Remove Title Column
SharePoint online list Remove Title Column

In this example, we are going to see how we can remove the required title column from the List. Follow the below steps to achieve this:

Step:1

Open the SharePoint online list, select the settings gear icon and click on the List Settings.

Remove Title Column in SharePoint online list
Remove Title Column in SharePoint online list

Step:2

Select Advanced Settings, under the General Settings on the list settings page.

Remove Title Column in the SharePoint online list
Remove Title Column in the SharePoint online list

Step:3

In the Advanced settings page, enable the Allow management of content types to yes. Scroll to the bottom and click on the Ok button to save the changes.

Remove Title Column in modern SharePoint online list
Remove Title Column in modern SharePoint online list

Step:4

Now you can see, that the Content Types are added to the list settings page, Select Item under the Content-Type.

Remove Title Column in the modern SharePoint online list
Remove Title Column in the modern SharePoint online list

Step:5

In the List Content Type page, under Columns, select the Title presented.

Remove Title Column in the modern SharePoint list
Remove Title Column in the modern SharePoint list

Step:6

  • In the Change Content-Type Column page, in the Column settings, select the Hidden option and Click on the OK button to commit the changes.
  • You can also make the title column optional, for that select the optional option.
Remove Title Column in modern SharePoint list
Remove Title Column in a modern SharePoint list

Step:7

Now Open the SharePoint list, and try to add a new item. You can see that the Required Title Column is disappeared in the SharePoint Online list as below:

Remove Title Column in modern SharePoint list example
Remove Title Column in modern SharePoint list example

This is how we can remove the title column from the SharePoint Online list.

How to create an index column in SharePoint online list

Let us see how we can create an index column in the SharePoint Online list,

  • When we are using a Large SharePoint List we can apply indexing in a column, it adds more privilege when we use filters. And also it supports the List view threshold limits when the 5000 data or items are retrieved from the SharePoint list.
  • We can index to a maximum of 20 columns per list or Library. We cannot index for all types of columns.
  • Automatic index design when sorting in the modern SharePoint is restricted to lists and libraries with shorter than 20,000 items.

The below-mentioned table represents the supported and unsupported column types:

Column Index Supported Column typesColumn Index UnSupported Column types
A single line of textMultiple lines of text
Choice (single value)Choice (multi-valued)
NumberCalculated
CurrencyHyperlink or Picture
Date and TimeCustom Columns
Person or Group (single value)Person or Group (multi-valued)
Managed MetadataExternal data
Yes/No
Lookup
supported and unsupported column types

Follow the below steps to create an index column in SharePoint online list:

  • Open the SharePoint online list, select the settings gear icon and click on the List Settings.
create index column in sharepoint online list
create an index column in SharePoint online list
  • In the list settings page, under columns, Select the Indexed Columns option.
How to create index column in sharepoint online list
How to create an index column in SharePoint online list
  • On the Indexed Columns page, click on the Create a new index option.
create index column in the sharepoint online list
create an index column in the SharePoint online list
  • Now In the Edit index, select the column for which you want to apply the column indexing, and Click on the Create button.
  • In this example, I have selected the EndDate Column to apply column indexing.
create index column in modern sharepoint online list
create index column in modern SharePoint online list

In the below screenshot, you can see that the Column indexing has been applied to the EndDate Column.

create index column in the modern sharepoint online list
create an index column in the modern SharePoint online list

This is how we can create an index column in the modern SharePoint online list.

SharePoint Online List id

Let us see how we can find the List-Id for the Modern SharePoint Online List.

  • Open the SharePoint online list for which you want to find the List id, select the settings gear icon and click on the List Settings.

In this example, I am going to find the List id for the Task List that I have created on my SharePoint site.

sharepoint online list id
SharePoint online list id
  • Copy the URL, you can see some text after List= which defines the List-Id.
  • Now Remove “%7B” from the starting of the List id. And also remove “%7D” from the end of the List id.
  • If %2 is presented in the List id, then replace it with a hyphen.

For this example, List id is 62eb7cf7-6544-4241-a866-a42ebb5ad5b6.

Modern sharepoint online list id
Modern SharePoint online list id

This is how we can find the List-Id for the Modern SharePoint Online List

Export SharePoint online list to excel

Let us see how we can export the SharePoint Online list to excel,

  • Open the SharePoint online list that you want to export, Expand the export option available in the toolbar.
  • Now select to Export to Excel option, and the SharePoint list will be downloaded as the Excel File.
  • Once you open the excel file, you can see the columns and data presented in the list will also be presented in the excel file.

This is how we can export the SharePoint Online list to excel.

SharePoint online lists Multiple lines of the text character limit

  • In the Modern SharePoint, multiple lines of text can store a maximum of 63,999 characters.
  • So we don’t want to enable the option to save more than 255 characters in the SharePoint online list in Multiple lines of text column.
  • We can also assign the specific text that is to be displayed like Plain text or Rich text like Bold, Italics, text alignments, and hyperlinks, and also we can append changes to the existing text.
  • The user needs permission to add or delete list item comments and the editing comments are not available currently.

SharePoint Online list item comments

Let us discuss how we can add, reply and delete the selected list items comments in the SharePoint Online list,

  • Open the SharePoint Online list and select the item for which you like to add a comment.
  • Once the item is selected from the list you can see the Comment icon appears in the toolbar.
  • At a time we can add comments for a single item in the SharePoint list, and we cannot select multiple items to add a comment to the list.
  • If you don’t see the comments option once the item is selected, then the admin would have a disabled commenting section.

Add a Comment

Let us see how we can add a comment for the selected item in the SharePoint online list,

  • Open the SharePoint Online list and select the item for which you want to add a comment.
  • Select the Comment icon that appears in the toolbar, once the item is selected from the list.
add a comment for the selected item in the SharePoint online list
add a comment for the selected item in the SharePoint online list
  • On the right-hand side, the comments pane appears where we can type the comment in the Comment box and Click Enter or select the send icon.
add comments for the selected item in the SharePoint online list
add comments for the selected item in the SharePoint online list

In the below screenshot, you can see that the comment is added as expected.

add comments for the selected item in SharePoint online list
add comments for the selected item in SharePoint online list

This is how we can add a comment for the selected item in the SharePoint online list.

View and Reply to Comments

Let us see how we can view and reply to a comment for the selected item in the SharePoint online list,

  • Open the SharePoint Online list and select the item for which you want to add a reply comment.
  • Select the Comment icon that appears in the toolbar, once the item is selected from the list.
  • In the Comments pane, type the comment that you add as a reply comment in the Comment box and Click Enter or select the send icon.
reply a comment for the selected item in the SharePoint online list
reply with a comment for the selected item in the SharePoint online list
  • To hide or Show the comment pane, select the comments icon that appears at the top of the comments pane.
hide a comment for the selected item in the SharePoint online list
hide a comment for the selected item in the SharePoint online list

This is how we can view and reply to a comment for the selected item in the SharePoint online list.

Delete a Comment

Let us see how we can delete a comment for the selected item in the SharePoint online list,

  • In the comments pane, Select the comment that you want to delete, and click on the delete icon to delete it.
  • We cannot delete multiple comments, at a time we can delete a single comment only.
delete a comment for the selected item in the SharePoint online list
delete a comment for the selected item in the SharePoint online list
  • In the confirmation box, select Delete to remove or delete the comment.
delete a comment for the selected item in SharePoint online list
delete a comment for the selected item in SharePoint online list

In the below screenshot, you can see that the comment is deleted.

delete a comment for the selected item in modern SharePoint list
delete a comment for the selected item in the modern SharePoint list

This is how we can delete a comment for the selected item in the SharePoint online list.

Use @mention in comments to mention someone

Let us see how we can mention the user in a comment for the selected item in the SharePoint online list,

  • In the Comments pane, we can use @ sign to mention someone in the comment. The mentioned user will receive an email notification with a link to the mentioned comment.
  • Mention @ and pick the name that you want to mention in the comment.
SharePoint online list item comments
SharePoint Online list item comments

In this example, I have mentioned the User2 as shown below:

SharePoint online list item comments example
SharePoint Online list item comments example

Once you Send the Comment, a pop-up appears to Grant access to the comment. The mentioned user will receive an email notification with a link to the mentioned comment

Modern SharePoint list item comments example
Modern SharePoint list item comments example

This is how we can mention the user in a comment for the selected item in the SharePoint online list.

This is how we can add, reply and delete the selected list items comments in the SharePoint Online list.

SharePoint online list column names escape codes

When we try to create a new column in the modern SharePoint list, by default we can see two things they are,

  • Column Internal Name
  • Column Display Name

It is possible to change the Column display name and it is not possible to change the column’s internal name.

In a Modern SharePoint list, we don’t need to encode the list column names escape codes, by default it removes the space for the column internal name.

For example, Before creating a column, if we leave spaces in between in the column name, the empty spaces will be encoded as %20 in the column internal name. After the Updation, when we create a column with spaces in the Column name, In a Modern SharePoint list, we don’t need to encode the list column names escape codes, by default it removes the space for the column internal name.

How to create an attachment column in SharePoint online list

Let us see how can we create an attachment column in the modern SharePoint online list,

  • Open the SharePoint list Where you want to add or create an attachment column in the SharePoint Online list.
  • For example, In the below screenshot, you can see that there is no attachment column in the SharePoint online list.
create an attachment column in SharePoint online list
create an attachment column in SharePoint online list
  • Once the SharePoint online list is opened, Expand any one of the columns and click on the column settings, and Select Show/Hide columns option as shown below:
create an attachment column in the SharePoint online list
create an attachment column in the SharePoint online list

In the Edit view columns, Search for Attachments, select the Attachments checkbox, and click on the Apply button to save your changes.

how to create an attachment column in the SharePoint online list
how to create an attachment column in the SharePoint online list

Now in the below screenshot, you can see that the Attachments column is added.

create an attachment column in the SharePoint online list example
create an attachment column in the SharePoint online list example

This is how can we create an attachment column in the modern SharePoint online list.

Add Folders in SharePoint online list

Let us see how we can add folders to the SharePoint Online list,

  • Open the SharePoint Online list and click on the Settings Gear Icon and select the List Settings.
SharePoint online list add Folders
SharePoint online list add Folders

Select Advanced Settings, under the General Settings on the list settings page.

add Folders to the sharePoint online list
add Folders to the SharePoint online list

In the Advanced settings page, enable the Make a New Folder to yes. Scroll to the bottom and click on the Ok button to save the changes.

Add Folders in the Modern SharePoint list
Add Folders in the Modern SharePoint list

Now you can see the Folder option is Presented, under the + New option.

add Folders to sharePoint online list
add Folders to the SharePoint online list

Select the Folder option to Create a folder and click on the Create button.

add Folders to the modern sharePoint list
add Folders to the modern SharePoint list

Here in the below screenshot, you can see that the folder is created in the modern SharePoint list.

add Folders to modern sharePoint list
add Folders to the modern SharePoint list

You can see that the folder is created in the modern SharePoint list, where we can add some list items inside the folder.

add Folders to modern sharePoint list example
add Folders to the modern SharePoint list example

This is how we can add folders to the SharePoint Online list.

SharePoint online list hide folders

Let us discuss how we can hide folders in the SharePoint list and display all the items presented inside the folder,

Yes, it is possible, to hide the folders and display the items in the SharePoint Online list.

  • Open the SharePoint Online list for which you want to hide the folders and click on the Settings Gear Icon and select the List Settings.
hide Folders in sharePoint online list
hide Folders in SharePoint online list

In this example, you can see I have added the Employee called Tanya inside the Sample Folder in the SharePoint Online list.

hide Folders in the sharePoint online list
hide Folders in the SharePoint online list

In the list settings page, select the All items under the Views option as shown below:

hide Folders from the sharePoint online list
hide Folders from the SharePoint online list
  • Now in the View settings page, expand the Folders and Select the Show all items without folders option.
  • Click the Ok button to save your changes.
hide Folders from sharePoint online list
hide Folders from the SharePoint online list

Now in the below screenshot, you can see the Sample Folder is hidden or disappeared and the item is displayed in the SharePoint Online list.

SharePoint online list hide folders
SharePoint online list hide folders

This is how we can hide folders in the SharePoint list and display all the items presented inside the folder.

Display attachment name in SharePoint online list

No, it is not possible to display the attachment name in the SharePoint Online List.

  • In the Modern SharePoint Online list, Currently, there is no option to display the attachments name.
  • Only we can see the paper click icon in the attachments column when the file is attached for the list items.
Display attachment name in SharePoint online list
Display attachment name in SharePoint online list

How to enable the geolocation field in the SharePoint online list

Let us see how we can enable the geolocation field in the SharePoint online list,

  • We can add the geolocation field column in the SharePoint online list as well as the SharePoint online library.
  • SharePoint location column permits us to add location data from the Bing map.
  • SharePoint location column includes fields such as city, Street address, religion or country, state, postal code, and Name.
  • In the list view, we can also sortfilter, or even search with the location data such as address, city, street, state, etc.

Follow the below steps to enable the geolocation field in the SharePoint Online list:

  • Open the SharePoint Online list, Select +Add Column to add the location field column.
enable the geolocation field in the SharePoint online list
enable the geolocation field in the SharePoint online list
  • Enter the Name of the Location column in the Name field, and you can add a description that is optional.
  • We can also select the linked columns to be displayed in the current view. In this example, I have selected the linked columns as Street Address, City, State, and Postal Code.
  • Then click on the Save button.
enable the geolocation field in SharePoint online list
enable the geolocation field in SharePoint online list

In the below screenshot, you can see that the Employee Location is created with the selected linked columns.

enable the geolocation field in modern SharePoint list
enable the geolocation field in the modern SharePoint list
  • Now Select +New to add a new item to the SharePoint Online list. You can see in the Employee Location field, we can add the location in the text box.
  • We can also use the Use this location option to detect the current location.
enable geolocation field in modern SharePoint list
enable the geolocation field in the modern SharePoint list

Once the Location is Selected, Click on the Save button.

how to enable the geolocation field in the SharePoint online list
how to enable the geolocation field in the SharePoint online list

In the below screenshot, you can see that the new item is added with the Employee location and the selected linked columns like city, state, postal code, etc.,

how to enable the geolocation field in SharePoint online list
how to enable the geolocation field in SharePoint online list

This is how we can enable the geolocation field in the SharePoint online list.

SharePoint online list row limit

  • A SharePoint list can have a maximum of 30 million items, and a SharePoint document library can have a maximum of 30 million files and folders.
  • The File path filename cannot include more than 400 characters for one drive and SharePoint.

SharePoint list column width [Classic site]

Let us see, how to change the width of the list view column in SharePoint 2013 using SharePoint designer 2013. We will also see, how to increase the SharePoint list title column width using jQuery.

Change SharePoint list column width using SharePoint Designer 2013

Recently in a business requirement, we got to increase the width of a SharePoint list view column.

Here I have a SharePoint list that has one column named as “CreatedByFirstName” the width is a bit bigger and it looks like the below:

change width of list column using sharepoint designer

Now Open your SharePoint site using the designer. Open the particular list and then in the list settings page, select the particular view, right-click and then edit the file in advanced mode.

Once it will open in advanced mode, From the ribbon select the Design tab in the LIST VIEW TOOLS section. And then click on Customize XSLT -> Customize Entire View as shown in the fig below. If you are not able to see the LIST VIEW TOOLS tab then, you can follow the List View Tools tab missing in the SharePoint designer 2013 article.

sharepoint 2013 change width of list column

Then in the whole file search for the below text.

<th nowrap="nowrap" scope="col"

Above to the line, you will see the below similar kind of line based on your column name.

<xsl:template name="FieldRef_header.CreatedByEmail" ddwrt:dvt_mode="header"

Here the column name is “CreatedByEmail”

Then we need to put the style attribute in the below <th line like below:

<th nowrap="nowrap" scope="col" onmouseover="OnChildColumn(this)" style="width:100px;">

I have set the header to be 100px for this column. Similarly, you can define other columns as well.

sharepoint change width of list column

Then save the page and refresh the view, your width should be displayed like below:

sharepoint change width of list column using designer

This is how to change sharepoint list column width using SharePoint designer.

Change SharePoint list column width using jQuery

Now, we will see how to increase the SharePoint list title width using jQuery. The same jQuery code can be used to increase the list title column in SharePoint 2013/2016/2019 or SharePoint Online.

By default if you will open a list view, the title column width looks like the below:

Increase SharePoint 2013 list title column width using jQuery

Open the SharePoint 2013 list view page, here I want to change in the AllItems.aspx page. Then Edit the page and then add a script editor web part. In the Script editor web part, put the below lines of code. Then Save the Page.

Below is the full code to increase the width of the SharePoint list title column using jQuery.

<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.2.6/jquery.min.js"></script>
<script type="text/javascript">
$(document).ready(function() {
$("TH.ms-vh2:contains('Title')").css("width", "300px");
});
</script>

Now the List title column width will look like below:

Increase SharePoint list title column width using jQuery
sharepoint list column width

This is how to adjust column width in sharepoint list without designer.

In this tutorial, we learn everything about the SharePoint Online list. We covered:

  • What is a list in SharePoint Online?
  • How to create a SharePoint Online list
  • Create a SharePoint list from a Blank list
  • Create a SharePoint list from Excel
  • Create a SharePoint list from an existing list
  • Create a SharePoint list from a Template
  • How to Rename SharePoint Online List title
  • How to update SharePoint Online list description
  • Add a column to a SharePoint Online list
  • SharePoint Online List Column limit
  • Rename SharePoint Online List Title column
  • How to Change SharePoint Online list column width
  • How to favorite a SharePoint Online list
  • How to insert an item into the SharePoint Online list
  • How to Update an item in the SharePoint Online List
  • How to delete an item from the SharePoint Online list
  • How to delete multiple items in the SharePoint Online list
  • Attach a document to a SharePoint Online list
  • SharePoint Online list attachments size limit
  • SharePoint Online List Templates
  • Show/Hide Columns in a Modern SharePoint Online List
  • How to delete a column from a SharePoint online list
  • SharePoint online list Remove Title Column
  • How to create an index column in SharePoint online list
  • SharePoint Online List id
  • Export SharePoint online list to excel
  • SharePoint online lists Multiple lines of the text character limit
  • SharePoint Online list item comments
  • SharePoint online list column names escape codes
  • How to create an attachment column in SharePoint online list
  • Add Folders in SharePoint online list
  • SharePoint online list hide folders
  • Display attachment name in SharePoint online list
  • How to enable the geolocation field in the SharePoint online list
  • >