I searched all around internet how to save CVS file as Unicode (UTF-8), but it still does not work, whenever i save, and open the file, there is ????? instead of letter that are UTF-8.
Has anyone ever had this issue? how can i solve this?
Asked
Active
Viewed 2,965 times
1
-
Under which software do you save the CSV? With which software do you want to read it? Are they both the same Excel 2016 installation, or not? – virolino Nov 08 '19 at 12:03
-
Windows 10. Yes same. I just save and open again. – Testas Testauskas Nov 08 '19 at 12:06
-
Those are the Web options. AFAIK, they do not affect CSVs – cybernetic.nomad Nov 08 '19 at 15:51
-
Does this answer your question? [Excel to CSV with UTF8 encoding](https://stackoverflow.com/questions/4221176/excel-to-csv-with-utf8-encoding) – cybernetic.nomad Nov 08 '19 at 15:51
1 Answers
0
This has been annoying short coming of Excel for a long time.
A way to work around this issue, is to do the following:
- Save as... Unicode text (*.txt). Make sure to keep the extension as txt (or at least not csv). It will be saved with tabs instead of commas separating the columns.
- Open the document. You will be prompted with an import wizard, like so:
- For File origin, choose 65001: Unicode (UTF-8)
- For the rest of the options, choose the common sense options.
You will have your document back, ready to edit, with the proper unicode text intact.
James John McGuire 'Jahmic'
- 11,728
- 11
- 67
- 78