Create and Manage Tables
Adding Tables
In a base, click the+ button in the directory and choose to:
- Create a new blank table
- Import from a CSV file
- Import from an Excel file
- Import from Airtable, if Airtable integration is configured
Renaming & Deleting
- Rename: Double-click the table name in the directory, edit it, then click anywhere outside to save.
- Delete: Hover over the table in the directory, click
..., then select Delete.
Trash
Click the trash icon in the upper left of the base to manage deleted tables.
- Restore: Bring the table back to the base with all data intact
- Empty trash: Permanently delete all trashed tables
Design Tables
Click Design in the table menu to view the table’s basic properties:
| Property | Description |
|---|---|
| id | Field ID |
| name | Field name |
| dbFieldName | Field name in the physical database |
| type | Field type |
| description | Field description |
| graph | View current field dependencies |
| cellValueType | Current field value type |
| isLookup | Whether it’s a field looked up from a linked table |
| isMultipleCellValue | Whether it’s an array value field |
| isComputed | Whether it’s a computed field (record values of computed fields cannot be modified) |
| isPending | Whether it’s in calculation |
| hasError | Whether there are calculation errors |
| notNull | Whether non-null validation is enabled |
| unique | Whether unique value validation is enabled |
Share and Access Tables
Share a Table
In a table, click Share in the upper-right corner, switch to Share table, and turn on Share to web to generate a share link.
After table sharing is enabled, the Share button appears in a gray shared state in every view in that table. This state comes from table sharing; it does not mean each view has been shared separately.
- Can view: Anyone with the link can view table data
- Can edit: Logged-in users can edit records in the shared table
- Can save as copy: Anyone with the link can save a copy to their space
Ways to Access Tables
Tables default to a Grid view and are also accessible via the API. You can create additional views — such as Kanban — to suit different workflow needs.Search and Downloads
Global Search
- Date fields can be searched in addition to text fields — search a date value to find matching records
- When hiding non-matching rows, the visible result set narrows to matching records only
Attachment Downloads
Bulk attachment downloads respect the current search results and include only attachments from matching records.
FAQ
Why can't I enter text in a Number column?
Why can't I enter text in a Number column?
Teable is stricter than Excel — each column has a fixed data type, and a Number column only stores numbers. This constraint ensures data integrity and is the foundation for advanced filtering and automation. See Teable vs Excel for details.
What should I check before deleting a table?
What should I check before deleting a table?
Check whether the table is referenced by linked fields in other tables. Deleting the source table may cause data display issues in linked tables.