Some days, it seems that they have as many differing and fascinating ways of screwing-up CSV as there are open sessions of Microsoft Excel...
Then I remember that Microsoft have other applications, too.
Being prepared to work with this, and becoming a ridiculous sort of expert in it, has become a lucrative source of income.