Hi,

I'm working with Excel 2003 and have constant problems with saving data as CSV - characters that are not in the standard Latin alphabet are converted into question marks (?). It looks like Excel blindly applies ANSI encoding instead of full Unicode or UTF-8 and I see no option where to choose this encoding. I remember this was happening with earlier releases of Excel as well.

Is there a way to enforce the correct encoding for CSV exports?

The workaround I know is to export the Excel file through a temporary Access database, which then allows to choose any desired encoding but I want to learn a more direct method so that non-technical users could do it as well.

Thanks.