I'm working with Moodle to export a csv file. The file is encoded as UTF-8 but Excel doesn't recognise it and so displays odd characters.
I've modified the code to insert a BOM as per https://stackoverflow.com/a/16231345/1603711
But I am unable to test it because I haven't got Excel installed.
I was hoping to use Excel online at https://office.live.com/start/excel.aspx but I can't find a way to import a csv file.
Is this possible?
Best Answer
Nope. The Excel Online App currently does not support importing/opening CSV files.
You'll have to convert it to XLSX first, which you could do using Libre/OpenOffice, or one of many online file converter services.