When opening an exported CSV in MS notepad, the linefeeds are not displayed.
This is because of the lack of a so called UTF-8 BOM in the exported CSV file.
Please add this to the exported CSV so it will be readable in notepad as well.
Yes this would be nice! UTF-8 with BOM is simply UTF-8 with a special character at the start of the String. As a workaround, you can add the BOM character yourself to your String and it will work. Opening the CSV file in Notepad++ shows the Encoding as UTF-8 with BOM, and opening the file in Excel correctly displays special characters. You can copy the BOM character from here: https://symbl.cc/en/FEFF/