Import data into Zapier Tables

With Zapier Tables, you can import your data to a new table from a CSV file, or append the content of a CSV to an existing table.

 

Limitations

Your CSV file must be:

  • UTF-8 encoded.
  • Smaller than 50 MB.
  • Within the limit of records and fields of your Tables plan. The importing process will ignore any records or fields beyond the limit of your plan.

 

Import data into a new table

To import data into a table:

  1. On your Tables dashboard, click Create. 
  2. Click Import data.
  3. Click Choose File to select the file from your computer.
  4. You'll see a preview of the records that will be imported. If you want to change a field's type, click the name of the field and select a different type from the dropdown menu.
  5. Click Continue importing.
Note

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

 

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. On the top right, 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. 
  5. 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 the column header dropdown to change which field a column will be added to.
  6. Click Continue importing.

The Preview data screen is shown, with one of the column header dropdowns clicked open to show how you can change the field a column will be added to

 

Note

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

Data retention

Zapier's Data Retention, deletion, and export practices vary depending on the product. Learn more about the specific guidelines for the product you're using.

Was this article helpful?
6 out of 12 found this helpful