Oct 09, 2018 09:02 PM
Can you move a table to a different base?
Oct 09, 2018 11:46 PM
There’s no way to directly move a table to another base. But you can always copy a table to another base. There are a couple ways to do this.
Export the table as a CSV, and then create new table in the target base via CSV upload
Select the entire table (
A) and copy it (
C), then paste it (
V) into a new table in the target base
In both instances, however, you will have to re-create the Field Types for certain types of fields, such as Formulas, Linked Records, Lookups, etc…
Oct 10, 2018 04:01 AM
Oct 10, 2018 07:44 AM
Thanks for your response. I did end up doing option #2 last night, and recognized the limitation on the field types. It was still certainly better than re-keying all of that information.
Oct 10, 2018 07:46 AM
Appreciate the references. It appears that this has come up before by another user.
Apr 18, 2020 10:29 PM
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!
Sep 16, 2020 08:48 AM
You’re a lifesaver. I had so many files to transfer, and this was seamless
Sep 30, 2020 08:22 AM
Thanks for this. I would like to move all the data from one table to a table in another base so that the forms on the target table refer to the newly migrated data. Is that possible? It’s sort of like a dev to prod migration: I have a table in a base we have to retire and I’ve created a copy with a form view in a new base. I now want to move the data from the original table to the new table that has a form view.
Should I delete all the records in the target table and then paste in all the records from the original? Will that do it?
Sep 30, 2020 09:26 AM
I think it should do work just fine, if your new base matches the structure of the old base.
You can always make a copy of your new base and test this first.
Sep 30, 2020 10:04 AM
Thanks. I may have answered my own question as I was asking it.
What I’m doing is building a new production version with new features like the form view. So, I made a copy of the original and then started added stuff. The plan was to copy the original into the new base as a new table until I realized that the new form would not be linked to the even newer table. But, if i just replace the data in the new table, the form should still function as it does in the development mode.
Sep 30, 2020 02:54 PM
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?
Sep 30, 2020 03:26 PM
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.
Sep 30, 2020 08:08 PM
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.
Sep 30, 2020 08:27 PM
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.
Oct 01, 2020 04:19 AM
Thanks for the ideas and advice.
Jan 06, 2021 11:56 PM
Super helpful just saved me hours of work for me or my VA!
Jan 29, 2021 05:38 AM
“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:
CTRL + Aand
CTRL + Con the desired table
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.
Mar 01, 2021 07:13 AM
Hi all - this does not carry over the comments and chat from the table. Any suggestion how to also carry that over?
Mar 04, 2021 06:49 AM
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”!!!
May 27, 2021 08:18 AM
agreed, especially as they’ve kept it free unexpectedly: