Problem for translating a CSV document on Trados Studio

Hi,

I have to translate a CSV document but I don't remember how to do that on Trados Studio. When I open on Excel, everything is written on column A but there are a lot of tags etc. that are not to be translated.

Excel screenshot showing a CSV file with multiple columns including Type, Identification, Field, Locale, Market, Status, Default content, Translated content, with text and HTML tags in the cells.

When I open it on Studio, here is what I have: 

Excel screenshot displaying only the first two columns, Type and Identification, with the rows labeled COLLECTION and identification numbers.

Thank you for your help!



Generated Image Alt-Text
[edited by: Trados AI at 1:34 PM (GMT 0) on 29 Feb 2024]
emoji
Parents
  •  

    You have at least two problems to work in Excel:

    1. you import a file like this into Excel through the Data tab, you don't just open it
    2. it needs to have a BOM (Byte Order Mark) to be recognised as UT-8 since the chars are getting corrupted in Excel... cell F3 in your screenshot for example, but there are lots of them.

    To open the CSV correctly in Studio you need to specify which columns you want as source and target in the filetype settings.  Currently it's taking the first two, and it's also extracting the header as translatable text which you might not want.

    Paul Filkin | RWS Group

    ________________________
    Design your own training!

    You've done the courses and still need to go a little further, or still not clear? 
    Tell us what you need in our Community Solutions Hub

    emoji
Reply
  •  

    You have at least two problems to work in Excel:

    1. you import a file like this into Excel through the Data tab, you don't just open it
    2. it needs to have a BOM (Byte Order Mark) to be recognised as UT-8 since the chars are getting corrupted in Excel... cell F3 in your screenshot for example, but there are lots of them.

    To open the CSV correctly in Studio you need to specify which columns you want as source and target in the filetype settings.  Currently it's taking the first two, and it's also extracting the header as translatable text which you might not want.

    Paul Filkin | RWS Group

    ________________________
    Design your own training!

    You've done the courses and still need to go a little further, or still not clear? 
    Tell us what you need in our Community Solutions Hub

    emoji
Children