Use Header Handling Mode correctly.
FIRST_ROW
-
Uses the first data row as column names.
-
Best when headers are clean and aligned.
PREVIOUS_ROW
-
Uses the row before data begins.
-
Useful when headers sit just above the table.
CUSTOM_ROW
-
Explicitly define header rows.
-
Supports multi-row headers.
Example
If your Excel file looks like this:
-
Row 1–3: Title and logos
-
Row 4–5: Header
-
Row 6+: Data
Correct configuration:
-
Start Data Import on Line:
6 -
Header Handling Mode:
CUSTOM_ROW -
Custom Header Row:
4:5