Fill blank spreadsheet cells with a default value

How to fill blank spreadsheet cells with a default value

2026-06-20

Task

Some rows have an empty brand column. The export should use No brand for those rows while keeping existing brands unchanged.

Short answer

Open brand and add one transformation: condition Empty, action Replace with, result No brand.

How to do it in Eofferix

Open the settings of the brand column.
The outline marks the settings button for brand.
In Transformations, add: condition Empty, action Replace with, result No brand.
The rule runs only on empty cells and leaves existing values unchanged.
Save the template and run the transformation on the final step.

source data

sku	brand	name
SKU-100	Luma	Desk lamp
SKU-200		Office chair

result

sku	brand	name
SKU-100	Luma	Desk lamp
SKU-200	No brand	Office chair