Can you move a table to a different base?

[Julie_Odita]

Hello:
Can you move a table to a different base?

Thanks
Julie

[Laurence_Berg]

I have a complication! In my new version, I have added new fields. Is there a best practice for this situation? I haven’t done a csv import before. Is it possible to align fields between the csv and an existing table in AT?

[ScottWorld]

I would use the brand new Sync feature, which will bring your table from another base into the current base. Then, you can disable syncing, and all the data will remain.

[Laurence_Berg]

Interesting idea. But I’ve already got a form view I’ve built in a new copy and I’ve already added fields to my new copy, and syncing creates a new table which I’d have to add all the new fields to and for which I’d have to recreate the form for. I wish I’d known about this idea before I started!
So, now I’m looking for an easy way to move the current data into the new base.

[ScottWorld]

Then I would just export and import.

If you need something more complex, you can always automate the process of moving data from one base to another with Integromat.

[Laurence_Berg]

Thanks for the ideas and advice.

[Eran_Bucai]

Super helpful just saved me hours of work for me or my VA!

[MAB941009]

“Hi all, I just did the copy table, paste method as suggested by OP. You no longer need to reselect all the field types. If you have data in the table you don’t need to re-add the value lists either!”

I want to echo and ellucidate @Dean_Arnold’s comment above.

For moving tables across bases, the best workflow is:

1. Press CTRL + A and CTRL + C on the desired table
2. At your desired base, in a new table press CTRL + V

Note that for Airtable tables, you needn’t utilise any of the import functions. When you import via Copy & Paste you lose the field type attributes.

[sandy_mohan]

Hi all - this does not carry over the comments and chat from the table. Any suggestion how to also carry that over?

[Mike_Sweat]

The best answer can be found here: How to move one table with all the views to another base?

The short answer is to “share view”!!!

[LW-SavvyIndie]

agreed, especially as they’ve kept it free unexpectedly:

Warner Writes – 27 May 21

Warner Writes

Quick #AirTable tip: Best way to duplicate table: Sync, then Unsync — it retains field type vs. CSV import converts all to ‘Long Text’ | + it’s Free forever (Apr ‘21 phase-out binned) — #SavvyIndie #tech