1

I have 1000 rows, many of which contain chinese or special characters. I tried uploading my excel file to Google sheets and downloading as a CSV file. However instead of displaying a ? (as it does when I try save as CSV through excel) character it just displays other random characters.

What do I need to do?

pnuts
  • 58,317
  • 11
  • 87
  • 139
Justin
  • 315
  • 2
  • 4
  • 18
  • Take a look at these similar questions: http://stackoverflow.com/questions/6002256/is-it-possible-to-force-excel-recognize-utf-8-csv-files-automatically and http://stackoverflow.com/questions/4221176/excel-to-csv-with-utf8-encoding – Afshar Mohebi Jul 15 '15 at 11:44

3 Answers3

2

Try to use UTF-8 encoding and add a BOM prefix (\uFEFF) to the beginning of the file. It works for me.

Dalcof
  • 166
  • 7
1

You need to save the file using UTF-16 encoding, so you will need to select Unicode Text, however this will save the file using TAB delimiters instead of COMMAs. If this is Ok, then you are done.

Otherwise, follow this article to help you change the TABs to COMMAs.

https://www.ablebits.com/office-addins-blog/2014/04/24/convert-excel-csv/#export-csv-utf8

joehanna
  • 1,471
  • 1
  • 11
  • 22
0

You should save file with UTF-8 to make sure all characters are properly saved.

rav_kr
  • 434
  • 8
  • 16