Skip to content
Import Airtable to Coda
Share
Explore

Import from Airtable to Coda

How to bring over your Airtable database into Coda

Video Guide

www.loom.com
Click to enable


Step by step guide


1. In Airtable, convert the multi-select column to be a "lookup" column that links to another table. Go e column options > Customize Field Type > Link to Another Record. Since there is no table associated with that column (Description column in this example) yet, you'll need to
Create a new table.

image.png
image.png


2. Now that there are two tables (Elements and Description in this example), download both as a CSV by clicking the ... option on the far right and
Download CSV.

image.png


3. Import into Coda through drag and drop of the CSV or the
. The Airtable CSV export has column names, so make sure to mark that option before importing.

image.png


3. Rename the tables in Coda to what you called them in Airtable. In this example, Elements and Description.

image.png



4. Change the connecting column (in this example Description) from a Text to a
type. Have the Lookup reference the second table (Description).

image.png


5. If Airtable was a multi-select column, change the Lookup options in Coda to
Allow Multiple Selections
values (in this case, a Tree can be Green and Woody, two values from the Description table).

image.png



6. Now we'll get the second table (Description) to connect to the values in the first table (Elements) through copy and paste. Select all of the values in the column by clicking on the column header. Copy all the values (control/ cmd + c) in the Lookup column (Description) and paste them (control/ cmd + v) in the same place (no need to move your cursor). The act of copy and pasting auto converts the comma separated values to multiple references to the second table (Description table).

Screen Recording 2020-02-12 at 10.00 AM.gif










Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.