Microsoft Lists vs Airtable for a small team

Up front: my work is Microsoft 365, so I lean toward Microsoft Lists. I still try to be fair here, and I name the places where Airtable is the better tool.

Short answer: use Microsoft Lists if your team already has Microsoft 365 and needs one shared list of owners, statuses and due dates. Choose Airtable if you need linked tables and several views of the same records and a per-person fee is fine. Airtable is its own paid service, while Lists comes with the Microsoft 365 business plans you may already hold.

The two tools in plain terms

Microsoft Lists is a tool for sharing and tracking data in a list format. Microsoft says: "You can create lists in SharePoint, the Lists app in Microsoft 365, or Microsoft Teams." Each row is an item. Each column has a type, such as date, person or choice.

Airtable is a separate online database service. You build "bases" that hold tables of records. Airtable also has a feature called Interface Designer for building custom screens on top of a base.

Both look like a spreadsheet at first. Both are better than a spreadsheet when several people update the same records.

Where Microsoft Lists wins

Start with the bill. If your company already pays for Microsoft 365 Business Basic, Standard or Premium, Microsoft says SharePoint is part of that plan, and Lists runs on SharePoint. Nobody signs up for a new account, and there is no seat count to watch each month. Ask your admin what your plan allows.

Then look at scale. Airtable's Team plan stops at 50,000 records per base. Microsoft says one list can hold up to 30 million items, and a file attached to an item can be up to 250 MB. A team that logs every shipment or every service call can keep years of rows in one place, as long as its views stay filtered (see the next section).

Last, access. Airtable controls what people see mainly through interfaces and the permissions set on them. In Lists you can give a single item its own permissions; Microsoft supports up to 50,000 of these per list and recommends 5,000. Hiding a column in a view protects nothing. Teams, SharePoint and Power Automate are one click away, so staff keep the sign-in they already have.

Where Airtable wins

Be honest about this part. Airtable is a strong tool.

Interfaces. Airtable's Interface Designer page lists "end-user-specific record filtering" and "data security via more granular access permissions." That gives you clean screens for people who should not see the raw data.
Syncing between bases. Airtable can sync records from one base to another on all paid plans. Its sync page lists two-way sync on Business, not Team.
Views. Airtable's plans page lists timeline, Gantt and calendar views on the Team plan.
Not tied to Microsoft. If your company does not use Microsoft 365, Lists is not an option. Airtable works for anyone.

Record caps and file sizes

Airtable record limits per base, from Airtable's own plans page:

Free: 1,000 records per base, 1 GB attachments per base, 100 automation runs per workspace per month.
Team: 50,000 records per base, 20 GB attachments per base, 25,000 automation runs per workspace per month.
Business (self-serve): 125,000 records per base, 100 GB attachments per base, 100,000 automation runs per workspace per month.
Enterprise Scale: contact Airtable sales.

Airtable's plans page also lists API calls per workspace per month: 1,000 on Free, 100,000 on Team and unlimited on Business self-serve.

Microsoft Lists, from Microsoft's limits page: up to 30 million items per list, 250 MB per attached file.

One catch on the Microsoft side. Microsoft says: "When a list view shows more than 5,000 items, you might run into a list view threshold error." Microsoft suggests column indexes, filters, folders and personal views. So a very large list works when your views are filtered. Our guide "SharePoint list over 5,000 items: what breaks and the fix" covers this.

At a glance

Swipe sideways to see all columns.

Topic	Airtable	Lists
Fits	linked tables, custom interfaces	shared records, status, owners
Where it lives	its own site and login	inside Microsoft 365, Teams and SharePoint
Cost model	per seat on paid plans, Free plan available	included in Microsoft 365 business plans
Size	50,000 records per base on Team, 125,000 on Business	up to 30 million items per list
Attachments	20 GB per base on Team	250 MB per attached file
Automation	built in, run limits by plan	Power Automate
Custom screens	Interface Designer	views (personal and public)
Sync between bases	one-way sync on paid plans, two-way on Business	lookup columns pull a value from another list
Big-list catch	record limit per base	5,000 view threshold, so filter views

Which one fits your team

Airtable fits when your data is really several tables that point at each other, such as clients, jobs and invoices, and each job should show its client without retyping. Linked tables do that. Lists can pull a value from another list with a lookup column, while Airtable's linked records are built around this. It also fits when outside people need a clean screen: an interface can hide the base behind it. Plan around the record cap too. Team stops at 50,000 records per base and Business at 125,000, so a log that grows daily needs a bigger plan or an archive routine.

Microsoft Lists fits when the data is one table with owners, statuses and dates, and the people who edit it already sign in to Microsoft 365. It also fits when a single list may grow past what an Airtable base allows, as long as the views stay filtered.

Our advice, not a Microsoft rule: copy 20 real rows into both tools, hand each to the person who types the most, and keep the one that person opens without a reminder. If you are leaving a spreadsheet, see our guide "Replace a spreadsheet tracker with a SharePoint list". Also see our guide "SharePoint list vs Excel for team tracking: which one fits?".

Seats and bills

Airtable bills by seat. Its pricing page lists a Free plan, paid Team and Business plans priced per user, and Enterprise Scale quoted by sales. Airtable's pricing page says paid plans charge for users with edit permissions on at least one base, and nothing for read-only collaborators, form submissions or share links. Its plans page adds that the Team plan also bills commenters. Read the current price on Airtable's pricing page before you commit.

I print no Microsoft prices in this guide. If your team already holds a Microsoft 365 business plan, SharePoint and Lists come with it, and Microsoft's own pricing page has the plan numbers. Our advice, not a Microsoft rule: tally the editors on your team, then price that exact headcount in each tool. For 10 editors, multiply the per-seat price on Airtable's page by 10 and by the months in your billing term, and compare it with the Microsoft 365 plan you already pay for.

Reminders and flows

Airtable ships its own automations, with a monthly run cap per workspace set by plan (figures above).

Lists connects to Power Automate, Microsoft's tool for flows that run between apps, such as a reminder or a copy step. Menu names can differ on your screen. Whether a given flow needs an added license depends on the flow and on your plan, so ask your admin.

For a ready pattern, read our guide "Send a reminder before a due date in a SharePoint list".

What to avoid

Do not judge by the longest feature list. Ask who will type into the tool every day, and pick for them.
Do not rebuild a whole base on day one. Move the one table your team opens daily, then add links later.
Do not trust a record or run limit you read last year. Airtable and Microsoft both update their plan pages, so check them the week you buy.
A hidden column or a filtered view is not a lock. In Lists, set permissions on the list or on the item.
Do not switch tools on a hunch. Run both side by side for one week with real rows.

When to get help

You can build all of this yourself in Microsoft 365. If you would rather have it built and tested for your team, I do that. A tracker like this is a fixed price: $5,000 for one, built in 2 weeks. See "What a SharePoint tracker costs to build". Bring one example of the problem to a free call.

Tell me what's still manual

I am Al Davies. I run 250 High Street LLC and build SharePoint trackers and Power Automate flows for operations teams. I work remotely. The first call is free, and I will not try to sell you anything.

See trackers I built: Tools I built

FAQ

Is Microsoft Lists free?

It is included in Microsoft 365 business plans. It is not a separate free product. I print no Microsoft prices here. Check with your admin or Microsoft's pricing page.

Is Microsoft Lists the same as Teams?

No. Microsoft says you can create lists in SharePoint, the Lists app in Microsoft 365, or Microsoft Teams, so Teams is one place a list can live.

How do Microsoft Planner and Microsoft Lists differ?

See "Planner vs SharePoint list" for the Planner comparison.

What does Airtable cost for a team of 10?

Airtable bills by seat. Its pricing page counts people with edit rights on at least one base, and its plans page says Team also counts commenters. Read the per-seat price on Airtable's pricing page and multiply by that headcount.

How many rows can each tool hold?

Microsoft says a list can have up to 30 million items. Airtable lists 50,000 records per base on Team and 125,000 on Business self-serve.