How to translate a .csv file

Question

Hello 
 I need to translate a .csv file from German into Italian. 
 The relevant colums are B (Source text) and C (Target text). I have no idea, how to prepare the translation project in Trados in order to translate it. 
 Can someone help me out? Thank you. 
 Here a screenshot of the original document:

Paul · Accepted Answer

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:

Trados Studio > 1. Trados Studio

How to translate a .csv file