Skip to main content
Import CSV files and Excel sheets directly into your Airtable.
1

Select Airtable as the destination

Select Airtable as the destination type.
2

Connect your Airtable

Connect your Airtable by providing the credentials.
Steps to get the Airtable API Key are described here. Steps to get the Base ID are described here.
3

Set the target table

Specify the table name where you want the data to be pushed.
4

Map columns

Map the sheet columns to the Airtable table columns. You can also map custom attributes to table columns.
Your users’ CSV data is then appended directly to the Airtable table.
The data fields from Airtable are available in the Map Column modal only if they have data in the first row. Add dummy data for each data field in the first row so that they appear in the Map Column modal.

​
Operations

There are 2 operations available for Airtable.

​
1. Insert

Creates a new row in the table.

​
2. Upsert

Updates an existing row if a specified value already exists in the table, and inserts a new row if it doesn’t. Select the column to check for uniqueness in the Column Mapping popup.
Select the unique column for an Airtable upsert
  • If zero matches are found, a new row is created.
  • If one match is found, that row is updated.
  • If multiple matches are found, the request fails.