I work with CSV a lot. There used to be a time when Libre Office had a pretty good CSV support, including the character encodings which are one of the headaches Excel gives you. However, for quite a while now I've been using a piece of software named Easy Data Transform. That covers all our use cases and helps with semi-automating things. It's paid software though.