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!
- Go to the table you want to copy and select “Grid View”.
- Remove any Group filters you have in place so you see all of the data in list like a traditional spreadsheet.
- 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.
- Press Command+A (Mac) or Windows+A (PC) on your keyboard. All of the columns and rows are now a highlighted light blue.
- 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.
- Click the Airtable “Go home” logo at the top left of your screen.
- Click the base where you want to duplicate the table.
- Click the “(+)” plus sign icon next to “SHARE” at the top-right of the first Table you see in the Base.
- Select “Create empty table”.
- Give your Table a name or press Enter to use the generic Table name assigned by Airtable.
- Right-click the Attachments column and select “Delete field” at the bottom list.
- 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.
- Click the checkbox next to each of the three rows.
- Right-click and select “Delete all selected records”.
- 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.
- Press Command+V (Mac) or Windows+V (PC) on your keyboard.
- 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