Excel Autofill
Automatically fill and route Excel templates from your form or AI data.
Last updated
Was this helpful?
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.
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.
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}}You can apply inline formatting to cell values using backslash-tag syntax. Tags can be nested.
\bold(text)
Bold
\italic(text)
Italic
\underline(text)
Underline
\color.RRGGBB(text)
Font color (hex, no #)
Example:
Tags can wrap variable placeholders as well:
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.
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?
Was this helpful?
\bold(\color.FF0000(Warning:)) \italic(please review this section.)\bold({{FieldName}})feathery.horizontal = {{FieldID}}