Changing Data Types

  • Updated goes beyond text and numbers with support for over 25 rich data types that you can choose from at the column, cell, and range of cells level. Each cell or column has a defined data type that you can change at any time. You can override column data types with cell and range data types—so you can put any data, literally anywhere you want. Owners and Managers of workbooks can change data types at any time.

How to Change Data Type

In, you can set data types at three levels: for Columns, a Cell, or a Range of Cells.

To change the data type of a column, cell, or range of cells, first select the column, cell, or range you would like to change, right-click, then select Edit data type... An Update column dialog box will appear. For columns, you can also click the column options dropdown, double click on the column header, or select Data type from the Format menu to open the Update column dialog box.

The animation below demonstrates all four ways to navigate to the Update dialog box for a column.


 From here, you can set the Data Type of the column, cell, or range of cells and the corresponding settings for each data type. The information tooltip will help explain each data type from the available options.

Different data types will have different possible settings, though many data types allow you to restrict the data in that column, cell, or range to only data of that data type. For instance, restricting to Attachment data types prevents users from typing text in addition to adding files.

Once complete, click Update to change the data type.

Converting Between Data Types

When changing data types, converts existing data to the new data type. Please see our article on Converting Between Data Types for more insight into how data of one type converts to another.

Changing the Primary Column

The primary column is restricted to alphanumeric data types, a subset of all data types, as shown below.


Undoing Changes

Like most other changes in, you can undo a change in data type. To undo, either select Undo in the toolbar mceclip0.png or type Ctrl + Z (CMD + Z for Mac users). Undoing edits to a column's data type will restore the column to its previous data type.

For more insight into how to change the data types for ColumnsCells, or a Range of Cellscheck out the corresponding articles. Also, converting from one data type to another often results in changes to the underlying data. Check out our article on converting between data types for more insight into converting.