Skip to content

Headers

Headers is a setting that controls whether the header row is shown on the destination sheet. It determines whether the first row of data contains column names.

Step-by-step instructions

1. Open the settings

In the builder, go to the Output > Headers section.

2. Configure the display

Available options:

  • Show headers (default) — the first row contains column names. Suitable for all typical scenarios.
  • Don't show headers — data starts right from the first row with no column names. Useful when the data is being imported into another system that expects a specific format, the sheet already has a static header row (for example, with RewriteFromLast), or the data is used as a source for formulas where headers would get in the way.

3. Configure header formatting (optional)

  • Bold — bold the header text
  • Background color — fill the header row (for example, gray #F3F3F3)
  • Freeze row — pin the header row while scrolling (View > Freeze)

4. Account for the write mode

Under Replace mode, headers are written on every run. Under Append and other cumulative modes — only on the first run (if the sheet is empty), or never (if headers are already present).

How to verify

  • Run the report and open the destination sheet
  • Check that the header row is present/absent according to your settings
  • Check the formatting (bold, background, freeze)
  • Under Append mode with headers disabled, make sure new rows don't contain headers

Maintained by the LightLead Documentation Team · Last verified: 2026-07-25