For the complete documentation index, see llms.txt. This page is also available as Markdown.

Excel Autofill

Automatically fill and route Excel templates from your form or AI data.

If you upload an Excel template, you can include variables in your spreadsheet via double-curly brace syntax ({{Field1}}). Feathery will automatically replace variables with the corresponding field value when you fill them out.

Conditional Sheet Generation

You can include conditional logic that determines if a given individual sheet of your spreadsheet will be included in the final output. To do so, set the name of the sheet to a field variable with double-curly brace syntax. If the field ends up having an empty value, the corresponding sheet will not be included in the final spreadsheet output. Otherwise, the name of the sheet will be replaced with the field value and kept in the spreadsheet as usual.

Conditionally Hide Rows and Columns

You can conditionally hide rows by placing the following syntax in a cell:

feathery.hide_row = {{FieldID}}

If the field value contained in FieldID is truthy (True, 1, etc), the entire row where the cell resides will be hidden. Similarly for hiding columns you can use:

feathery.hide_col = {{FieldID}}

Rich Text Formatting

You can apply inline formatting to cell values using backslash-tag syntax. Tags can be nested.

Syntax
Effect

\bold(text)

Bold

\italic(text)

Italic

\underline(text)

Underline

\color.RRGGBB(text)

Font color (hex, no #)

Example:

Tags can wrap variable placeholders as well:

Array Fill

Vertical

If a field's value is a list (e.g. a repeating section or multi-value field), Feathery will automatically expand the placeholder downward, one row per list item. If the rows below the placeholder are already occupied, Feathery inserts new rows to preserve existing content and copies the cell's formatting (borders, font, fill, alignment) to each inserted row.

Horizontal

To expand a list field sideways across columns instead of downward, use the feathery.horizontal syntax:

Feathery will write one list item per column, inserting new columns as needed so existing content is not overwritten.

Last updated

Was this helpful?