Using your old glossaries in your CAT tool

Using your old glossaries in your CAT tool

Most CAT tools support importing glossaries as tab-delimited text files. So if you have an Excel glossary or a Word table of bilingual terms, all what you need is to convert them to tab-delimited text (*.txt) files to be able to use them in your Translation Environment Tool (TEnT).

 

Converting Excel Glossaries

1- Make sure that your Excel file only includes 2 columns: one for the source terms and the other for the target terms.

2- Make sure that each field includes only the term (in the form expected to appear in original texts); omit any notes or unnecessary additions.

3- From the Excel “File” menu, Save as -> Save As Type -> Text (Tab-delimited). Note: If your language pair includes special characters that are spoilt after converting into a txt file, you can select “Unicode Text”, instead.

4- Click OK, if a message prompts: “The selected file type does not support multiple workbooks that contain multiple sheets. To save only the active sheet, click OK.”

5- Click Yes, if a message prompts: “(The file) may contain features that are not compatible with Text (Tab-delimited). Do you want to keep the workbook in this format.”

6- Now, you can close Excel without saving (as you have already saved the glossary).

Converting Word Table Glossaries

1- Make sure that your table includes only 2 columns, one for the source terms and the other for the target terms.

2- Make sure that each field includes only the term (in the form expected to appear in original texts); omit any notes or unnecessary additions.

3- Word 2000, XP or 2003: From the “Table” menu, select: Convert Table to Text, and Separate text with: Tabs. Word 2007, 2010 or 2011: Go to “Layout” pane and click “Convert Table to Text”, and Separate text with: Tabs.

4- Click the “File” menu (or the MS logo of Word 2007), click “Save as” and from “Save As Type”, and select “Plain Text” (or “Text Only”). (Note: Use “Other encoding” -> “Unicode” if your language requires that).

Print Friendly, PDF & Email
Spread Knowledge
Comments are closed.