Appending data to an existing table with copy and paste
  • 04 Jul 2022
  • 1 Minute to read
  • Dark
    Light

Appending data to an existing table with copy and paste

  • Dark
    Light

Airtable's copy and paste functions (CtrlCand CtrlV) 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 (CtrlCand CtrlV ) from the source to Airtable.

360096711313pastefromexternal.gif

your title goes here

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 using the same keyboard command, (CtrlCand CtrlV). 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.

Was this article helpful?