Maaz Zindani

Loading the index…

↑↓ move↵ openesc close4072 pages

Help for owners

My Airtable base has hit its record limit and I cannot add more

Short answer

Airtable limits records per base by plan, and the limit counts records across all tables in the base. Airtable's plans page lists 1,000 on Free, 50,000 on Team and 125,000 on Business. Before deleting anything, export a copy, then archive old records, split by purpose or move the data to a database.

  • Written for business owners
  • Updated
  • By Maaz Zindani, Senior Software Engineer

Does this sound like your situation?

  • Airtable says I cannot add more records.
  • Automations or forms that add records stop working.
  • The base is full of old records I never delete.
  • Attachments are using up my space.
  • Upgrading a plan helps for a while and then it fills up again.

Why does this happen?

  1. Limits depend on the plan

    Airtable's plans page lists records per base: 1,000 on Free, 50,000 on Team and 125,000 on Business, with attachment space per base of 1 GB, 20 GB and 100 GB. Check the page for your plan, as limits can change.

  2. Tables add up

    Airtable states that record limits are cumulative across all tables in a base. One table with 50,000 records and two with 25,000 each reach the same Team limit.

  3. Everything is kept forever

    Orders, logs, form entries and finished jobs pile up in the same base, so history takes room that current work needs.

  4. Duplicates and test data

    Imports run twice and old test records count toward the total like real ones.

  5. Automations feed it

    A form, an integration or an automation that adds a record for every event can fill a base faster than anyone expects.

What can I do about it today?

  1. Export firstDownload each important table as a CSV file, and keep them somewhere safe, before you delete or change anything.
  2. Find which tables are largestCheck the record count of each table. Usually one or two tables hold most of the total.
  3. Check for duplicates and test recordsLook for repeated rows and old test data, and remove them only after the export.
  4. Pause automations that add recordsIf an automation is flooding the base, pause it rather than delete it. Pausing is reversible.
  5. Compare plan and move optionsA higher plan raises the limit, and archiving or moving the data removes the limit problem. Decide by how fast the data grows.

When should I bring someone in?

  • The base runs orders or bookings and adding records is blocked.
  • Data keeps growing and each upgrade only delays the same problem.
  • Other tools read from or write to the base and must keep working.

How do I handle it?

  1. Measure growthI count records per table and per month, to see whether you are near a limit for good or just carrying old data.
  2. Archive what is finishedOld records are exported to an archive that stays searchable, with counts checked before anything is removed.
  3. Fix the sources of growthDuplicated imports and noisy automations are corrected so the base stops filling with junk.
  4. Plan the move for what must growIf the data really is large, it goes into a database with a simple screen, and Airtable can remain for the small, human-sized parts.
  5. Keep integrations workingForms and automations are repointed and tested so nothing silently stops.

The price depends on what I find, so I quote in writing after a short discovery call. Tell me what is happening and I reply within 24 hours.

What do owners ask about this?

Will upgrading solve it?

It raises the limit. Whether it solves the problem depends on how fast your data grows.

Does deleting records give me room back right away?

Airtable's page does not say what happens at the limit or how quickly space is freed, so check its support pages or ask its support. Export before you delete.

Can I use Airtable as a real database?

It works for many small businesses. When records, access rules or integrations outgrow it, a database is the next step.

Sources

How was this page made?

I drafted this page with AI assistance from the official documents listed under Sources. Found a mistake? Tell me.

Next step

Want this off your desk?

Send me a few lines on where things stand. I reply within 24 hours.