Column types

At a glance

Each column in a spreadsheet has a type that determines the accepted data format, sorting options and validations applied automatically.

Available types

Type	Description	Example
Text	Free-form text string	Q1 2026 Report
Number	Numeric value (integer or decimal)	42, 3.14
Date	Date in local format	03/14/2026
Date and time	Date with time	03/14/2026 09:30
Checkbox	Boolean value (true/false)	☑ / ☐
Selection	Choice from a list of predefined values	In progress, Completed
Multiple selection	Multiple choices possible	Marketing, Finance
URL	Clickable link	https://example.com
Email	Validated email address	name@example.com
Phone	Phone number	+33 1 23 45 67 89
Currency	Amount with currency symbol	1,250.00 EUR
Percentage	Percentage value	85%
Duration	Time interval	2h 30min
File	Attachment	report.pdf
Entity	Link to an ontology entity	Customer > Acme Corp

Setting a column type

At creation

1. Click + to add a column.
2. Enter the column name.
3. Select the type from the dropdown menu.
4. Configure the type-specific options (see below).
5. Click Create.

Changing the type

1. Click on the column header.
2. Select Change type.
3. Choose the new type.

warning

Changing the type may cause data loss if existing values are not compatible with the new type. For example, switching from Text to Number will remove non-numeric values.

Options by type

Text

Option	Description	Default
Max length	Maximum number of characters	Unlimited
Multiline	Allow line breaks	No

Number

Option	Description	Default
Decimals	Number of decimal places	0
Minimum	Minimum accepted value	None
Maximum	Maximum accepted value	None
Format	Thousands separator	Yes

Selection

Option	Description
Values	List of possible choices, each with a color
Default	Pre-selected value for new rows

To add or modify selection options:

1. Click on the column header.
2. Select Manage options.
3. Add, rename or delete options.
4. Assign a color to each option for easier reading.

Currency

Option	Description	Default
Currency	Currency symbol	EUR
Decimals	Precision	2

Entity

Option	Description
Entity type	Filter by an ontology entity type

This type allows you to link a spreadsheet row to an existing entity in the ontology. See Linking with the ontology.

Sorting and filters

Each column type supports ascending/descending sorting and adapted filter operators:

Type	Filter operators
Text	contains, does not contain, starts with, is empty
Number	equals, greater than, less than, between, is empty
Date	before, after, between, today, this week
Selection	is, is not, is empty
Checkbox	is checked, is not checked

For more details on filters, see Filters and views.

See also

• Editing data — Edit cells
• Filters and views — Organize the display
• Linking with the ontology — Entity type columns

Need help?

Contact us: Support and contact.