How to Import Records from one Airtable Base to Another

Dec 1, 2022Rosie Threlfall

If you are working with multiple Airtable bases, you may find it necessary to copy records from one base to another. In this easy to follow tutorial, we'll show you how to easily achieve this.

To import this data, we'll be using Data Fetcher, an Airtable extension that allows you to easily import data to and from Airtable.

Create Output Base and Table

If you don't already have one, create a new Airtable base and output table for your records to be transferred into.

Install Data Fetcher

Add Data Fetcher to this base from the Airtable marketplace. Data Fetcher lets your import data from other Airtable bases, and dozens of other data sources, for free. Enter a password and click 'Sign up for free' or click 'Continue with Google'. Signing up for an account keeps your details secure. It's separate from your Airtable account.

Group 1Data Fetcher Sign Up .png

Import Records from One Airtable Base to Another

On the home screen of the Data Fetcher extension, click 'Create your first request'. Requests in Data Fetcher are how you import data to and from applications or APIs into Airtable.

click-create-your-first-request.png

On the create request screen in Data Fetcher, for Application, select 'Airtable'.

airtable1.png

Under Authorization, click 'Authorize'.

airtable authorization section authorize button.png

You will be taken to a new tab/window where you need to authorize Data Fetcher to access your Airtable account. Add the bases you want Data Fetcher to have access to. We recommend selecting 'All current and future bases in all current and future workspaces' to avoid any unauthorized issues in the future.

airtable oauth screen all current future bases.png

For Endpoint, select 'Import all records from a table'.

airtable3.png

Give your request a name and click 'Save & Continue'.

import airtable records save and continue.png

For Base, choose the Airtable base you want to import records from.

airtable4.png

For Table choose the table you wish to import records from.

airtable5.png

If you want to, you can import records from just one Airtable View. (This step is optional.)

airtable6.png

For Output Table & View, select the Airtable Table & View you want to import the data into.

airtable8.png

Click 'Save & Run'.

airtable9.png

Data Fetcher will run the request and the Response field mapping window will open. This is where you can set specific fields to import from one base to another. For any field, you can set whether to map to an existing field or create a new one and choose which field type to create. 

You can use the 'Deselect all' button to clear the pre-selected fields, then use the 'Find field' search bar to find the fields you would like to import. For this example, we will select the following fields to import: 'Record id', 'Post topic', 'Copy', 'Status', 'Channels' (mapped to a multiple select field) and 'Date'.

If you want to make sure any changes are always synced correctly when the Data Fetcher request is run, you can use any unique field in your table to achieve this. 'Record id' is a unique field, as no two Record ids will be the same.

Click the sidebar icon in the top-left to open the settings sidebar.

open sidebar settings icon response field mapping.png

Click 'Advanced settings' to open the advanced request settings.

For the Update Based on Field(s), select the 'Record id' field.

import airtable records update based on field.png

Once you are happy with the mapping, click 'Save & Run'.

import airtable records response field mapping.png

You'll now see these records have been imported from one Airtable base into another.

airtable records imported from another base.png

Automatically Import Records from One Airtable Base to Another

Currently, you'd need to manually run the Data Fetcher request every time you wanted to import any new records from one Airtable base to another. With Data Fetcher's paid version, you can schedule a request to run at regular intervals. To upgrade your account, In Data Fetcher, scroll to Schedule and click 'Upgrade'.

schedule1.jpg

Choose a plan from the different options and enter your payment details.

data fetcher upgrade pricing plans.png

Back in Data Fetcher, click 'I've done this'.

schedule2.jpg

Under Schedule, switch on Schedule this request.

Select a schedule based on intervals of 'Minutes', 'Hours', 'Days' or 'Months', then Click 'Save'.

Now, any new records created will be imported into your other Airtable base automatically on your chosen schedule.

schedule-a-sequence-intervals.png

Other Recent Posts

How to Look Up Data in Airtable When a New Record is Created

How to Look Up Data in Airtable When a New Record is Created

Mar 2, 2024

Andy Cloke

No-CodeAirtable
How to Sync Pipedrive Data to Airtable Automatically

How to Sync Pipedrive Data to Airtable Automatically

Feb 13, 2024

Andy Cloke

Pipedrive