Problem while converting excel to csv for Special Characters

P

Pramod Khadse

Hi All,

I need to convert excel sheet data into csv format data
file, but while doing so for some Eastern countries, like
Poland, special characters in the excel sheet are getting
converted into junk data
e.g
Excel Sheet Original line - Zespól Opieki Zdrowotnej w
Bedzinie
Line when converted to CSV - Zespó? Opieki Zdrowotnej w B?
dzinie

Really appreciate your response on this.

Thanks,
Pramod
 
D

Dave Peterson

I'm not sure if this will help, but I just copied your first original line into
a excel worksheet (USA xl2002) and saved it as .csv.

I re-imported and it looked fine.

I opened the .csv in Notepad and it looked fine.

I opened the .csv file in another text editor and it looked fine.

Is there any chance that the application you're using to verify the .csv file
data won't show those special characters?

(From someone who sits in the USA and doesn't know about those extra
characters!)
 
Top