Skip to main content

Map Fields

On the mapping screen, TemplioniX reads the selected Excel range and detects the available columns. Match each required template field with the corresponding Excel column.

Field mapping screen

The example above maps:

Template fieldExcel column
invoice numberinvoice number
invoice dateinvoice date
due datedue date
client nameclient name
client phoneclient phone
client addressclient address
subtotalsubtotal
taxtax
totaltotal

If the first row contains headers, keep First row = headers enabled. If your selected range has no header row, switch to column letters.

Required fields are marked with *. A document cannot be generated until all required fields are mapped.

If the template contains a table or list, configure it in the Repeating Sections step. Repeating sections can use the same selected range or a custom range from another sheet.