I usually have to highlight a Row eg Row 3 to see what the string length is required per column e.g Name has a string length of 50 for example. Then I have to train people how to use the =Len function in Excel.

Can you have the Excel sheet use some conditional filters to highlight which names are too long or have a character that should be removed? This would be helpful.

This would be helpful information on the Excel worksheet rather than using the Native BC import package config system which only checks for errors when its too late.