Updated 30 March 2026

Maximizing the Airtable Free Plan

Unlimited bases, 1,000 records each, 100 automation runs per month, 1 GB attachments. Here is every constraint, how to work around it, and the decision framework for when Free stops working.

Unlimited

Bases

1,000

Records per base

100

Automation runs/mo

1 GB

Attachments per base

Every Free Plan Constraint

Understanding each limit and its practical impact helps you plan around them.

1,000 records per base

High impact

The primary upgrade trigger. Most business use cases hit this within 3 to 12 months.

1 GB attachments per base

Medium impact

If you attach images, PDFs, or files to records, 1 GB fills quickly. A base with 500 product photos at 2 MB each uses the full 1 GB.

100 automation runs per month

High impact

About 3 automations per day. Any team relying on automations will exceed this within the first week.

1,000 API calls per month

Medium impact

Roughly 33 API calls per day. Sufficient for light integrations. Inadequate for syncing data with external tools in real time.

1 extension per base

Low impact

You get one chart, one script, or one third-party extension. Teams that need dashboards with multiple charts must upgrade.

1 sync integration

Low impact

You can sync data from one external source. Cross-base sync requires a paid plan.

2-week revision history

Medium impact

You can only undo changes made in the last 14 days. Accidental deletions beyond that window are permanent.

Interface Designer (limited)

Low impact

You can build interfaces but with restrictions on the number of elements and interfaces per base.

Strategies to Extend Free Usage

Five practical approaches to stay on Free longer.

Archive old records to a separate base

Effort: LowEffectiveness: High

Create an "Archive" base and periodically move inactive records there. For example, a CRM can archive contacts that have not been updated in 6+ months. This keeps your active base under 1,000 records while preserving historical data. You can move records manually or use a simple automation (1 run per move).

Use views instead of separate tables

Effort: LowEffectiveness: Medium

Instead of creating a separate table for "Active Projects" and "Completed Projects," use a single table with a Status field and create filtered views. This reduces your total record count since views do not create new records. Each view is just a lens on the same underlying data.

Split data across multiple bases

Effort: MediumEffectiveness: Medium

Since the 1,000-record limit is per base, you can create multiple bases. A recruiting team might have one base for Q1 applicants and another for Q2. The downside: you cannot link records across bases on the Free plan, and managing fragmented data becomes painful at scale.

Use templates to avoid building from scratch

Effort: LowEffectiveness: Low

Airtable offers hundreds of free templates. Starting from a template saves you from creating tables, fields, and views manually. It also ensures you are using Airtable best practices (proper field types, efficient table structures) which helps you stay within limits longer.

Link bases manually instead of using Sync

Effort: HighEffectiveness: Low

On the Free plan, Sync is limited to 1 integration. If you need data from multiple bases, you can manually copy/paste key records or use the API (within the 1,000 call/month limit) to keep critical data aligned. This is tedious but avoids the upgrade for teams that only need occasional cross-base data access.

When Free Stops Working

The Free plan stops working when any of these conditions become true: your largest base consistently exceeds 800 records and is growing, your team needs more than 100 automation runs per month, you need to sync data between bases, or you need more than one extension per base for dashboards and reporting.

The most common upgrade trigger is the 1,000-record limit. In practice, teams notice the constraint before they hit it because Airtable starts showing warnings at roughly 800 records. By the time you are at 900 records and adding 50 to 100 per month, the upgrade decision needs to happen immediately to avoid disrupting your workflow.

Do not wait until you hit the limit. If your growth rate suggests you will reach 1,000 within the next 2 to 3 months, start the upgrade process now. Getting budget approval and setting up billing takes time, and you do not want to be blocked from adding records while waiting for procurement.

Which Paid Plan to Pick

Team ($20/seat/month)

Choose Team if you need more records (up to 50,000 per base), more automation runs (25,000/month), and more extensions (10 per base). Team is the right choice for most small to mid-size teams that have outgrown Free but do not need enterprise security features.

Team also unlocks Gantt and timeline views, 6-month revision history, and 3 sync integrations. For a 5-person team, this costs $100/month on annual billing. That is $20/person for a significant upgrade in capability over Free.

Business ($45/seat/month)

Choose Business if you need SAML SSO, the admin panel, 125,000 records per base, unlimited extensions, unlimited sync integrations (including two-way sync), or 100,000 automation runs per month. Business is designed for teams of 20+ users that need IT governance and enterprise features.

Business also includes a 1-year revision history and 100 GB of attachments per base. For a 10-person team, this costs $450/month on annual billing. The jump from Team to Business is significant ($25/seat/month more), so only upgrade when you genuinely need the additional capacity or SSO requirement.

Airtable Free vs Google Sheets

The most common alternative to Airtable Free is Google Sheets, which is completely free within Google Workspace. Google Sheets supports up to 10 million cells per spreadsheet and has no record limits. For raw data storage capacity, Google Sheets wins by a massive margin.

However, Google Sheets lacks every feature that makes Airtable valuable: linked records, rollups, lookups, typed fields (single select, multi-select, checkbox, rating, barcode), multiple views (kanban, gallery, calendar, timeline, form), built-in automations, and the Interface Designer. Google Sheets is a spreadsheet. Airtable is a database with a spreadsheet-like interface.

If your use case is purely tabular data without relationships, automations, or views, Google Sheets is the better choice because it is free with higher capacity. If your use case involves structured data with relationships, workflow automations, or team collaboration through forms and views, Airtable Free provides significantly more functionality despite the 1,000-record cap.

Many teams start with Google Sheets and migrate to Airtable when they outgrow what a spreadsheet can do. The migration is straightforward because Airtable supports CSV import. Just be aware that moving to Airtable and then exceeding 1,000 records means you will need a paid plan.

Frequently Asked Questions

How many records can I have on the Airtable Free plan?
1,000 records per base. This limit is per base, not per table. If your base has 3 tables with 400, 300, and 300 records respectively, that base has 1,000 total records and is at capacity. You cannot add more records to any table in that base until you delete existing records or upgrade to the Team plan (50,000 records per base).
Can I have multiple bases on the Free plan?
Yes. The Free plan allows unlimited bases. Each base has its own independent 1,000-record limit. This means you can theoretically have hundreds of bases, each with up to 1,000 records. Some users exploit this by splitting data across multiple bases to stay on Free, but this workaround has significant downsides: you cannot link records across bases on the Free plan (Sync is limited to 1 integration), and managing many small bases becomes operationally complex.
What happens when I hit 1,000 records on the Free plan?
Airtable blocks the creation of new records in that base. You will see an in-app notification as you approach the limit (typically around 800 records). Once you hit 1,000, you cannot add rows manually, import data, or create records via automations or the API. Existing records remain fully accessible and editable. You can delete records to free up space or upgrade to continue adding data.
Is the Free plan enough for personal use?
For most personal use cases, yes. A personal CRM with fewer than 1,000 contacts, a book reading tracker, a recipe database, a personal finance log, or a hobby inventory will fit comfortably within the Free plan limits. The main risk is growth: if your personal project starts exceeding 1,000 records, you will need to either archive old records or upgrade. Personal project databases rarely exceed 1,000 records, so Free works well for individual users.
Can I use automations on the Free plan?
Yes, but with a strict limit of 100 automation runs per month. Each triggered action counts as one run. A simple automation (trigger + 1 action) uses 1 run per execution. If you have a daily automation that runs once per day, that is roughly 30 runs per month, leaving 70 for other automations. Heavy automation users will burn through 100 runs quickly and should plan for the Team plan from the start.
How does the Free plan compare to Google Sheets?
Google Sheets is free with much higher cell limits (10 million cells per spreadsheet) but has no built-in automations, no linked records, no field types beyond text/number/date, no form views, and no kanban/gallery/timeline views. If you just need a big spreadsheet, Google Sheets wins on capacity. If you need structured data with views, automations, and forms, Airtable Free wins on functionality despite the 1,000-record limit.