If you would like to append data from Excel or Google Sheets into an existing table in an Airtable base, you can simply copy and paste (C and V).

Note: Make sure that the order of the columns in the original spreadsheet matches the order of the columns in the destination Airtable base! Otherwise, your data will be placed in the wrong fields.

Using copy and paste within Airtable

If you copy data from one Airtable base and paste it into another Airtable base (C and V), the pasted cells will generally create new fields of the same type as the original cells. The exceptions are as follows:

Foreign keys from a linked record field will be treated as plain text and put into a single line text field.

A formula field, when pasted into another table, will not create a formula field, but will instead create a relevant field based on the output type of the original formula, e.g., a formula field with text output will be turned into a single line text field, a formula field with numerical output will be turned into a number field.

Any computed fields relying on linked record fields (i.e. count, lookup, rollup) will be turned into single line text fields.