Ok, this is definately not a perfect system. I think I’ve fixed the quotation issue, Openoffice was replacing regular double quotes with ‘smart quotes’, which has a different symbol for the start and end. Under Autocorrect settings, Localized options, turn off the replace checkbox for the double quotes, as explained in this link: openoffice - Preventing LibreOffice from using smart quotes (“ ”) instead of (dumb) straight quotes? - Super User
So the csv seems to need to be Unicode UTF-8, and if you’re using an excel or openoffice to create the file, turn off the smart quotes.
And just a note for others looking at csv files:
Openoffice doesnt seem to parse the rows very smartly, if I have this: “Its not sharp, but it’ll work” as a field, UE4 correctly parses the text as being one field, while openoffice sees the comma and puts “but it’ll work” into a different cell. I can turn off the cells being seperated by commas, but that kinda defeats the point of using openoffice calc!