Using Excel or Word Glossaries

From Wordfast Wiki
Revision as of 17:29, 29 October 2012 by Yasmin (talk | contribs) (Converting Excel Glossaries into Wordfast Glossaries (Tab-delimited Text File))
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search
  • To open a Tab-delimited Text (*.txt) glossary file in Wordfast Classic, go to the Terminology tab and any glossary sub-tab, click "Select", and select the (*.txt) file resulted from the conversion process.
  • To Import a Tab-delimited Text (*.txt) glossary file in Wordfast Pro, go to "Terminology" menu > "New/Select Terminology" > "Import".[1]


Converting Excel Glossaries into Wordfast Glossaries (Tab-delimited Text File)

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).[2]

Converting Word Table Glossaries into Wordfast Glossaries (Tab-delimited Text File)

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".

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).


References

  1. This video (by Yasmin Moslem) illustrates how to import tab-delimited glossaries into Wordfast Pro.
  2. This video (by Yasmin Moslem) illustrates how to convert an Excel glossary to Wordfast glossary.