> So we blame the software instead of blaming the downright lazy people who can't be fucked learning an appropriate tool even though that's their entire career.

Further, the software would be fine if you use it properly for this sort of use case (i.e. bring the data in via PowerQuery which has enforced types).