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.

Advertisements

10 Comments

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 https://zhoutest.wordpress.com/

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s