Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jul 21, 2020 06:58 AM
This was asked by another user, but closed without a response. What are workarounds, other than downloading/uploading a CSV, to copy a table structure from one base to another?
Jul 21, 2020 07:10 AM
Jul 21, 2020 07:31 AM
Welcome to the Airtable community!
One problem with using a CSV file or Integromat is that those methods only copy data, not field types.
If you want to copy field types as well, you can do a manual copy/paste into a blank table with only one column/field. Airtable will create the additional fields with most of the field types intact.
Jul 21, 2020 08:55 AM
This is SO helpful. Exactly what I needed. Thanks! (I actually modified your suggestion and copy/pasted a whole row - completely set up all the fields as pasted!)
Dory
Mar 26, 2024 10:38 PM
I'm not sure if syncing tables was around back when this question was posed, but this is a nice little hack that's now available:
Sync your table from the base you want to copy from to the new base (Share and Sync -> Sync Table to Another Base). Then remove the sync (Update Sync Configuration -> 3 dots -> Remove Source) and voila, all your fields and data are there in the new base.
You still need to update relevant fields to formula fields and copy/paste any formulas you had in the source base, but this only takes a sec and the great thing is, all other fields get generated.