This is about dealing with csv files in the wild not about whether you can craft the perfect csv file. I have had years dealing with actual csv files from all corners of the world and all corners of sanity.
Are the CSVs with literal newlines in string fields in the room with us right now?