Difference between revisions of "Using Excel or Word Glossaries"

From Wordfast Wiki
Jump to: navigation, search
m
m
Line 11: Line 11:
 
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.
 
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'', choose "Tab-delimited" as your file type. '''Note:''' If your language pair includes special characters that are spoilt after converting into a txt file, you can select "Unicode Text", instead.
+
3- From the Excel '''''File''''' menu > '''''Save as''''', choose "Tab-delimited" as your file type. '''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."
+
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."
+
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).<ref>This [http://www.wordfast.com/tips_and_tricks/excel/excel2wf.htm video] (by Yasmin Moslem) illustrates how to convert an Excel glossary to Wordfast glossary.</ref>
 
6- Now, you can close Excel without saving (as you have already saved the glossary).<ref>This [http://www.wordfast.com/tips_and_tricks/excel/excel2wf.htm video] (by Yasmin Moslem) illustrates how to convert an Excel glossary to Wordfast glossary.</ref>
Line 25: Line 25:
 
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.
 
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''.
+
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).
+
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).
  
Version: Wordfast Pro 5 5.7.0.RC2. Operating System: macOS
+
Version: Wordfast Pro 5.7<br>
 +
Operating System: macOS
  
 
== References ==
 
== References ==
Line 36: Line 37:
 
<references/>
 
<references/>
  
--[[User:Yasmin|Yasmin Moslem]] 29 December 2011
+
--[[User:Yasmin|Yasmin Moslem]], 29 December 2011
  
Updated by [[User:Byron|Byron]] 01/10/2019
+
Updated by [[User:Byron|Byron]], 10 January 2019

Revision as of 00:09, 18 January 2019

  • 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, in your project, click Project 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, choose "Tab-delimited" as your file type. 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).

Version: Wordfast Pro 5.7
Operating System: macOS

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.

--Yasmin Moslem, 29 December 2011

Updated by Byron, 10 January 2019