I was assuming that Google spreadsheet exports UTF-8 encoded CSVs. However, this does not seem to be the case — my German Umlauts, etc. (äüöß, etc.) are not recognized, i.e., when opening the file in XLS.
Here is an example file: Link
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this communityI was assuming that Google spreadsheet exports UTF-8 encoded CSVs. However, this does not seem to be the case — my German Umlauts, etc. (äüöß, etc.) are not recognized, i.e., when opening the file in XLS.
Here is an example file: Link
Actually, Google Sheets exports to CSV using UTF-8.
In Excel, instead of using double-click to open a CSV file, use the Text Import Wizard as it allows to select the "File origin".
On the "File Origin" field, select 65001: Unicode (UTF-8)
.
I question that Google is exporting CSVs as UTF-8. I exported a sheet as csv and ran the following bash command:
file -I "file_name.csv"
and it returns...
file_name.csv: text/plain; charset=us-ascii
Not sure if it matters, but used a Chrome browser for this.
äüöß
were nicely exported and on my Chromebook, the Office extention that allows my to edit Excel files, was able to show them also. – Jacob Jan Tuinstra Mar 6 '16 at 7:42