Data Types

Get organized quickly with Data Types

Store any kind of data anywhere you need it with over 25 data types that can be set at the column, range, and individual cell level.

Data types for any content

Go beyond text, numbers, and formulas in cells with data types ranging from single and multi-select drop-downs, icon sets, ratings, and file attachments that live in cells.

Store files in cells

Manage documents and images right in your sheets with the Attachment data type. Drag and drop files into Attachment cells with clickable thumbnails and fully interactive document previews.

Learn more >

Assign users

Easily manage ownership and other relationships between people and data using the User data type.

Link worksheets together like relational database tables

Link rows between worksheets to connect data and reduce duplication, even across different workbooks, using the Related Row data type.

Learn more >

Visually look up and roll up data from other worksheets

Use Related row lookup and Related row rollup data types to look up and aggregate information from related worksheets. Replace complex VLOOKUP, HLOOKUP, and XLOOKUP formulas or use both -- the choice is yours.

Filter, sort, and group by any data type

Color-coded options in single and multi-select drop downs make it easy to group, sort, and filter to create customized views of your data just right for your team.

Enforce data validation

Set columns, ranges, and cells to Strict to ensure data entered matches the data type of the cell.

Set data types on individual cells and ranges of cells

Put any kind of data anywhere you need it by customizing the data type of any cell or range of cells.

Write formulas using traditional spreadsheet formula syntax

Support for over 400 formula functions with identical syntax to Excel and Google Sheets.

Create Automations that run when a value changes

Use a visual no-code workflow editor to create automations and integrations that run when a cell value changes.

Learn more >

Get organized quickly with Data Types
Get started — it's free