Many programs default to this encoding option for you, so you don't have to do all that pesky thinking and choosing. Google Sheets, for example, uses UTF-8 as it's default. However, if you are using Excel, you may need to check that you're using UTF-8 encoding. You can do this by:
- In your opened file, select "Save As" and select ".CSV"
- Name your file
- At the bottom of this dialog box, select "Tools" and then "Web options"
- Head to the "Encoding" tab and in the "Save this document as:" dropdown, choose Unicode (UTF-8).
(Obviously the steps can vary a bit depending on which version of Excel you are using, but the principle remains - don't forget to specify your character encoding!).
The idea is simple: you are the creator of the file, so you choose the key that the computer will use to translate your text into it's computer-lingo. Your reward for this task is a file that can be opened and read again in your language, without any translation errors!