Change a field's data type on Zapier Tables
- Tables
-
Product updates
Product updates: January 2023 Product updates: March 2023 Product updates: February 2023 Product updates: April 2023 Product updates: May 2023 Product updates: June 2023 Product updates: July 2023 Product updates: August 2023 Product updates: September 2023 Product updates: October 2023 Product updates: November 2023 Product updates: December 2023 Product updates: January 2024 Product updates: February 2024 Product updates: March 2024 Product updates: April 2024 Product updates: May 2024 Product updates: June 2024 Product updates: July 2024 Product updates: August 2024 Product updates: September 2024 Product updates: October 2024 Product updates: November 2024 Product updates: December 2024 Product updates: January 2025 Product updates: February 2025 Product updates: March 2025 Product updates: April 2025 Product updates: May 2025 Product updates: June 2025 Product updates: July 2025 Product updates: August 2025
- Zaps
- Your Zapier account
- Interfaces
- Canvas
- Chatbots
- Getting started
- Agents
- MCP
- Built-in tools
- Lead Router
- Apps
Table of Contents
In Zapier Tables, the field type defines the data format used in a specific field, such as email or number formats. Not all field types can be converted to another field type.
Change the field type
- From your Tables home, click the name of your table.
- Click the header of the field you want to change.
- Click Edit field. A sidebar will open.
- Click the Field Type field to open the dropdown menu.
- Select a new field type.
Possible field type conversions
If the field you want to change uses one of the field types in the list below, it can be changed into any of the other types on this list:
- Text
- Long Text
- Checkbox
- Number
- Phone Number
- Date & Time
- Currency
Some conversions may warn you that changing the field type may invalidate some values. If you change the field type, review your table’s records afterward.
Field types that cannot be changed
You cannot convert these field types to any other field type:
- Dropdown
- Link
- Button
- JSON
- AI Field
You can set dropdown fields to allow a single or multiple selections. If you mark the Allow multiple selections checkbox, you cannot change it back to a single selection afterward.