When I hear data validation I think “csv or excel file generated by other department that I need to import”, how is cue with that sort of thing? Eg I want to i

When I hear data validation I think “csv or excel file generated by other department that I need to import”, how is cue with that sort of thing? Eg I want to import data file and get a report that tells me 20 values in column A are negative, column B contains floats etc. And can it munge stuff? Column C are stored as floats, but should have been of type int. If all values are whole numbers, accept it.