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

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

Changing the type

Click on the column header.
Select Change type.
Choose the new type.

Attention 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:

Click on the column header.
Select Manage options.
Add, rename or delete options.
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.