Tim Dietrich

Custom Software Developer

Home Services Portfolio Blog About Contact Newsletter

Airtable: Duplicating A Table

An Airtable user asked me if it is possible to duplicate a table. While it is possible to duplicate an entire base, duplicating a single table isn't a feature (at least not yet).

However, with a little work, it can be done. Here's how...

Navigate to a view that is based on the table that you want to duplicate. We're going to be exporting data from this view, so make sure that the view is configured to show the columns and records that you want to replicate in the new table.

Export the data as a CSV file. You can find this option by clicking the ellipses button in the view's toolbar. Once selected, the file will be downloaded to your computer.

Import the file back into Airtable as a new table. To do so, click the "+" button in the table toolbar, and select "Import a spreadsheet." The Import Spreadsheet dialog will open. Click the "Choose a .CSV file" and either select the file that you downloaded, or drag and drop it into the Filepicker window. Airtable will then create a new table (named "Imported Table") import the data into it.

When Airtable creates the new table, it will name the columns just as they were in the original table. However, the column types will be set to "Single line text." And that's the only catch with this technique: You'll need to manually adjust the column types as needed. To change a column's type, click on its header and choose "Configure."

Below are a few screenshots that show the steps involved with this technique. To view larger versions of the screenshots, simply click on them.

If you have any questions about this technique, please feel free to contact me.

Navigate to a view that is based on the table that you want to duplicate. Configure the view so that the columns and records that you want in the new table are displayed.

Export the data as a CSV file.

Create a new table in the base by choosing "Import a spreadsheet."

The Import Spreadsheet dialog will appear. Click the "Choose a .CSV File" button.

Either navigate to the downloaded CSV file, or drag and drop it on the dialog window.

A new table, named "Imported Table," will be created. Notice that the columns are configured as "Single line text."

To change a column's type, click the column header, and select "Configure." Here, I've changed the Price column to a Currency type.

To change the imported table's name, click on the table's name and select "Rename."