Trick is the to remove the last column in your excel file and use it under "New Columns" with it's value under "New Column Values".
For example, in my CDT, the last column is always "isActive". Now when I would want to import Excel to database, I will…