I don't know what it's called, if there is a specific name for this approach, but have seen it on rare occasion.
I'd open the CSV file as a database source in Monarch, and then select the fields to import, or hide them in the table view and then export the leftovers, if necessary.
Alternatively, you can do the same by opening the CSV file directly into Excel, assuming that it fits (not too many rows/columns). Then clean it up as applicable, and save it out again.
I don't know of a better way, especially on the first use of a new CSV file. As you say, the best reviewer of the content - the only one to trust - is your eyes.
On the second pass however, Monarch takes over.