It needs to be tab delimited for these versions of Excel. Interesting that the newer version of Excel that Tofa is using is correctly importing the character encoding.
You need to download the file as a Tab Delimited txt:
Then, your computer will probably open the file in a text editor. Copy this text and paste it into your favourite spreadsheet program, or open the txt file directly using Excel etc..
Hi Tofa, as Nicolas said you can use Tab delimited format. Specially you can use file type as UTF-8 file formatting while saving (do save as with UTF-8) which maintains the special characters. This will be useful for both import and export.
To create an automatic report, I don't have the option to download as a UTF-8 file.
When the report is delivered, it needs to be readable, meaning my MDs shouldn't have to upload/download, resave into different file types...especially when I'm dealing across different languages.