Import data into Zapier Tables

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

Limitations

For CSV files:

• UTF-8 encoded.
• Smaller than 50 MB.

For all sources:

• The content of the file must be 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 the Tables home, click Import data. A dialog box will open.
2. Select CSV to upload a file, or select the app you want to import data from.

Import from CSV

1. Click Choose File to select the file from your computer or drag and drop a file into the window.
2. Click Continue.
3. You'll see a preview of the records that will be imported. To change a field's type, click the name of the field and select a different type from the dropdown menu.
4. Click Continue importing to see your new table.

Note

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

Import from an app

Once you select an app, the dialog box will show all existing connections to that app. 

1. If you don't have any connections, click + Sign in to <name of the app>. A new tab or window will open where you can create a new connection.
2. In the new tab or window, click + Add connection. Follow the onscreen instructions.
3. Once your connection is ready, go back to the Zapier Tables tab or window on your browser.
   • If the connection doesn't appear, refresh the browser tab or window.
4. Select the connection.
5. Click Continue.
6. Fill out the required fields.
7. Click Next. You'll see a preview of the content to be imported.
8. Select the checkbox beside the fields you want to import. 
   • You can also click Select all, to import all fields.
9. Click Import data to see your new table.

Import data into an existing table

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

1. On the Tables home, select your table. 
2. At the bottom of the table, click  Import. A dialog box will open.
3. Click Choose File to select the file from your computer. 
4. You'll see a preview of the records that will be imported. 
   • Click a field's dropdown menu to change which field the content will be sent to.
5. Click Continue importing. The new records will be added to the bottom of the table.

Note

Depending on the size of your file, the full content may take a few seconds 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.