Airtable Base Import Guide

How to set up each template base in your Airtable workspace, import seed data, and configure automations.

Prerequisites

• An Airtable account (free tier works for most templates)
• This template pack downloaded and unzipped
• 10–15 minutes per base for initial setup

Step 1: Create a New Base

1. Open airtable.com and go to your workspace

2. Click "+ Add a base" → "Start from scratch"

3. Name the base to match the template (e.g., "CRM", "Project Tracker", "Inventory Management")

4. Delete the default table — you'll create tables from the schema

Step 2: Understand the Schema Files

Each schema file in schemas/ defines the complete structure of one base. Here's how to read them:

schemas/01-crm.json
├── tables[]
│   ├── name: "Contacts"
│   ├── fields[]
│   │   ├── name: "Email"
│   │   ├── type: "email"
│   │   └── description: "Primary contact email"
│   └── views[]
│       ├── name: "All Contacts"
│       └── type: "grid"

Field type mapping — Airtable field types used in schemas:

Step 3: Create Tables and Fields

For each table in the schema file:

1. Create the table: Click "+" next to your last table tab

2. Rename the default field: The first field is always the primary field — rename it to match the schema's first field

3. Add fields in order: Click "+" at the end of the field headers

• Select the correct field type
• Set the field name exactly as specified
• Configure options (for select fields, add each option listed in the schema)
• Add the description from the schema (click the field header → "Edit field" → "Add a description")

4. Set up linked record fields: These create relationships between tables

• Choose "Link to another record"
• Select the target table
• Airtable automatically creates the reciprocal link in the target table

5. Create views: After all fields are set up, create the views listed in the schema

• Grid views: Apply filters and sorts as described
• Kanban views: Choose the grouping field (usually a Status or Stage field)
• Calendar views: Choose the date field
• Gallery views: Choose the cover field

Pro Tips for Faster Setup

• Duplicate similar fields: Right-click a field header → "Duplicate field", then adjust the name and options
• Batch-create select options: When setting up a single-select field, paste all options at once (one per line)
• Use field descriptions: They show up as tooltips when hovering over field headers — very helpful for team members

Step 4: Import Seed Data

Seed data CSVs are in the seed-data/ folder. Each CSV corresponds to one table in a base.

CSV-to-Base Mapping

Import Process

1. Open the target table in your base

2. Click the down arrow next to the table name → "Import data" → "CSV file"

3. Select the matching CSV file

4. Airtable will preview the import — verify:

• Column headers match your field names
• Data types are detected correctly
• No encoding issues with special characters

5. Click "Import"

Post-Import Cleanup

After importing, you may need to:

• Fix field types: CSV imports sometimes create text fields instead of select fields. Convert them:
• Click the field header → "Customize field type"
• Change from "Single line text" to "Single select"
• Airtable will auto-create options from existing values

• Re-link records: CSV imports can't create linked records automatically. To link records:

1. Make sure both tables exist with data

2. Create the linked record field in the source table

3. Manually link the first few records, or use Airtable's "Suggested links" feature

• Recalculate formulas: Formula fields will auto-calculate once the source fields have data

• Verify select options: Imported select values may need their colors assigned. Click any option to set a color

Step 5: Configure Automations

See automations/automation-blueprints.md for step-by-step automation setup instructions for each base.

Quick reference for the most common automations:

Step 6: Invite Your Team

1. Click "Share" in the top-right of the base

2. Choose permission level:

• Creator: Can modify schema (fields, tables, views)
• Editor: Can add/edit records but not change schema
• Commenter: Can view and comment only
• Read only: View access only

3. Send invite link or enter email addresses

Troubleshooting

"Field type mismatch" on import

The CSV has values that don't match the field type. Fix: Import as text first, then convert the field type afterward.

Linked records not connecting

Linked record fields require both tables to exist first. Create all tables before setting up links, then import data.

Formula fields showing errors

Formulas depend on other fields existing and having data. Verify the referenced fields exist with the exact names used in the formula.

Select field options not matching

Option names are case-sensitive. "In Progress" and "in progress" are different options. Standardize casing before import.

Base exceeds free tier limits

Free Airtable accounts allow 1,200 records per base and 2GB attachments. The seed data CSVs are well within this limit, but your production data may not be. Consider Airtable Plus or Pro for larger datasets.

Recommended Setup Order

If you're setting up multiple bases, this order minimizes rework:

1. CRM (standalone, no dependencies)

2. Project Tracker (standalone)

3. Inventory Management (standalone)

4. Content Calendar (standalone, or link to CRM contacts as authors)

5. Hiring Pipeline (standalone)

6. Expense Tracker (standalone, or link to Project Tracker for project-based expenses)

7. Product Roadmap (optionally link to Project Tracker)

8. Customer Feedback (optionally link to CRM)

9. Event Planner (standalone)

10. Knowledge Base (standalone, benefits from all other bases being populated)

*Need help? Contact [email protected]*