make translation memory from excel file - not getting ST and TT next to each other

Dear Community! 

I'm trying to make a translation memory from an excel file. I'm following Paul's suggestion as per the following link:  How can I make translation memory from excel file? I have source and target ready in excel.  It seemed to be going ok, I keep following all the steps but I end up with a weird file with 2 columns (ST and the TT in a vertical kinda sequence!!!!)

I'm getting the ST and the TT in a vertical sequence - both on the left and on the right hand-side (exactly the same, repeated). 

And even repeated on both sides. I started by creating a doc in Excel: EN ST on the left, IT TT on the right. Then went to the Bilingual File Type (as explained by Paul in the link), the Excel is converted, but the final doc is not what I was expecting. 

Advice? 

Thank you in advance,

Maria 

 

emoji
Parents
  • Hi  ,

    I'm following Paul's suggestion as per the following link

    Which one? The Glossary Converter or the Bilingual Excel file type both mentioned in the link?

    I'm getting the ST and the TT in a vertical sequence - both on the left and on the right hand-side (exactly the same, repeated).

    This result may be due to the Bilingual Excel file type not being ticked or below the default Excel file type in your Project Settings:

    Trados Studio project settings showing File Types with Bilingual Excel file type selected and highlighted in red.

    Check also the column settings used if the Bilingual Excel file type is used:

    Trados Studio Bilingual Excel file type settings showing Columns with Source column set to A and Translation column set to B.

    Then went to the Bilingual File Type (as explained by Paul in the link), the Excel is converted, but the final doc is not what I was expecting.

    What were the results you’re getting?

    The more information you give, the more chances we have to understand what's going on with your issue and give you the best possible solution.

    Edited to be suggested as an answer.

    emoji


    Generated Image Alt-Text
    [edited by: Trados AI at 11:12 AM (GMT 0) on 29 Feb 2024]
Reply
  • Hi  ,

    I'm following Paul's suggestion as per the following link

    Which one? The Glossary Converter or the Bilingual Excel file type both mentioned in the link?

    I'm getting the ST and the TT in a vertical sequence - both on the left and on the right hand-side (exactly the same, repeated).

    This result may be due to the Bilingual Excel file type not being ticked or below the default Excel file type in your Project Settings:

    Trados Studio project settings showing File Types with Bilingual Excel file type selected and highlighted in red.

    Check also the column settings used if the Bilingual Excel file type is used:

    Trados Studio Bilingual Excel file type settings showing Columns with Source column set to A and Translation column set to B.

    Then went to the Bilingual File Type (as explained by Paul in the link), the Excel is converted, but the final doc is not what I was expecting.

    What were the results you’re getting?

    The more information you give, the more chances we have to understand what's going on with your issue and give you the best possible solution.

    Edited to be suggested as an answer.

    emoji


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