All Collections
Features
Source features
How to use the Offset Header setting?
How to use the Offset Header setting?

Learn how to adjust which row is considered the header when connecting files with Sheetgo.

Eugenia Langen avatar
Written by Eugenia Langen
Updated over a week ago

By default, Sheetgo will import the entire dataset from your source tab(s) into the destination tab(s). This includes headers (the rows of your spreadsheet containing labels for the columns, blank rows, or rows containing logos and images).

For most connections, you do not need to use the Offset Header setting. But sometimes, especially when merging multiple files into one, you may want to adjust the setting.

When should I use the Offset Header setting?

Consolidate connections

Sheetgo presumes that Row 1 in each source tab contains the header. You should use the Offset Header setting if:

  1. You are consolidating multiple source files and the header occupies more than one row. In this case, select the lowest row of the header.

  2. You are consolidating multiple source files and the spreadsheet contains rows above the header that are not part of the dataset (such as logos or blank rows). In this case, select the actual header row.

  3. You are consolidating multiple source files with no headers (such as CSV files). In this case, select no headers.

Standard (one-to-one) connections.

For most connections between one source and one destination, you do not need to adjust the setting.

You should use the Offset Header in a one-to-one connection if the source tab header occupies more than one row and you don't want to export the entire header to the destination tab. This may be the case if your source spreadsheet contains logos or other information above the header that you do not want to export. In this case, select the lowest row of the header.

How to access the Offset Header setting?

  • Open Sheetgo and select your workflow or create a New workflow.

  • Under Source data, go to Settings.

  • Under Offset Header, select which row to use as the header.

Tip: If you want to copy the formatting of your header (font, color, text style) use the Transfer Formatting setting.

Need more help?

Contact us via chat, on our email ([email protected]), or send us a ticket!

Visit our Community for help, tips, tricks, and feedback for Sheetgo.

Did this answer your question?