How to Use Airtable

Airtable is a spreadsheet that behaves like a database. You get rows and columns like a normal spreadsheet, but each column can be a specific data type (a date, a linked record, an attachment, a single-select tag), and you can view the same data as a grid, a calendar, a kanban board, or a form. If you've outgrown Google Sheets for tracking anything with real structure (a content calendar, a CRM, an inventory list) but don't want to learn a full database tool, this is the gap Airtable fills.

Step 1: Create your first base

A base is Airtable's word for a single workspace, roughly equivalent to a spreadsheet file. Click Create a base from your workspace home. Airtable starts you off with a default table and three blank sample records so you're not staring at an empty grid.

Step 2: Add fields and records

Each column is a field, and you choose its type when you create it: text, number, date, single-select, attachment, or a link to another table. Each row is a record. Click into any record to open it in an expanded card view, which is easier to work with than the grid once a row has more than a few fields.

Step 3: Set up views

The same table can be looked at in different ways without duplicating data:

• Grid — the default spreadsheet-style view
• Calendar — pulls from a date field automatically
• Kanban — groups records into columns by a single-select field, useful for a pipeline or task board
• Form — a shareable form that writes new records straight into the base

Views can also be locked down: a Collaborative view's filters and sorting are shared with everyone, a Personal view is yours alone, and a Locked view can't be changed by anyone below Creator or Owner permission.

Step 4: Automate the repetitive parts

Every automation needs a trigger and at least one action. Go to Automations in the left sidebar, click Create automation, then add a trigger (for example, "when a record enters a view") followed by an action (send a Slack message, create a record in another table, send an email). Test it against a real record before switching the toggle from OFF to ON.

Where the free plan actually runs out

Airtable's free tier is genuinely usable for a small team, but you'll hit its limits the moment a base grows past a couple hundred records or you need more than a light automation or two per month. That's normal for a tool at this price point, not a complaint specific to Airtable, but budget for a paid tier if you're planning to run something business-critical through it.

Frequently asked questions

Is Airtable free to use?

Yes, there's a free plan with a per-base record cap and limited automation runs. Paid plans remove those caps and add more advanced field types and permissions.

Can I import an existing spreadsheet into Airtable?

Yes, Airtable can import directly from a CSV file or a connected Google Sheet, mapping your existing columns to Airtable fields during setup.

Do I need to know how to code to use automations?

No. Most triggers and actions are configured through dropdown menus. A scripting action exists for advanced cases, but it's optional, not required to get value from automations.