Technical forums » CafeTran support »
Excel: Auto-translating columns with non-translatables
Thread poster: CafeTran Trainer
CafeTran Trainer
CafeTran Trainer
Netherlands
Member (2006)
Jan 26, 2023

The Memory menu has an item to import Excel tables (source + target). But sometimes you want to import one or several columns (source only) directly to the TM, in order to auto-translate non-translatables like names of manufacturers, brand names, part numbers with letters etc.

Here is an easy way to do that:

  • Copy the relevant columns to a new Excel file (e.g. column L in the example below).
  • Import this Excel file into your current translation project... See more
The Memory menu has an item to import Excel tables (source + target). But sometimes you want to import one or several columns (source only) directly to the TM, in order to auto-translate non-translatables like names of manufacturers, brand names, part numbers with letters etc.

Here is an easy way to do that:

  • Copy the relevant columns to a new Excel file (e.g. column L in the example below).
  • Import this Excel file into your current translation project, make sure that segmentation is set to "No segmentation in cells".
  • Copy all source segments to the target side.
  • Commit the file to the TM.
  • Use this TM to auto-translate the relevant columns.


Demo: https://youtu.be/szMyvXcOcN0

Screen Shot 2023-01-26 at 22.41.14

You can also decide to auto-translate columns that contain cells with part codes. But you have to be careful when they contain words in the source language. Do a visual scan and collect typical words in the source language that are present in these colums.

I'll import column G in the demo and use this list of typical source words:

Draht|für|Glieder|mit|nach|Profil|Winkel|Zeichnung


The vertical bar character is used to separate words when using a filter in CafeTran Espresso later. (You can save lists like these for your next projects.)

Demo: https://youtu.be/D4qalR37Lj4



[Edited at 2023-01-27 06:58 GMT] ▲ Collapse
 


To report site rules violations or get help, contact a site moderator:

Moderator(s) of this forum
Natalie[Call to this topic]

You can also contact site staff by submitting a support request »

Excel: Auto-translating columns with non-translatables






Trados Business Manager Lite
Create customer quotes and invoices from within Trados Studio

Trados Business Manager Lite helps to simplify and speed up some of the daily tasks, such as invoicing and reporting, associated with running your freelance translation business.

More info »
Anycount & Translation Office 3000
Translation Office 3000

Translation Office 3000 is an advanced accounting tool for freelance translators and small agencies. TO3000 easily and seamlessly integrates with the business life of professional freelance translators.

More info »