The stupidest part is where it is localized so in some parts of the world the comma is the decimal separator, yet it also is the field separator. So then there’s a different field separator but there is no way to reliably detect that.

CSV is full of stupid things like that. Full of magic, underspecified hacks and useless nonfeatures.