I believe that it works but for programmers, the code is ugly, I'm cleaning. Usually the person creating the file doesn't know either. All is lost then? Not really, you can create your own file and save it with a known encoding. The choice of spreadsheet in this case is OpenOffice or LibreOffice. If you use Excel to do all your work in, you are out of luck as Excel has no option for enforcing an encoding when saving a file as CSV. This does not mean you can no longer use Excel but when saving the file for CSV open your Excel file with OpenOffice or LibreOffice.

There are a few things that are important: We are not going to use CTRL-S to quickly save the file but we choose File -> Save As (CTRL-SHIFT-S) and then you get this screen: In this example I will be using LibreOffice (the screens are the same for OpenOffice).Ĭlick on Open and select the file on your computer that you want to save as UTF-8 encoded file.

Save as type must be set to Text CSV (.csv).

You must enable the Edit filter settingsĪfter that is done click on Save. So, if you are still an Apache Open Office user, here are 5 Open Office alternatives you can use: 1. Setting the filter settingsĪfter you have clicked on Save, LibreOffice will ask you what settings you want to use for the file. Libre Office Libre Office is undoubtedly the best Open Office alternative because it’s a fork of Open Office with even better features and community support. It’s arguably the best free office suite available today and it’s not surprising.

The character set must be set to Unicode (UTF-8) as this is what we want to achieve, a UTF-8 encoded file.

The field and text delimiter you can set as you wish or leave it as it is, all other settings can be left unchanged.

Libre open office