Microsoft Lists or SharePoint List: same storage, two interfaces

Microsoft Lists and a classic SharePoint list store their data in technically identical ways: every list you create in the Lists app ultimately resides in SharePoint Online, either on a team site or, in the case of a personal list, in your OneDrive for Business. According to the official Microsoft introduction to Lists the Lists app uses SharePoint as its underlying storage service, so the difference lies not in the storage location but in the interface and the templates that Lists additionally provides. In practice, this means you can open an existing SharePoint list in Lists at any time and vice versa, without having to move any data. As of: August 2026.

Where are personal lists actually stored?

Personal lists that you place under "My Lists" instead of on a site when creating them end up in your own OneDrive for Business, which itself in turn runs on SharePoint Online. According to a clarification in the Microsoft Q&A forum a personal list is thus visible only to you as long as you do not explicitly share it, whereas a list placed on a team site automatically inherits that site's permissions. For team data that several people are meant to work on, the site list is therefore almost always the right choice; personal lists are better suited to individual to-do lists or drafts that are not yet meant to be shared.

What can the Lists app do that a plain SharePoint list can't?

The Lists app itself does not add any new storage technology, but rather its own home page with ready-made templates for typical use cases such as issue tracking, inventory management, or event planning. These templates are pre-configured column structures and views that you can then adjust freely; technically, this results in a perfectly normal SharePoint list. In addition, Lists offers a mobile app and the ability to open lists directly from Microsoft Teams, which is not available for a classic SharePoint list without an extra step.

How are multiple lists connected?

Using lookup columns, you can reference values from another list within a list, for example to access the matching row in a "Customers" list from an "Orders" list via a lookup column. This does not replace a relational database, but it is sufficient for many SME use cases to avoid duplicate data maintenance. It is important to create the target list first, since the lookup column already references an existing list when it is created and cannot retroactively point to a list that does not yet exist.

When is automation based on lists worthwhile?

As soon as several people regularly create or change entries in a list, it is worth taking a look at Power Automate, because status changes, new rows, or approvals can be fed directly into a flow, for example to automatically send a notification or start an approval process when a new row is added. For companies that do not want to build this automation themselves, NordFlux handles the setup as a fixed-price project.

Frequently asked questions about Microsoft Lists and SharePoint lists

Can I retroactively turn a SharePoint list into a Lists template?

No, an existing list cannot retroactively be assigned to a template, but you can manually transfer the views and column formatting of the templates to an existing list. At its core, the template is only a starting point for new lists, not a permanent property of the finished list.

Do I lose data if I later move a personal list to a site?

Microsoft Lists does not offer a direct move function between "My Lists" and a site; in practice, you export the list and re-import it at the destination. For lists that are foreseeably going to be used by several people, therefore plan for a team site as the storage location from the outset.

Does a list in Lists count toward the SharePoint storage quota?

Yes, since the data is technically stored in SharePoint Online or OneDrive, it counts toward the respective storage quota of the tenant or the user. For most lists with text and number columns, this is not a relevant limit in practice; only extensive attachments add up noticeably.

Do I need an additional license for Microsoft Lists?

No, Microsoft Lists is part of SharePoint Online functionality and is therefore included in the common Microsoft 365 plans that include SharePoint; a separate license is not required. If in doubt, check your current plan in the Microsoft 365 admin center, since older or pure Exchange plans sometimes do not include SharePoint.