The <null> Literal

In spreadsheets, <null> represents a null value. It is case-insensitive — <NULL>, <Null>, and <null> all mean the same thing.

Why It Exists

Spreadsheets lack a native way to represent a null value. A blank cell cannot simply mean null because it may denote a missing value rather than an intentional null, and is additionally reserved for the default export value mechanism. <null> serves as an explicit escape hatch to force a field to be null.

Blank vs <null>

Content	Export Behavior	Nullability Requirement
(blank)	Falls back to the default export value. If none is configured, an error occurs	Allowed on any type
<null>	Assigns a null value	Allowed only if the field’s type supports null

Supported Types

The following types accept <null> in a cell:

Type	Notes
datetime	Datetime
>>[]T	Compact array
>>[N]T	Fixed-size compact array
>>map[K]V	Compact map
>>object	Compact object
>>minmax	Compact minmax
>>wtpool	Compact weighted pool
>>vector	Compact vector
>>tuple	Compact tuple