Gloria Dell'Agnola

First thing is to be wary of this:

Excel is notorious for not properly supporting unicode when opening csv files into Excel.  If you open the same file in a text editor you'll probably see it doesn't look like that at all.  So be careful with the file.  You can get around it if you add a BOM to the csv.

The next thing would be to look at the instructions that come with the file.  You have five columns separate by a comma:

Knowing this you have two simple ways to handle this.

Bilingual Excel

If you add a BOM to the file you could then import it into Excel rather than simply opening it.  This can put each column into a separate column in Excel if you specify the separator to be a comma:

Then just save the file as an XLSX instead of csv.  Hide the first six rows as they won't be needed.  Then configure the Bilingual Excel settings like this:

CSV

Or just handle the CSV directly using these settings:

Hi Paul,

It worked perfectly. Thank you very much for your help.

Cheers,

Gloria

Hello! I don't know if I can ask for help from here, but I received 2 csv files to translate, first time in my life, and don't know how to handle them.

What is a BOM? These instructions are totally non-understandable for me... :-((( Can someone help me?

Valeria Maria Tafel 

I'd recommend you create a new thread and provide some examples of what your CSV files look like.  We probably only need the first few lines so you can easily change the text and just keep the structure.

Valeria Maria Tafel said:

What is a BOM?

https://multifarious.filkin.com/2015/12/01/encoding

Dear Paul, 

I'm facing a problem. 

I need to translate column 3 in column 4. I adapted the setting but got the message in the printscreen. 

How am I suppose to poceed to be able to generate a csv target file?

Sophie Martin 

I'd recommend you create a new thread and provide some examples of what your CSV files look like.  We probably only need the first few lines so you can easily change the text and just keep the structure.

This thread already has a verified answer for the original post.  If you need to just create a link to refer to this thread... although I don't think you need to as your post isn't related at all.