Hi Chunyi,

I would use Glossary Converter to find differences in the translations between two termbases.

1. Convert the termbases to Excel with Glossary Converter.
2. Open termbase 1 and 2 and paste the target column from termbase 2 into a new column in termbase 1 so that the result is an Excel file with three columns, source, target 1, target 2.
3. In column 4, enter the formula =IF(B2=C2;"";"Diff") and fill the formula all the way down to the last term (Ctrl + D).
4. The translations that differ will be marked with ”Diff” in column D, you can set an autofilter and filter for those terms to view them easily.

If you want the opposite, to mark up the similarities, you can change the formula to this, =IF(B2=C2;"No difference";"")

Or combine the two, like this =IF(B2=C2;"No difference";"Diff"), so that you can filter for both ”No difference” and ”Diff”, depending on what you want to see.

Bonus tip: An easy way to avoid filling column D all the way to the bottom om the Excel file (1,000,000 + rows, which might take some time) in a table like the above is to go to one of the language columns and press Ctrl + down arrow. Then move to column D (where you want to fill the formula) and just write something in that cell, for example ”end”. Then go to first row and press Ctrl + shift + D to fill the formula all the way down to where you wrote ”end”, instead of all the way to the bottom of the Excel file.

Hi Chunyi,

I would use Glossary Converter to find differences in the translations between two termbases.

1. Convert the termbases to Excel with Glossary Converter.
2. Open termbase 1 and 2 and paste the target column from termbase 2 into a new column in termbase 1 so that the result is an Excel file with three columns, source, target 1, target 2.
3. In column 4, enter the formula =IF(B2=C2;"";"Diff") and fill the formula all the way down to the last term (Ctrl + D).
4. The translations that differ will be marked with ”Diff” in column D, you can set an autofilter and filter for those terms to view them easily.

If you want the opposite, to mark up the similarities, you can change the formula to this, =IF(B2=C2;"No difference";"")

Or combine the two, like this =IF(B2=C2;"No difference";"Diff"), so that you can filter for both ”No difference” and ”Diff”, depending on what you want to see.

Bonus tip: An easy way to avoid filling column D all the way to the bottom om the Excel file (1,000,000 + rows, which might take some time) in a table like the above is to go to one of the language columns and press Ctrl + down arrow. Then move to column D (where you want to fill the formula) and just write something in that cell, for example ”end”. Then go to first row and press Ctrl + shift + D to fill the formula all the way down to where you wrote ”end”, instead of all the way to the bottom of the Excel file.

Hi Chunyi,

You can export the termbases to excel files using GC. Then just compare those two excel files using the Spreadsheet Compare function. This program is included in MS Office, you can open it by All Programs - Microsoft Office 2016 (or earlier version) . Very easy to use. Just select the two files and compare. I attached an small example. Hope it helps. 

Regards,

Ivan

Unknown said:

Unfortunately the two termbases do not have the same number of entries, since I added new terms to one of them within Studio.

Why not export the terms only to Excel with the GC (just say "ignore" to all other fields) and then they'll be the same structure which will make comparison in Excel very easy.