Duplicate Airtable Table ( fields) to Different Base

image

I WIN! NOT YOU (code/software/etc), ME! I WIN! IT’S ALL I DO!!!

Please forgive my exuberance, it’s how I celebrate after hours of toiling away trying to get something to work. This seems simple enough, but after avoiding figuring this out for months I finally decided to give it a go on a Saturday morning. Just spent another 2 hours completely perplexed, much like @Jarret_Cassaniti above.

For anyone still struggling to figure this out, here is the workflow at last!

  1. Go to the table you want to copy and select “Grid View”.
  2. Remove any Group filters you have in place so you see all of the data in list like a traditional spreadsheet.
  3. Click anywhere on the Table. It doesn’t matter if you click a Column, click into a Cell, or in the gray space off to the side.
  4. Press Command+A (Mac) or Windows+A (PC) on your keyboard. All of the columns and rows are now a highlighted light blue.
  5. Press Command+C (Mac) or Windows+C (PC) on your keyboard. You have now copied all of the rows AND the structured data for each column.
  6. Click the Airtable “Go home” logo at the top left of your screen.
  7. Click the base where you want to duplicate the table.
  8. Click the “(+)” plus sign icon next to “SHARE” at the top-right of the first Table you see in the Base.
  9. Select “Create empty table”.
  10. Give your Table a name or press Enter to use the generic Table name assigned by Airtable.
  11. Right-click the Attachments column and select “Delete field” at the bottom list.
  12. Right-click the Notes column and select “Delete field” at the bottom of the list… You are now only left with the Name column and three rows.
  13. Click the checkbox next to each of the three rows.
  14. Right-click and select “Delete all selected records”.
  15. Click the (+) plus sign to add a new row. You will now see the blinking | line icon indicating you can now add information to the cell.
  16. Press Command+V (Mac) or Windows+V (PC) on your keyboard.
  17. Cry tears of joy because you now know how to fully duplicate a table in a different base!

Only deleting the columns didn’t do the trick for me, but h/t to @James_Samuel for that advice. Once I deleted all columns AND rows, it worked like a charm.

Hope this helps save at least one poor soul from the torture of having to piecing this together without step-by-step instructions. Airtable, if you’re listening, please add this to your documentation!

Cheers y’all!

James