• State Verified Answer
  • +1 person also asked this people also asked this
  • Replies 4 replies
  • Answers 1 answer
  • Subscribers 432 subscribers
  • Views 1468 views
  • Users 0 members are here
Options
Related

Excel Bilingual Setup: Translating Multiple Columns on One File with Source

Hyo Jin Song

Hello? 

My name is Jin. How are you doing? Hope you guys are doing well. 

When the source file is in Excel, I'd like target to be translated on one file with the source column. I know about selecting 'bilingual excel' in the project settings. However, what I want to do is to translate column A into column B and also column C into column D, as shown in the Figure1 below.

But in the settings, as shown in the Figure2, there's only one source column and one target (translation) column. Is there a way to address this? 

<Figure1>

Excel spreadsheet with two columns circled, 'A' labeled as 'source' and 'B' labeled as 'target', and two other columns 'C' and 'D' with 'source' and 'target' respectively.

<Figure2>

Trados Studio project settings window showing 'Columns' section with 'Source column' set to 'A' and 'Translation column' set to 'B', circled to highlight the lack of multiple source and target column settings.

Thank you for your support in advance. 

Best regards, Jin 

Generated Image Alt-Text
[edited by: Trados AI at 12:38 PM (GMT 0) on 29 Feb 2024]
emoji
Rate translation
×
Suggest better translation
×
Moderator UI
×
  • Get AI Suggestion
Parents
  • +2

    ,

    I don’t think you can do that with the Bilingual Excel filetype.

    Unless other people gives more ideas, this is what I do:

    In Excel, copy column a to B (and C to D).

    In Excel, set column A with red text (same to C column):

    Excel cell with column header A highlighted in red indicating text color selection for exclusion.

    In Trados Studio, open the standard Excel fietype > Content processsing section, and exclude text with that red colour:

    Trados Studio project settings showing the Content Processing section with options to skip or include cells based on text color.

    Open the spreadsheet in Trados Studio (columns A and C shoud not be extracted) and translate as usual.

    After generating the target document, open the translated spreadsheet in Excel, select columns A and C and set them as Automatic before delivering to the client:

    Excel color selection dropdown with 'Automatic' and theme colors, highlighting the option to reset text color to default.
    emoji


    Generated Image Alt-Text
    [edited by: Trados AI at 12:38 PM (GMT 0) on 29 Feb 2024]
Reply
  • +2

    ,

    I don’t think you can do that with the Bilingual Excel filetype.

    Unless other people gives more ideas, this is what I do:

    In Excel, copy column a to B (and C to D).

    In Excel, set column A with red text (same to C column):

    Excel cell with column header A highlighted in red indicating text color selection for exclusion.

    In Trados Studio, open the standard Excel fietype > Content processsing section, and exclude text with that red colour:

    Trados Studio project settings showing the Content Processing section with options to skip or include cells based on text color.

    Open the spreadsheet in Trados Studio (columns A and C shoud not be extracted) and translate as usual.

    After generating the target document, open the translated spreadsheet in Excel, select columns A and C and set them as Automatic before delivering to the client:

    Excel color selection dropdown with 'Automatic' and theme colors, highlighting the option to reset text color to default.
    emoji


    Generated Image Alt-Text
    [edited by: Trados AI at 12:38 PM (GMT 0) on 29 Feb 2024]
Children