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.
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
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
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
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
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
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
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
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