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
Related articles
- Columns — configuring columns
- Write modes — impact on headers
- Replace — always writes headers