M
Mark
We have an application that allows users to save their
query results in a comma-delimited format (.csv). We save
the csv file in UTF-8 encoding because the search results
can contain multibyte content (Japanese, Chinese, Korean).
When you open the csv in Excel, however, the characters
are garbled because Excel seems to be using a default
encoding for csv files. Even if I rename the file as .txt
and try the to open it, the text import wizard in Excel
does not include UTF-8 as an option for the file source. I
know the csv file itself is OK because I can open it in
Word and Notepad, and the characters are displayed
correctly.
Does anyone know if Excel can open a UTF-8 csv (or txt)
properly, or is it a limitation of Excel? If it can open
the file, how can I do it?
Thanks in advance for any assistance.
query results in a comma-delimited format (.csv). We save
the csv file in UTF-8 encoding because the search results
can contain multibyte content (Japanese, Chinese, Korean).
When you open the csv in Excel, however, the characters
are garbled because Excel seems to be using a default
encoding for csv files. Even if I rename the file as .txt
and try the to open it, the text import wizard in Excel
does not include UTF-8 as an option for the file source. I
know the csv file itself is OK because I can open it in
Word and Notepad, and the characters are displayed
correctly.
Does anyone know if Excel can open a UTF-8 csv (or txt)
properly, or is it a limitation of Excel? If it can open
the file, how can I do it?
Thanks in advance for any assistance.