unwanted characters after exporting results

More
3 years 5 months ago #112218 by ricardo01
ricardo01 created the topic: unwanted characters after exporting results
Hi,

I have implemented a survey in Spanish. Accented words like "Corazón" o "García" are converted to "CorazA³n" or "Garc!AA" after downloading results. Is there a way to prevent this from happening?

cheers,

rg

Please Log in to join the conversation.

More
3 years 5 months ago #112219 by c_schmitz
c_schmitz replied the topic: unwanted characters after exporting results
what do you mean by 'after downloading results' ? What do you do with it?

Best regards

Carsten Schmitz
LimeSurvey project leader

Please Log in to join the conversation.

More
3 years 5 months ago #112221 by ricardo01
ricardo01 replied the topic: unwanted characters after exporting results
I mean exactly that...I click on Responses & statistics, and then "Export results to application". I choose to export as CSV file. And the new file is full of those funny symbols instead of proper accents.

Please Log in to join the conversation.

More
3 years 5 months ago #112222 by c_schmitz
c_schmitz replied the topic: unwanted characters after exporting results
And how do you open the file?

Best regards

Carsten Schmitz
LimeSurvey project leader

Please Log in to join the conversation.

More
3 years 5 months ago #112223 by ricardo01
ricardo01 replied the topic: unwanted characters after exporting results
I'm using Excel to open it...however, when I open the file in a simple text editor, I can see the accents are OK, so I figure the problem is related to the way I'm opening it

Please Log in to join the conversation.

More
3 years 5 months ago #112226 by c_schmitz
c_schmitz replied the topic: unwanted characters after exporting results
You need to tell Excel to open it with an UTF-8 charset. Usually this works by not just doubleclicking it but opening it from the Open dialog in Windows, not sure though. A quick google for 'open utf8 csv file Excel' should lead the way.

Best regards

Carsten Schmitz
LimeSurvey project leader
The following user(s) said Thank You: ricardo01

Please Log in to join the conversation.

More
3 years 5 months ago #112227 by ricardo01
ricardo01 replied the topic: unwanted characters after exporting results
Thanks. That worked out...in case somebody is wondering how to open a utf8 csv excel file, this link might help

www.itg.ias.edu/content/how-import-csv-f...character-encoding-0

cheers

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!