Short Answer: Often the wrong header row or sheet selection causes missing columns; confirm "1. Select sheet" and "2. Header row" then reselect fields.
PreRequisites
- You can identify row numbers and sheet names in the preview
Steps
-
Check the value in "1. Select sheet" to ensure the correct sheet is chosen.
Correct sheet (e.g., "Vendor Statement") is selected. -
Verify "2. Header row" points to the row that contains column headings in the preview.
Header labels appear in the mapping dropdowns. -
Reopen "5. Reference / Description" and look for the column labels; add them if they now appear.
Previously missing columns are available to select.
Troubleshooting
-
Column names appear as data values instead of headers.
LikelyCause: "2. Header row" is set to the wrong row.
Action: Change "2. Header row" to the correct number where column headings appear and re-check mappings. -
Expected sheet name is not listed in "1. Select sheet".
LikelyCause: The file/sheet was not included in the load process or sheet name differs.
Action: Return to the file import area (outside this dialog) to confirm the file includes that sheet, then re-open this configuration dialog.
Note: If you cannot resolve missing columns by changing header row or sheet, check the source file for merged cells or non-standard headers.