I see, thank you for the prompt response.
Yes I am using Microsoft Excel (Office 2021) to open the file which of course supports UTF8 encoding, but for some reason, does open the exported file using UTF8, unless it is converted to .xlsx.
The conversion process is easy, but yet again I would prefer if the process was automated for my client.