How to find column which causing "Conversion failed" error
How do people troubleshoot these without having to go through an arduous process of going field by field?

Exclude half of them.  If the error persists exclude half the remaining.  Repeat.