here is the entire specification: the file should be encoded in UTF-8, and fields are separated by the , character This exactly is part of the problem: how man

here is the entire specification: the file should be encoded in UTF-8, and fields are separated by the , character This exactly is part of the problem: how many people do you think would come up with this specific specification? You do realize in real life CSV gets used for anything which is plain text and separated and perhaps even quoted? Also 'should be' UTF-8? By what authority? The existence of software that produces braindead CSVs is beside the point. No, it is not. Especially not because there's so much software. And because it's not braindead, it's just doing something else. Which is bascially fine since there's no standard. Just do the above and everything will work. Yes, in your personal bubble. Beyond that it's totally insufficient.