Prepare for import
1. Clean your tabs
Each tab should contain one type of information and should have uniform rows and columns throughout.
2. Create consistent columns
Each column should be holding the same type of information for all of the rows in your sheet.
3. Add a header row
Your sheet should contain headers in the first row with the name of each column captured in the header.
Three ways to import
Create a new base from import
Click the new base icon, select “Import Data”, then select “CSV file”, find your file, and import.
Import a table into an existing base
Click the add table icon, select “Import Data”, then select “CSV file", find your file, and import.
Add new records or update records
Use the CSV Import App from the Apps marketplace (Pro and Enterprise plans only).
Spreadsheet = BaseEach spreadsheet is organized into its own spreadsheet file. In Airtable, each spreadsheet will become its own base.
Tabs = TablesSpreadsheets contain tabs for different data sets. In Airtable, each type of data is organized into its own table.
Rows = RecordsSpreadsheets contain rows of information. In Airtable, those are called records.
Columns = FieldsSpreadsheets contain columns of data. In Airtable, those are called fields, and there are dozens of field types to add formatting to your data.
Do more in Airtable
Views allows you to customize what information is displayed in a table. All the underlying content in the table will be the same, but how you see that information can differ depending on your needs.
Unlike a spreadsheet, Airtable fields (columns) have specific "types" that allow you to store rich content in each record. With all of these different field types, you can configure a table to perfectly fit your needs!
Apps allow you to extend the capabilities of a base. There are dozens of apps for you to choose from—like chart, page designer, matrix, org chart, — and many more to come!
Automations allow you to configure custom trigger-action workflows directly within your base. Save time by automating repetitive tasks, increasing efficiency, and reducing the margin of error.
One of the unique aspects of managing your information in a database is the power of linking records together across tables. Learn how you can put Airtable's linked records to work for you.