Changing File Encoding on a CSV with OpenOffice Calc

I had a CSV that I created with Open Office Calc, and it was saved in a Western Europe encoding. I needed to change it to Unicode UTF-8, but there was no option to save the CSV with a different encoding. If I opened the CSV and selected to view it with UTF-8 encoding, the special characters (letters with accents) did not display correctly.

The solution is to open the CSV with the encoding that displays your characters correctly, and save that file as an OpenOffice Spreadsheet (with an .ods extension). Save that .ods file as CSV, and you are prompted for an encoding. Select Unicode UTF-8, and the characters display correctly.



Filed under calc, csv, encoding, open office, scalc, unicode, utf-8

10 responses to “Changing File Encoding on a CSV with OpenOffice Calc

  1. How is it possible to select the encoding for an OpenOffice document?

  2. thank you very very much, just saved me from a csv import chaos…

  3. Thank You for putting this up – saved my day! :)

  4. naitsirch

    Hey, that’s a great idea :-) works fine, even in LibreOffice 4.1

  5. If you can use bash shell.
    $ iconv -c -f euc-kr -t utf-8 input.csv > output.csv

    It would be more convenient.

  6. The main reason may be due to the difference in the development of cultural consciousness. If you have a chance to read Bertrand Russell’s “A History Click

Leave a Reply

Please log in using one of these methods to post your comment: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s