Table of Contents Create a Custom ListCreate Custom Columns within a List Utilize Custom Column ValidationName and Type of Column DefinitionsAdd Site Columns to a List Import an Excel Spreadsheet into a List/LibrarySync with OutlookCreate a View within a List?Recover a List Item
SharePoint Lists are one of the core components of SharePoint. SharePoint has a number of list templates ready to use:
What do you do if there is nothing here that fits your needs? You then create a custom list.
Once the list has been created, SharePoint will take you to the list view. The new list has one default column - Title. You likely will wish to add additional columns.
To add and customize columns for your list:
Depending on the type of column that you selected, more options may appear in the Additional Column Settings section. Select the additional settings that you want.
For definitions of Name and Type of Column Definitions,
Column Data Type
What It’s Used For
Display on Form
Single Line of Text
Displays text and numbers - up to 255 characters
Single line text box - text box may not show all 255 characters
Multiple Lines of Text
Display multiple lines of text.
Select from Plain Text, Rich Text, or Enhanced Rich Text. Even though you may set a number of lines for editing, this is not a defined limit. Users can type or cut/paste a large amount of text into this control. You may want to use column validation to restrict the length.
A defined list of choices which can be shown on the form as radio buttons for a single choice or check boxes for multiple choices.
Drop-down list is the default and most common.
Numerical values that can be used for calculations.
You can identify a min/max value number with a choice of decimal options.
Numerical values that represent money.
You can identify a min/max value currency. Includes options for decimal places and currency format.
Date and Time
Dates and times.
Date and/or Time-Calendar Picker.
Values from another list — for example, categories could be stored in a lookup list for document metadata.
Drop-down list populated based on values from other list.
Boolean value of Yes or No.
Person or Group
Directory listing information from SharePoint.
The person or group is shown as a hyperlink and can include presence information.
Hyperlink or Picture
Hyperlink (internal or external) or an image.
Hyperlink or picture.
Data that can be calculated by formula.
Result of calculation; can be text or numerical.
Data stored in a data source; for example, a table or view in an enterprise database.
Provides a common set of keywords and terms that can be used across the organization.
As the name implies, a view is a different way of looking at a list. For example, one view of a Contact list will show all of the columns, while another will show only Name, Phone Number, and Email address. Generally, only a Group Owner can create a new list view.