SharePoint lists are a key, underlying feature of a SharePoint site. They enable authenticated users with the ability to gather, track, and share information using the web browser. Lists function similarly to databases, in that individual items (or records) are generated, tracked, and fetched based on specific metadata. A list can be thought of as a collection of pieces of information – all of which have the same properties.
For example, you can have a list for faculty members, where each item includes a name, title, and brief description.
Lists are created using columns. You can create a list with as many columns as you need to gather the data you want to collect. There are a variety of column types you can choose from, including text, number, choice, currency, date and time, and yes/no to name a few.
Think of a SharePoint list like a spreadsheet. It allows you to collect data within specific columns just like a spreadsheet. You create and name columns in the list just like you would in Excel. You can also search, sort, and manage the data you collect in columns just like you would in a spreadsheet.
At CU Denver, a SharePoint list is used to collect and manage form data. Each question you want on your form is a column in the SharePoint list. You define the column type, content, and functionality when you develop your form. If you want to collect name, phone number, and email address, each one is a column. Think of columns in a list like columns in an Excel spreadsheet.