Import data into Zapier Tables

With Zapier Tables, you can import data from different sources, such as a CSV file or Google Sheets, and append data to existing tables.

Import data into a new table

From a CSV file From Airtable From Google Sheets

Your CSV file must be:

• UTF-8 encoded.
• Smaller than 5 MB.
• Within the limit of records and fields of your Tables plan. 

1. On your Tables dashboard, click Create. 
2. Click Import data.
3. In the dialog box, select CSV.
4. Click Choose File to select the file from your computer.
5. Click Continue.
6. You'll see a preview of the records that will be imported. 
7. (Optional) Enter a name in the Table Name field.
8. (Optional) Enter a description for your table in the Description field to add context.
9. Click Import.

Note

Depending on the size of your file, it may take a few seconds for the full content to appear.

1. On your Tables dashboard, click Create. 
2. Click Import data.
3. In the dialog box, select Airtable.
4. A new dialog box will open. Select an existing connection or click Connect a new account.
5. On the Base field, select a base from the dropdown menu.
6. On the Table field, select the table to import.
   • You can select a specific view on the field Limit to View. 
   • Select True on the field Include file contents? to create an extra File field with file contents. Maximum file size is 100MB.
7. Click Next.
8. Select the checkbox next to each field you want to import, or select Select all to include all fields.
9. Click Import.

Note

• Depending on the size of your file, it may take a few seconds for the full content to appear.
• All fields will be imported as longtext fields.

1. On your Tables dashboard, click Create. 
2. Click Import data.
3. In the dialog box, select Google Sheets.
4. A new dialog box will open. Select an existing connection or click Connect a new account.
5. Select your personal Google Drive or a shared Google Drive. If nothing is selected, Tables will use your personal Google Drive.
6. Select a spreadsheet from the dropdown menu. The screen may reload once you select your spreadsheet.
7. Select a worksheet.
8. Click Next.
9. Select the checkbox next to each field you want to import, or select Select all to include all fields.
10. Click Import.

Note

• Depending on the size of your file, it may take a few seconds for the full content to appear.
• All fields will be imported as long text fields.

Import data to an existing table

You can import new records to an existing table from a file:

1. From the Tables dashboard, select your table.
2. In the top left, click the three dot icon .
3. In the dropdown menu, click Import records. 
4. In the dialog box, click Choose File to select the file from your computer. 
   • You can import records from CSV, TXT, JSON, HTML, or PDF files.
5. Click Continue.
6. You'll see a preview of the records that will be imported. To prevent importing specific records, clear the checkbox next to the record. 
   • Click Edit column mapping to change the field where the content of a column will be added.
   • If you change any column mappings, click the back arrow in the dialog box to see the updated mapping.
   • Currently, only text and long text fields in an existing table will be filled when importing records.
7. Click Import records.

Note

Depending on the size of your file, it may take a few seconds for the full content to appear.