Open excel file and "clean it up" then import

[tmyers]

Your most productive move is to define the layout clearly. Give them a sample to follow. Then check the input file to ensure it conforms. If it doesn't conform, refuse to import it. You are never, ever going to be able to anticipate what stupid things they might do next week.

I see what you are saying. Add a validation to it to verify only good data is being brought in. How would I do that?