Airtable's copy and paste functions (C and V) are one of the simplest ways to duplicate your data and fields. To learn more about Airtable's other keyboard shortcuts, see this article.
Paste from an external source into Airtable
If you would like to append data from an external source (like Excel or Google Sheets) you can simply copy and paste (C and V) from the source to Airtable.
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.
Copy and paste within Airtable
You can copy data from one Airtable base and paste it into another. When you do, the pasted cells will generally create new fields of the same type as the original fields. 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 (e.g. count, lookup, and rollup) will be turned into single line text fields.