Exporting unicode characters to csv in excel 2008

J

JoWillmott

Exporting to csv in excel 2008 results in unicode characters not being
recognised. Strangely, the characters remain when first saving, but on
reopening, or on using the csv file in another programme the unicode
characters show up as underscores.
I've googled this and this seems to be a known issue. The only workaround I
have found is to upload the xls file into Google Docs and export from there
as csv.
Can anyone tell me whether there is a way to avoid this altogether eg some
setting within Excel that I have overlooked or else whether they have found a
better workaround.
Thanks!
 
F

Fergal Condron

Hi there,

I tried saving with both .Xls and .Csv and the accents are appearing as
expected for me, does this also happen when saving as .XLSX?

Also is there a sample file you could send me a sample file without any
confidential information to my email? It's [email protected]

Thanks,
Fergal.


Exporting to csv in excel 2008 results in unicode characters not being
recognised. Strangely, the characters remain when first saving, but on
reopening, or on using the csv file in another programme the unicode
characters show up as underscores.
I've googled this and this seems to be a known issue. The only workaround I
have found is to upload the xls file into Google Docs and export from there
as csv.
Can anyone tell me whether there is a way to avoid this altogether eg some
setting within Excel that I have overlooked or else whether they have found a
better workaround.
Thanks!
Click to expand...


Fergal Condron,
Macintosh Business Unit
Microsoft Corp.
This posting is provided ³AS IS² with no warranties, and confers no rights.
 
R

Raymond

The problem is, that it not support Unicode 8 (UTF-8), only UTF-16.

You can safe the file with CSV (Coma Delimited)

If you need to import the excel files in other programs, you will have problems. The only thing what you can do is, to use another software program such as openoffice
 
Top