Home > Blog > How to Create a SharePoint List
how to create a SharePoint list

Ever since its inception, lists have been one of the core functionalities of SharePoint, helping users organize information. Knowing how to create a SharePoint list is one of the most important steps in using SharePoint. With the aid of templates, such as Calendar and Tasks, a SharePoint list or library can take many forms, shapeshifting to meet the needs of its users.

Learning how to create and use a SharePoint list or library is one of the core skills necessary to master SharePoint or SharePoint Online and increase collaboration across your organization.

Below you will find the steps to create a list in SharePoint or SharePoint Online.

how to create a SharePoint list

Permissions

Across all versions of SharePoint, users will need at least Edit permissions to create and manage a SharePoint list or library. You can review assigned permissions in the List Settings by clicking the gear icon.

How To Create A SharePoint List

If you’re ready to get started, we’ve outlined the steps to create a list in Modern and Classic SharePoint. Each is similar but unique. Keep reading to get started.

Create A Modern SharePoint List

You will build a modern SharePoint list if you use one of the following SharePoint versions:

  • SharePoint Online
  • SharePoint Server 2019

To get started, from a page on your SharePoint site, click on the + New dropdown menu and select List to create a new list.

new list dropdown modern SharePoint

On the Create a list popup, you have the option to create a list from multiple sources:

create a list popup modern SharePoint

Blank List

A new list with only a Title column will be created. This will serve as a launching point for a custom list that can then be built to suit your needs. 

blank list form modern SharePoint

From Excel

This option allows you to upload an Excel file from your PC or select an Excel file already uploaded to your SharePoint site to use as a base for your SharePoint list. SharePoint will pull in the existing columns and data from your spreadsheet, so you don’t need to duplicate data entry efforts.

For the import to successfully complete, your Excel data must be formatted as a table.

list from Excel modern SharePoint

From Existing List

If there is an existing list in your SharePoint environment that has the columns you want in your new list, you can use it as a template. It is important to note that this option will copy columns, views, and settings from the original list, but it will not copy over individual list items. 

from existing list modern SharePoint

Templates

Various modern templates exist to help users quickly create a list in SharePoint to cover common business scenarios. By clicking on each template, you can see what columns would be included, their formatting, and what the list will look like with sample data.

modern template form
Once you have chosen the type of list you want to create, you will need to enter a name for your new list.

Optionally, you can add a description to help users understand the purpose of the list. There is also a checkbox that lets you decide if you want the list automatically added to the site’s navigation menu.

Please note, if you don’t check this box, you can always go back and add it later.

create form modern SharePoint
Click the Create button at the bottom of the form and your modern SharePoint list is ready to go.

Create A Classic SharePoint List

You can build a classic SharePoint list if you use one of the following SharePoint versions:

  • SharePoint Online
  • SharePoint Server 2019, 2016 and 2013
To get started, from any page on your site, click on the Settings icon in the upper right corner of your screen and select Add an app.
SharePoint Online and SharePoint Server 2019

SharePoint Online and SharePoint Server 2019

SharePoint Server 2016 and SharePoint Server 2013

SharePoint Server 2016 and SharePoint Server 2013

Next, on the Your Apps page is a selection of all the list and library templates available within your site, including any custom templates created by users. 

classic your apps page
If you are unsure of the purpose of a template, you can click on the App Details page beneath it, and a new page with a description of the template will load.
classic app details page
Once you have decided on a template, click on its tile to add it.
classic creation form
From the popup, you can either enter a list name for your new list and click the Create button, or you can click on the Advanced Options link.

The Advanced Options link will allow you to add a list name, description of the new list.

This can also be done later after the initial list creation by clicking on the gear icon and going to List Settings.

classic advanced options form
Finally, click on Create at the end of the form and your SharePoint list is ready to go.

Create a Custom List

Have a unique or specific set of fields you want to you in your list?

If so, you can create a custom list. A custom list will allow you to populate each field of your list based on your data needs.

To create a custom list follow the same steps as above. When you reach the “Create a list” screen, choose “Blank list”. Your custom list in SharePoint can then be built field by field to match your needs.

What More Can You Achieve Once You Learn How to Create a List?

And that’s all there is to it! How can your organization benefit from a SharePoint list?

If you are still in the infancy stages of your SharePoint or SharePoint Online deployment and want assistance training your users on SharePoint basics, check out our End User Support Services!

Additional SharePoint Articles

 

How to Run a .PS1 File in SharePoint Online Management Shell

How to Run a .PS1 File in SharePoint Online Management Shell

Repetitive tasks are a necessary evil. Many IT administrators rely on PowerShell scripts to automate their duties and monitor systems. Scripts can be run to complete operations in Office 365 and SharePoint Online. A script is a collection of...

How to Create a SharePoint Site

How to Create a SharePoint Site

Before we get into how to create a SharePoint site, here is a brief history lesson regarding SharePoint and its terminology. For years, when discussing SharePoint on-premises architecture, the community differentiated between site collections and...

How to Create a Folder in SharePoint

How to Create a Folder in SharePoint

One of the main functions of SharePoint is document management. While SharePoint as a platform is versatile and can wear numerous hats, it shines as a file storage and collaboration tool. Many users are comfortable structuring document shares using...

0 Comments

[wpforms id="1422"]
<div class="wpforms-container wpforms-container-full" id="wpforms-1422"><form id="wpforms-form-1422" class="wpforms-validate wpforms-form" data-formid="1422" method="post" enctype="multipart/form-data" action="/blog/how-to-create-a-sharepoint-list" data-token="ceebc6219bf7c9c0b62eceeef5108158"><noscript class="wpforms-error-noscript">Please enable JavaScript in your browser to complete this form.</noscript><div class="wpforms-field-container"><div id="wpforms-1422-field_0-container" class="wpforms-field wpforms-field-name" data-field-id="0"><label class="wpforms-field-label" for="wpforms-1422-field_0">Full Name <span class="wpforms-required-label">*</span></label><input type="text" id="wpforms-1422-field_0" class="wpforms-field-large wpforms-field-required" name="wpforms[fields][0]" required></div><div id="wpforms-1422-field_1-container" class="wpforms-field wpforms-field-email" data-field-id="1"><label class="wpforms-field-label" for="wpforms-1422-field_1">Email <span class="wpforms-required-label">*</span></label><input type="email" id="wpforms-1422-field_1" class="wpforms-field-large wpforms-field-required" name="wpforms[fields][1]" required></div><div id="wpforms-1422-field_3-container" class="wpforms-field wpforms-field-phone" data-field-id="3"><label class="wpforms-field-label" for="wpforms-1422-field_3">Phone <span class="wpforms-required-label">*</span></label><input type="tel" id="wpforms-1422-field_3" class="wpforms-field-large wpforms-field-required wpforms-masked-input" data-inputmask="&#039;mask&#039;: &#039;(999) 999-9999&#039;" data-rule-us-phone-field="true" name="wpforms[fields][3]" required></div><div id="wpforms-1422-field_2-container" class="wpforms-field wpforms-field-textarea" data-field-id="2"><label class="wpforms-field-label" for="wpforms-1422-field_2">How can we help you? <span class="wpforms-required-label">*</span></label><textarea id="wpforms-1422-field_2" class="wpforms-field-small wpforms-field-required" name="wpforms[fields][2]" required></textarea></div><div id="wpforms-1422-field_15-container" class="wpforms-field wpforms-field-html" data-field-id="15"><div id="wpforms-1422-field_15"><p style="padding-top: 10px; padding-bottom: 10px; font-family: 'Open Sans', sans-serif; font-size: 10px; color: #333333;">By clicking the button below, you are agreeing to our <span style="text-decoration: underline;"><span style="color: #000000;"><a style="color: #000000; text-decoration: underline;" href="https://www.incworx.com/privacy-policy">Privacy Policy</a></span></span>.</p></div></div><div id="wpforms-1422-field_7-container" class="wpforms-field wpforms-field-hidden" data-field-id="7"><input type="hidden" id="wpforms-1422-field_7" name="wpforms[fields][7]" value="How to Create a SharePoint List"></div><div id="wpforms-1422-field_9-container" class="wpforms-field wpforms-field-hidden" data-field-id="9"><input type="hidden" id="wpforms-1422-field_9" name="wpforms[fields][9]" value="196.240.237.129"></div><div id="wpforms-1422-field_10-container" class="wpforms-field wpforms-field-hidden" data-field-id="10"><input type="hidden" id="wpforms-1422-field_10" name="wpforms[fields][10]" value="https://www.incworx.com"></div></div><div class="wpforms-field wpforms-field-hp"><label for="wpforms-1422-field-hp" class="wpforms-field-label">Message</label><input type="text" name="wpforms[hp]" id="wpforms-1422-field-hp" class="wpforms-field-medium"></div><div class="wpforms-submit-container" ><input type="hidden" name="wpforms[id]" value="1422"><input type="hidden" name="wpforms[author]" value="2"><input type="hidden" name="wpforms[post_id]" value="7909"><button type="submit" name="wpforms[submit]" class="wpforms-submit " id="wpforms-submit-1422" value="wpforms-submit" aria-live="assertive" data-alt-text="Sending..." data-submit-text="Submit">Submit</button></div></form></div> <!-- .wpforms-container -->