Can you move a table to a different base?

Ask the community
#1

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

Thanks
Julie

2 Likes
#2

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.

  1. Export the table as a CSV, and then create new table in the target base via CSV upload

  2. Select the entire table (ctrl / cmd + A) and copy it (ctrl / cmd + C), then paste it (ctrl / cmd + 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ā€¦

4 Likes
How to move one table with all the views to another base?
Combining workspaces
#3

There are some threads already too: https://community.airtable.com/search?q=move%20table%20base

#4

Jeremy:

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.

Regards
Julie

#5

Elias:

Appreciate the references. It appears that this has come up before by another user.
Thanks
Julie

#6

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!

1 Like
#7

Youā€™re a lifesaver. I had so many files to transfer, and this was seamless

#8

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?

#9

@Laurence_Berg
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.

#10

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.

#11

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?

#12

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.

2 Likes
#13

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.

#14

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.

#15

Thanks for the ideas and advice.

#16

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

#17

ā€œ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.

#18

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

#19

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ā€!!!

#20

agreed, especially as theyā€™ve kept it free unexpectedly: