You are here: Home » Localization Engineers » Using your old glossaries in your CAT tool
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

Comments are closed.

Scroll To Top