Lists and Libraries

A SharePoint List is a structured table of items, similar to a spreadsheet, where each item is a row and each column defines a piece of metadata such as text, choice, date, or a lookup to another list. A Document Library is technically a specialized list where every item also has an attached file, plus built-in file-handling behavior like check-out, version history, and content types. Both live inside a SharePoint site and are backed by the same underlying list architecture in SharePoint Online.

Lists can be created from a blank template, imported from Excel, or provisioned programmatically using the PnP PowerShell module or the REST/Graph APIs. Once created, you add columns to define the schema: Single line of text, Choice, Person or Group, Date and Time, Number, Lookup, and Managed Metadata are the most common column types. Each column can be marked as required, given a default value, and validated with a formula, which lets a list behave like a lightweight database table without writing any backend code.

The key functional difference is that libraries add file-centric capabilities on top of the same list engine: check-out/check-in to prevent edit conflicts, major and minor version numbering, content type association per file, and Office co-authoring through Word, Excel, and PowerPoint online. Custom lists, by contrast, are pure metadata containers ideal for tracking things like tasks, contacts, or approval requests where no file attachment is the primary artifact, although lists do support ad-hoc attachments as a secondary feature.

Views let you present the same underlying list data differently: a public view is shared with everyone who has access, while a personal view is scoped to the individual who created it. Views support column-level filtering, multi-column sorting, and grouping, and can be set as the default view for a list or library. However, SharePoint enforces a List View Threshold of 5,000 items per query by default, meaning a view that tries to filter or sort across more than 5,000 items without an indexed column will throw a throttling error instead of returning results.