Store data with Zapier Tables

Zapier Tables is a data storage solution built for automation.

Tables are composed of records (each row in a table) and fields (each column in a table). You can add records manually or automatically, using Zaps. 

Create a new table

You can create a new table at https://tables.zapier.com:

• Click Create blank table to start creating fields and inserting information. 
• To import existing data, click Create table from CSV file.

On this page, you can also view existing tables and ones that were shared with you. You can also access Tables from the left sidebar when logged into your Zapier account.

 

Bulk edit table records

When viewing a table, you can do the following bulk actions:

• Send pending records: sends any records with a “Pending” status to a Zap. If you select specific records,  the button will show the number of pending records to send.
• Hide fields: select which fields to hide from view. Tables will still send hidden content to Zaps. 
• Filter: select a field and rule to view only specific records.

You can find more actions by clicking the three dot icon.

• Ignore pending records: prevents current pending records from being sent to Zaps. If you select specific records, the button will show the number of pending records to ignore.
• Download all records: download all records as a CSV file.
• Download filtered records: this option appears when a filter is active. Download all visible records as a CSV file.
• Delete records: select specific records to delete them from the table. This action cannot be undone.

 

Add new fields

You can add new fields by clicking the plus sign  on the right side of a table.

Zapier Tables offer fields that allow you to format data, or interact with Zaps. Learn more about the different field types on tables.

 

After you create a new field, you can also create a Zap to interact with the information on that field. Learn more about triggering and continuing Zaps from Tables.

 

Reorder fields

You can reorder existing fields in a table by dragging and dropping them.

1. Click and hold the name of the field you want to move.
2. Drag it to the position you want to move it to. A blue line indicates the position where the field will be dropped.

 

Add new records

You can add new blank rows by clicking the plus sign at the bottom of a table.

 

Sort records

You can sort records by specific fields. If you use sorting, the values on that field will define the order in which records appear in a table. To sort records in a table:

1. Click the name of the field you want to sort by.
2. Select Sort ascending or Sort descending.

 

Delete a record or a field

To delete a record:

1. Click the checkbox to the left of the record you want to delete.
2. Click the three dot  icon at the top of the table.
3. Select Delete records. The option will reflect how many records are selected.

To delete a field:

1. Click the name of the field.
2. Click Delete field.

 

Delete a table

To delete a table: 

1. On the Tables page, click the three dot  icon next to the table you want to delete.
2. Click Delete.
3. Click Confirm to delete the table. 

You can also delete a table when viewing its contents.

1. Click Settings .
2. Scroll to the bottom of the Table Settings panel.
3. On the section Danger zone, click Delete this table.

 

Edit table settings

To edit the table's details, click Settings . The right sidebar will open, with the following options:

• Name: change the table's name.
• Description: change the table's description.
• Send records: change how records are sent to Zaps - manually or automatically. 
• Delete table: delete the entire table and its contents. This action cannot be undone.

Pending records

Once you use a table in a Zap, any new records that you manually add to or update in the table are set to “Pending” by default. This is to ensure records are only sent to Zaps when you are done creating or updating them. You can select one of the following options: 

• Pending (Default): records created manually will be marked as pending until you send them to your Zaps.
• Automatically: records created manually will be sent automatically to your Zaps.

Learn more about using Zaps with table records.

 

Share a table

You can create a public sharing link for your tables, to share them with others. If you have a Team or Company account, you can also share your tables directly with others in your Zapier account. 

 

Tables offer four different roles:

Role name	Permissions
Owner	The user who created the table. Edit fields, settings, records, and create Zaps.
Builder	Edit fields, settings, records, and create Zaps.
Editor	Create, edit, and delete records.
View only	View and export records.

 

To share a table:

1. In the top navigation of the table, click Share .
2. Click Create a link. This creates a public sharing link for that table.
   1. In the dropdown menu, select a permission setting.
   2. Click the Copy  icon to copy it to the clipboard.
3. If you're on a Team or Company account, you can also search for a user, team, or account by name. 
   1. In the dropdown menu, select a permission setting.
4. Click Close.

 

Connect Zaps to your table

You can connect a table to one or more Zaps. Any field in a table can be used to trigger or continue Zaps. You can also send all new records or all updated records to a Zap.

Learn more about triggering and continuing Zaps from table records.

 

Usage limits

Field-related limits

 

Table fields have specific limits on the amount of data they can store. 

Field type	Limit
Text	255 characters
Long Text	10,000 characters
Decimal	7 decimal digits

 

Learn more about table field types.

 

Plan-related limits

Depending on your plan type, Tables have different limits. 

 

Tables in an account

Plan	Limit
Free	10
Paid	20

 

Records in a table

Plan	Limit
Free	2,000
Paid	5,000

 

Fields in a table

Plan	Limit
Free	25
Paid	25

 

Tables can interact with Zaps in many ways. Find out more about using Zaps with tables.