WAIT. All these words on SO and here have been written because people don't know to change the column type from "General" to "Text"?
If you can learn a language, you could constrain type conversions easily once you have for knowledge.
Its not like there aren’t painful gotchas in other tools- it’s an issue if you aren’t aware of them and if they impact your work.
If it’s big, unusually complex, you probably want a DB before analysis.
If it’s repetitive, or advanced modeling/ml: python/r