Just out of curiosity, which systems uses \r as newline these days? As far as I understand it, Mac OS did it prior to its version 10 (its Unix version), but the modern macOS does not.
test.csv: UTF-8 Unicode (with BOM) text, with CR line terminators
Apparently, even recent software is not up to date on what the line separator should be.