Get to know Airtable

Databases are the beating heart of almost every app business app. CRMs, project management apps, content management systems, accounting tools, and more are often a database with a form to enter data and ways to view it. You could make your own that worked exactly like you want—though if you're not a developer, making your own database powered app is daunting. They may only be a way to store lists of data, but cryptic SQL commands and outdated admin interfaces make databases feel like the domain of those willing to invest significant time.

And so, for simpler lists, we reach for spreadsheets, copying and pasting data from other sheets as necessary. It's not perfect, but it is simple.

Airtable's hybrid spreadsheet and database tool changes that. Similar to Microsoft Access on PCs, it's an incredibly simple way to make a relational database.

The basic difference between a database and a table is that most databases are *relational*—they let you easily pull in data from parts of a data table into other views. Airtable takes that a step further, letting you pull in data from other tables and view it in a card-like popover without needing to open that other table. You can include images, checkmarks, tags, formatted text descriptions, and more in your tables to make a visual database that looks and work just like you want.

Adding your data is as simple as using a spreadsheet. Type in text, drag in photos, add checkboxes for tasks, link files from Dropbox, notes from Evernote, and more, and organize everything in cells. List locations, say, in one table, then lodging options that are tagged to those locations in another, and you can view the relevant data without switching between tables. Bring in your whole team to collaborate, just as you would in Google Sheets—complete with comments and discussions on every individual piece of data.

Then, use filters and sorting to drill down and find what you need. Instead of searching for items you need each time, you can filter by checked off items, show only items with a specific category, and stack filters to look for multiple things at once. Once you've found the data you need, you can save it as a view to jump back in and see that set of data again anytime in a click.

If you already have an idea for the database you need, it's simple to turn it into a working tool for your team in Airtable. Or, you can start out with with an Airtable template, for a simple way to start an HR database, task management tool, product tracker, and more. Each comes with pre-written data, so you can get an idea for how the database should work and then replace it with your own data.

Airtable can also work with your own apps. Using Zapier integrations, you can connect an Airtable database to automatically send emails, log customers, and more. Or, you can use their API to build your own integrations and add extensions to do even more with your data.

Microsoft Access doesn't have to be the only way to make a simple database. Airtable gives you a modern way to organize data as a team online, one that's simple enough for anyone to use but powerful enough to organize any data you need.

Originally published February 1, 2016; updated June 6, 2018 with new features and screenshots

+

Do more with Airtable

Zapier allows you to instantly connect Airtable with 2,000+ apps to automate your work and find productivity super powers.

Connect to 2,000+ Apps

Gmail

Email +1

12 Integrations

Google Sheets

Google +1

16 Integrations

Slack

Team Chat

18 Integrations

Google Calendar

Calendar +1

12 Integrations

Trello

Project Management

36 Integrations

Google Drive

File Management & Storage +1

14 Integrations

Asana

Project Management

14 Integrations

Mailchimp

Email Newsletters

16 Integrations

Facebook Lead Ads

Ads & Conversion +2

JotForm

Forms & Surveys

Google Forms

Forms & Surveys +1

2 Integrations

Gravity Forms

Forms & Surveys +1

Dropbox

File Management & Storage

14 Integrations

Typeform

Forms & Surveys

Webflow

Website Builders

16 Integrations

Pipedrive

CRM (Customer Relationship Management)

26 Integrations

Shopify

eCommerce +1

18 Integrations

Calendly

Scheduling & Booking

Microsoft Outlook

Email +1

10 Integrations

Paperform

Forms & Surveys

Microsoft Office 365

Email +1

6 Integrations

Salesforce (Legacy)

CRM (Customer Relationship Management) +1

38 Integrations

Cognito Forms

Forms & Surveys

4 Integrations

Twilio

Phone & SMS

4 Integrations

QuickBooks Online

Accounting +1

40 Integrations

Google Docs

Documents +1

8 Integrations

Process Street

Product Management

4 Integrations

Acuity Scheduling

Scheduling & Booking

6 Integrations

ManyChat

Social Media Marketing

16 Integrations

Stripe

Payment Processing

8 Integrations

Evernote

Notes

10 Integrations

Google Contacts

Contact Management +1

10 Integrations

WordPress

Website Builders +1

4 Integrations

Wufoo

Forms & Surveys

4 Integrations

Formstack

Forms & Surveys

2 Integrations

HubSpot

Marketing Automation

34 Integrations

MySQL

Databases +1

4 Integrations

ActiveCampaign

Marketing Automation

20 Integrations

Twitter

Social Media Accounts

6 Integrations

Todoist

Task Management

14 Integrations

PostgreSQL

Databases +1

4 Integrations

Facebook Pages

Facebook +1

8 Integrations

Jira Software Server

Project Management

8 Integrations

Microsoft Excel

Microsoft +1

8 Integrations

Basecamp 3

Project Management

22 Integrations

Xero

Accounting +1

12 Integrations

HubSpot CRM (Legacy)

CRM (Customer Relationship Management)

10 Integrations

Eventbrite

Event Management

GitHub

Developer Tools

16 Integrations

Zendesk

Customer Support +1

18 Integrations

Buffer

Social Media Marketing

4 Integrations

Zoho Forms

Forms & Surveys +1

Pocket

Bookmark Managers

2 Integrations

SendGrid

Transactional Email

2 Integrations

Squarespace

Forms & Surveys

Close

CRM (Customer Relationship Management)

70 Integrations

ScheduleOnce

Scheduling & Booking

Intercom

Customer Support

20 Integrations

Formstack Documents

Documents

10 Integrations

Front

Email

12 Integrations

Wunderlist (To be shut down May 6, 2020)

Microsoft +1

8 Integrations

Jira Software Cloud

Project Management

8 Integrations

Box

File Management & Storage

14 Integrations

monday.com

Project Management

24 Integrations

Infusionsoft by Keap

Marketing Automation +1

16 Integrations

ClickFunnels

Marketing Automation

12 Integrations

Mailparser

Email

Streak

CRM (Customer Relationship Management)

24 Integrations

Reply

Marketing Automation

6 Integrations

Mailgun

Transactional Email

4 Integrations

SurveyMonkey

Forms & Surveys

4 Integrations

Toggl

Time Tracking Software

14 Integrations

Mandrill

Transactional Email

4 Integrations

RingCentral

Phone & SMS

6 Integrations

Zipwhip

Phone & SMS

4 Integrations

Mailjet

Email Newsletters

16 Integrations

Docparser

Documents

4 Integrations

Ninja Forms

Forms & Surveys +1

Copper

CRM (Customer Relationship Management)

38 Integrations

YouTube

Google +1

2 Integrations

PandaDoc

Documents

4 Integrations

Formsite

Forms & Surveys

ClickUp

Project Management

16 Integrations

Unbounce

Forms & Surveys

Drip

Drip Emails

12 Integrations

Google Cloud Print

Devices +1

4 Integrations

Landbot

Marketing Automation

PayPal

Payment Processing +1

Salesforce

CRM (Customer Relationship Management) +1

10 Integrations

Feedly

Social Media Accounts

6 Integrations

Hootsuite

Social Media Marketing

2 Integrations

Podio

Project Management

8 Integrations

Google Tasks

Google +1

6 Integrations

Harvest

Time Tracking Software

14 Integrations

ShipStation

eCommerce

2 Integrations

Google Slides

Documents +1

4 Integrations

Miro

Team Collaboration

6 Integrations

ClickSend SMS

Phone & SMS

22 Integrations

WPForms

Forms & Surveys +1

Woodpecker.co

Drip Emails

6 Integrations

SignRequest

Signatures

4 Integrations

SQL Server

Databases +1

4 Integrations

Contacts+

Contact Management

12 Integrations

OneDrive

File Management & Storage +1

6 Integrations

Microsoft Teams

Microsoft +1

4 Integrations

Teamwork Projects

Project Management

68 Integrations

SurveyGizmo

Forms & Surveys

Chargebee

Payment Processing

16 Integrations

Autopilot

Marketing Automation

8 Integrations

Help Scout

Customer Support

8 Integrations

PDFfiller

Documents

16 Integrations

DocuSign

Signatures

2 Integrations

LinkedIn

Microsoft +1

4 Integrations

Basecamp 2

Project Management

22 Integrations

Discord

Team Chat

8 Integrations

YouCanBook.Me

Scheduling & Booking

2 Integrations

Freshdesk

Customer Support

14 Integrations

Square

Payment Processing

2 Integrations

Firebase / Firestore

Databases

4 Integrations

Pinterest

Social Media Accounts

2 Integrations

CrazyCall

Phone & SMS

2 Integrations

FormKeep

Forms & Surveys

VBOUT

Marketing Automation

16 Integrations

Google Analytics

Ads & Conversion +1

6 Integrations

Smartsheet

Spreadsheets

30 Integrations

Kajabi

eCommerce

6 Integrations

Parseur

Documents

2 Integrations

ConvertKit

Drip Emails

10 Integrations

Spotify

Video & Audio

6 Integrations

Wrike

Project Management

8 Integrations

Wave

Accounting

8 Integrations

GitLab

Developer Tools

2 Integrations

Insightly

CRM (Customer Relationship Management)

18 Integrations

Bitly

URL Shortener

2 Integrations

Coda

Documents

8 Integrations

Instapage

Forms & Surveys

SignNow

Signatures

10 Integrations

HelloSign

Signatures

2 Integrations

Teachable

Online Courses

6 Integrations

Pipefy

Project Management

4 Integrations

MoonClerk

Payment Processing

Amazon S3

Amazon +2

6 Integrations

Zendesk Sell

CRM (Customer Relationship Management)

24 Integrations

Burst SMS

Phone & SMS

10 Integrations

Clearbit

Contact Management

Constant Contact

Email Newsletters

4 Integrations

Zoho Mail

Email +1

10 Integrations

Zoho CRM

CRM (Customer Relationship Management) +2

14 Integrations

POWr Form Builder

Forms & Surveys

Netlify

Website Builders

2 Integrations

Invoice Ninja

Proposal & Invoice Management

16 Integrations

FreshBooks New

Accounting

24 Integrations

Campaign Monitor

Email Newsletters

8 Integrations

MailerLite

Email Newsletters

6 Integrations

Docupilot

Documents

2 Integrations

TextMagic

Phone & SMS

18 Integrations

ProcessPlan

Product Management

10 Integrations

123FormBuilder

Forms & Surveys

Mailshake

Drip Emails

16 Integrations

Amazon Seller Central

Amazon +2

GoCanvas

Forms & Surveys

4 Integrations

HighLevel

Marketing Automation

12 Integrations

Rebrandly

URL Shortener

4 Integrations

Formidable Forms

Forms & Surveys +1

Clio

CRM (Customer Relationship Management)

32 Integrations

Meetup

Event Management

4 Integrations

Facebook Groups

Facebook +1

4 Integrations

Zoho Books

Accounting +1

8 Integrations

Thinkific

Online Courses

4 Integrations

iAuditor by SafetyCulture

Product Management

18 Integrations

OmniFocus

Task Management

2 Integrations

Clockify

Time Tracking Software

14 Integrations

Ontraport

Marketing Automation

2 Integrations

Things

Task Management

2 Integrations

Zoom

Video Conferencing

4 Integrations

LeadSimple

CRM (Customer Relationship Management)

10 Integrations

Databox

Dashboards

4 Integrations

CallRail

Call Tracking

Recurly

eCommerce +1

2 Integrations

Tumblr

Website Builders

12 Integrations

Sendinblue

Email Newsletters

2 Integrations

TextIt

Phone & SMS

2 Integrations

Azure DevOps

Developer Tools +1

6 Integrations

WooCommerce

eCommerce +1

20 Integrations

Frame.io

Team Collaboration

8 Integrations

Slybroadcast

Phone & SMS

4 Integrations

Klaviyo

Marketing Automation

6 Integrations

Adalo

App Builder +1

4 Integrations

Follow Up Boss

CRM (Customer Relationship Management)

24 Integrations

Postmark

Transactional Email

4 Integrations

Workable

HR Talent & Recruitment

4 Integrations

ServiceM8

Scheduling & Booking

4 Integrations

Device Magic

Forms & Surveys

2 Integrations

MongoDB

Databases

2 Integrations

AWeber

Email Newsletters

6 Integrations

OneNote

Microsoft +1

10 Integrations

Zoho Creator

Databases +1

2 Integrations

Pushover

Notifications

4 Integrations

Strava

Fitness

2 Integrations

Chatfuel

Social Media Marketing

14 Integrations

Submittable

Forms & Surveys

FreshBooks Classic

Accounting

22 Integrations

Enalyzer

Forms & Surveys

2 Integrations

TalentLMS

Online Courses

10 Integrations

Magento

eCommerce +1

10 Integrations

Dubsado

CRM (Customer Relationship Management)

2 Integrations

Quip

Documents

8 Integrations

Wix Automations

Beta +1

Contentful

Website Builders

6 Integrations

Facebook Messenger

Facebook +1

2 Integrations

SimpleTexting

Phone & SMS

8 Integrations

Kartra

Marketing Automation

36 Integrations

Qualtrics

Forms & Surveys

6 Integrations

Book Like A Boss

Scheduling & Booking

Affinity

CRM (Customer Relationship Management)

18 Integrations

eBay

eCommerce

2 Integrations

Drift

Customer Support

6 Integrations

Evernote Business

Notes +1

10 Integrations

Survey Anyplace

Forms & Surveys

2 Integrations

Dasheroo

Dashboards

2 Integrations

Chargify

Payment Processing +1

Zoho Invoice

Proposal & Invoice Management +1

6 Integrations

Planview LeanKit (Legacy)

Product Management

16 Integrations

Hunter

Contact Management

2 Integrations

Heymarket SMS

Phone & SMS

8 Integrations

BambooHR

HR Talent & Recruitment +1

10 Integrations

Klipfolio

Dashboards

6 Integrations

Microsoft Exchange

Email +1

10 Integrations

Fulcrum

Forms & Surveys

Google Groups

Google +2

6 Integrations

Agile CRM

CRM (Customer Relationship Management)

22 Integrations

Cloudbeds

Scheduling & Booking

Pivotal Tracker

Project Management

4 Integrations

GetResponse

Email Newsletters

8 Integrations

Magento 2.X

eCommerce +1

10 Integrations

Donorbox

Fundraising

Vimeo

Video & Audio

2 Integrations

Microsoft To-Do

Microsoft +1

4 Integrations

Cloudinary

Developer Tools

8 Integrations

Cloze

CRM (Customer Relationship Management)

14 Integrations

Delighted

Forms & Surveys

2 Integrations

Leadpages

Forms & Surveys

Apify

Developer Tools

6 Integrations

WaiverForever

Documents

2 Integrations

Rev

Transcription

6 Integrations

Quotient

Proposal & Invoice Management

4 Integrations

SignUpGenius

CRM (Customer Relationship Management)

4 Integrations

Amazon DynamoDB

Amazon +2

2 Integrations

Mighty Networks

Website Builders

12 Integrations

SamCart

eCommerce

1 of 84

Screenshots

Airtable Pricing

  • Free for unlimited bases with up to 1.2k rows and 2Gb attachments per base

  • $12/month per user Plus plan for unlimited bases with up to 5k rows and 5Gb attachments per base

  • $24/month per user Pro plan for unlimited bases with up to 50k rows and 20Gb attachments per base, with priority support

  • Enterprise pricing available

17% discount with annual plan

Airtable Features

  • Log data in spreadsheet-style lists with database-like fields

  • Include file attachments, images, checklists, and links to other Airtable data

  • Comments to collaborate on data with your team

  • Filter data with views

  • Add data easily with built-in form builder

  • iOS and Android apps available

Airtable Alternatives

SEE ALL

Google Sheets

Google +1

Smartsheet

Spreadsheets

Knack

Databases

Zoho Creator

Databases +1

Airtable Updates

Airtable Update: Find Existing Records and Update Them

Carlin Sack · September 23, 2016

UPDATE

Organize Data From Any App With Airtable and Zapier

Alison Groves · August 11, 2015

UPDATE

Connect the apps you use every day

Get started with a Free account

Sign Up With GoogleSign Up With Facebook

OR

Work Emailrequired

Sign Up With Email

By signing up, you agree to Zapier’s Terms of Service

PricingHelpDeveloper PlatformPressJobsZapier for Companiesmakes you happier :)Follow us© 2020 Zapier Inc.TermsPrivacyBrand