Thanks for connecting my process to an obvious software solution! I have used LibreOffice before, but hadn't thought of it as a solution to this issue.
Also, I have just tested my earlier workflow using Excel 2018 and the issue still remains. Changing the encoding in Excel doesn't work - I still get ANSI.
Regards
Brendon