To open CSV with LibreOffice/OpenOffice, you need to select UTF-8 encoding as the character set, English as the language and comma as the list separator.