Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 474
  • Last Modified:

Opening CSV with excel

Hi there,
I want to do a very simple thing. I want to create a csv file with excel (or any other way for that matter) which i can give to a client of mine so that he can edit it and upload it to a web service...

I open excel, write all the data i need, then i close it and save it as csv, and when i reopen it all the GREEK characters in it become ????

I tried creating the file with openOffice and saving it with UTF-8 encoding but then i got weid "chinese" like characters.

This seems very weird.
0
ioustinos_sarris
Asked:
ioustinos_sarris
1 Solution
 
Ardhendu SarangiSr. Project ManagerCommented:
Hi,
Do you MS-Excel application? Can you try saving the csv file within that instead of using openoffice.org?

If you want, please post your excel version of the file so that I can create a CSV file and see what comes up?

Thanks,
Ardhendu
0
 
avalenzuelaCommented:
csv files are basically text..
does the data change when you reopen the file with notepad ?
0
 
netmunkyCommented:
make sure the file is saved as UTF-8. if you open the csv in notepad and it looks correct, choose File -> Save As..., and change the encoding to UTF-8 (default is ANSI). save the document, and open in excel.
0
 
byundtCommented:
Excel is known to have issues with Unicode characters and .CSV file format. The .CSV file format doesn't deal with Unicode characters directly, but you may be able to handle it by using the proper keyboard encoding. http://drupal.org/node/172996

Rather than dealing with this problem, you may prefer to save the file in tab delimited format, which Excel can read and write. This alternative is also discussed in the above link.
0
 
byundtCommented:
The other way of handling the issue is to make sure that the very first characters in your .CSV file specify the Byte Order Marker (BOM) http://joconner.com/2010/03/csv-utf/

I believe you can return the suggested BOM character with the VBA statement ChrW(&HFEFF)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now