# Microsoft Lists

> Information-tracking lists app included with Microsoft 365

Microsoft Lists is the information-tracking app in Microsoft 365. Teams build a list from a template, an Excel or CSV file, an existing list or a blank start, add columns for different types of data, and look at the same items as a grid, a calendar or a gallery. Lists can be created in the Lists app, in SharePoint or as tabs in Microsoft Teams channels, and the app comes with Microsoft 365 business and enterprise plans rather than being sold on its own.

- **Category:** Spreadsheets & Databases
- **Made by:** Microsoft
- **Website:** https://www.microsoft.com/en-us/microsoft-365/microsoft-lists
- **Runs on:** Web
- **Facts last checked:** Oct 6, 2026

## Pricing

Microsoft Lists is a paid product with a free trial, starting at $5.40 per user / month, paid yearly (Microsoft 365 Business Basic, no Teams).

- **Pricing model:** Free trial
- **Free plan:** None.
- **Free trial:** One-month free trial of the Microsoft 365 business plans; a credit card is required to sign up.

| Plan | Price | What you get |
| --- | --- | --- |
| Microsoft 365 Business Basic | $7.00 per user / month, paid yearly ($8.40 on a monthly subscription) | Lists with SharePoint, Teams, web and mobile Office apps, business email and 1 TB of storage per user. The version without Teams is $5.40. |
| Microsoft 365 Business Standard | $14.00 per user / month, paid yearly ($16.80 on a monthly subscription) | Everything in Basic plus desktop versions of Word, Excel, PowerPoint and Outlook, Loop and Clipchamp. The version without Teams is $10.79. |
| Microsoft 365 Business Premium | $22.00 per user / month, paid yearly ($26.40 on a monthly subscription) | Everything in Standard plus device management, protection against phishing and malware, and sensitive-data controls. $18.79 without Teams. |
| Business Standard with Copilot | $23.50 per user / month, paid yearly | Business Standard with Microsoft 365 Copilot Business built into Word, Excel, PowerPoint, Outlook and Teams. $20.30 without Teams. |
| Business Premium with Copilot | $32.00 per user / month, paid yearly | Business Premium with Microsoft 365 Copilot Business included. The version without Teams is $28.80. |

Read from https://www.microsoft.com/en-us/microsoft-365/business/microsoft-365-plans-and-pricing on Oct 6, 2026. Prices change, so confirm with Microsoft Lists before buying.

## Ways to pay less

- **Lower per-user price when paid yearly** (Annual discount): Business Basic is $7.00 per user a month paid yearly against $8.40 on a monthly subscription, Standard $14.00 against $16.80 and Premium $22.00 against $26.40. Source: https://www.microsoft.com/en-us/microsoft-365/business/microsoft-365-business-basic
- **Nonprofit grant and staff pricing** (Nonprofit): Eligible nonprofits get Microsoft 365 Business Basic as a grant, free for up to 300 users, with Business Standard at $3.50 and Business Premium at $5.50 per user a month, paid yearly. Source: https://www.microsoft.com/en-us/microsoft-365/business/nonprofit-plans-and-pricing

## Key features

- **Templates and imports:** Ready-made templates such as Issue tracker, Asset manager, Event itinerary and Onboarding checklist. A list can also start from an Excel workbook, a CSV file, an existing list or a blank page.
- **Grid, calendar and gallery views:** The same items can be shown as a list, a calendar or a gallery, and saved views can sort, group and filter them. A single view can display at most 5,000 items.
- **Conditional formatting:** View formatting highlights rows that meet a condition, such as a status set to Blocked, and alternating row styles are built in. An advanced mode accepts JSON.
- **Rules:** A rule pairs a trigger, such as an item being modified or a column value changing, with an action such as emailing someone. Date-approaching rules are limited to two per list.
- **Lists in Microsoft Teams:** A list can be added as a tab in a Teams channel, next to the conversation. Lists are created in the desktop or web version of Teams; on mobile, members can view and edit but not create them.
- **Power Apps and Power Automate:** Forms can be extended with Power Apps and workflows built with Power Automate, using a list as the data source for a custom app.

## Good for

- Organizations already paying for Microsoft 365 that need shared trackers
- Teams that want a tracker beside the conversation in a Teams channel
- Tracking issues, assets, events and onboarding from ready-made templates

## Worth knowing

- Lists is not sold on its own: it comes with Microsoft 365 business and enterprise plans, which are priced per user.
- The iOS and Android apps were retired in mid-November 2025. On a phone, Lists runs in a mobile browser or inside Teams.
- A list can hold up to 30 million items, but a view that shows more than 5,000 can run into the list view threshold.
- Help pages direct users to a work or school account. Lists for personal Microsoft accounts is offered only as a preview.

## Works with

Microsoft Teams, SharePoint, Power Automate, Power Apps, Excel

**Tags:** Databases, Templates, Workflow automation, Real-time collaboration

## Alternatives

- [Airtable](https://toolgpa.com/tools/airtable): Relational database platform for building team workflows and apps. [Compare](https://toolgpa.com/compare/airtable-vs-microsoft-lists)
- [Smartsheet](https://toolgpa.com/tools/smartsheet): Spreadsheet-style project and work management for teams. [Compare](https://toolgpa.com/compare/microsoft-lists-vs-smartsheet)
- [Zoho Tables](https://toolgpa.com/tools/zoho-tables): Spreadsheet-style relational database with automations. [Compare](https://toolgpa.com/compare/microsoft-lists-vs-zoho-tables)
- [Microsoft Access](https://toolgpa.com/tools/microsoft-access): Windows desktop database app sold with Microsoft 365. [Compare](https://toolgpa.com/compare/microsoft-access-vs-microsoft-lists)
- [Microsoft Planner](https://toolgpa.com/tools/microsoft-planner): Task and project planning app built into Microsoft 365. [Compare](https://toolgpa.com/compare/microsoft-lists-vs-microsoft-planner)

## Sources

The prices, plans, platforms and features above were read from these pages on Oct 6, 2026:

- https://www.microsoft.com/en-us/microsoft-365/microsoft-lists
- https://www.microsoft.com/en-us/microsoft-365/business/microsoft-365-plans-and-pricing
- https://www.microsoft.com/en-us/microsoft-365/business/microsoft-365-business-basic
- https://www.microsoft.com/en-us/microsoft-365/business/microsoft-365-business-standard
- https://www.microsoft.com/en-us/microsoft-365/business/microsoft-365-business-premium
- https://www.microsoft.com/en-us/microsoft-365/business/nonprofit-plans-and-pricing
- https://support.microsoft.com/en-us/sharepoint/lists/microsoft-lists-mobile-apps-retirement
- https://support.microsoft.com/en-us/sharepoint/lists/data-and-lists/what-is-a-list-in-microsoft-365
- https://support.microsoft.com/en-us/sharepoint/lists/create-a-list-from-the-lists-app
- https://support.microsoft.com/en-us/teams/platform/get-started-with-lists-in-teams
- https://support.microsoft.com/en-us/sharepoint/lists/data-and-lists/list-templates-in-microsoft-365
- https://support.microsoft.com/en-us/sharepoint/lists/documents-and-library/create-a-rule-to-automate-a-list-or-library
- https://support.microsoft.com/en-us/sharepoint/lists/data-and-lists/formatting-list-views
- https://support.microsoft.com/en-us/sharepoint/lists/data-and-lists/create-change-or-delete-a-view-of-a-list-or-library
- https://support.microsoft.com/en-us/sharepoint/lists/data-and-lists/list-view-threshold-for-large-lists-and-libraries

Page: https://toolgpa.com/tools/microsoft-lists
Listed by ToolGPA (toolgpa.com).