Difference between revisions of "Using Excel or Word Glossaries"

From Wordfast Wiki
Jump to: navigation, search
 
Line 1: Line 1:
WFC and WFP3 use a tab-delimited text file format for glossaries. WFP5 and above uses a SOLR database format for its glossaries; however, it can import glossaries that are in a tab-delimited text file format.
+
[[Wordfast Classic]] (WFC) and [[Wordfast Pro 3]] (WFP3) use a tab-delimited text file format for glossaries. [[Wordfast Pro]] (WFP) version 4 and above uses a SOLR database format for its glossaries; however, it can import glossaries that are in a tab-delimited text file format.
 
 
In other words, if you have a glossary in a Word document table or a glossary in an Excel file, you need to start by converting it to a tab-delimited text file. The first column should contain source word(s), the second column the target word(s), and the third column can optionally contain a description or other meta-data related to the terms.
 
  
 +
In other words, if you have a glossary in a Word document table or a glossary in an Excel file, you need to start by converting it to a tab-delimited text file:
 +
* The '''first column''' must contain the source terms.
 +
* The '''second column''' must contain the target terms.
 +
* The '''third column''' may contain descriptions or other meta-data related to the terms.
  
  
 
==Converting Glossaries for use in Wordfast==
 
==Converting Glossaries for use in Wordfast==
  
 +
[[File:excel test1.png|thumb|Saving a glossary from Excel]]
 
=== Excel Glossaries ===
 
=== Excel Glossaries ===
  
 
# Make sure that your Excel file only includes 2 columns: one for the source terms and the other for the target terms.
 
# Make sure that your Excel file only includes 2 columns: one for the source terms and the other for the target terms.
 
# Make sure that each field includes only the term (in the form expected to appear in original texts); omit any notes or unnecessary additions.
 
# Make sure that each field includes only the term (in the form expected to appear in original texts); omit any notes or unnecessary additions.
# 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.
+
# From the Excel '''''File''''' menu > '''''Save as''''', choose "Tab-delimited" as your file type. '''Note:''' If your language pair includes special characters that get broken after converting into a txt file, you can select "Unicode Text", instead.
 
# 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."
 
# 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."
 
# 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."
 
# 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."
# 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>
+
# 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 [[User:Yasmin|Yasmin Moslem]] illustrates how to convert an Excel glossary to Wordfast glossary.</ref>
 
 
[[File:excel test1.png|500px]]
 
  
  
 +
[[File:word test1.png|thumb|Converting a table to tab-delimited text in Word]]
 
=== Word Table Glossaries ===
 
=== Word Table Glossaries ===
  
Line 25: Line 27:
 
# '''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'''''.
 
# '''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'''''.
 
# 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).
 
# 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).
 
+
[[File:word test2.png|thumb|Saving a glossary from Word]]
[[File:word test1.png|500px]]
 
[[File:word test2.png|500px]]
 
 
 
  
 
==Loading/Importing a tab-delimited text file glossary==
 
==Loading/Importing a tab-delimited text file glossary==
Line 36: Line 35:
 
# Go to the '''''Terminology''''' tab and any glossary sub-tab.
 
# Go to the '''''Terminology''''' tab and any glossary sub-tab.
 
# Click '''''Select''''', and select the (''.txt'') file you obtained from the conversion process above.
 
# Click '''''Select''''', and select the (''.txt'') file you obtained from the conversion process above.
 
  
 
===Wordfast Pro 3===
 
===Wordfast Pro 3===
  
# In your project, click '''''Project Terminology''''' > '''''Import'''''.<ref>This [http://www.wordfast.com/tips_and_tricks/Glossaries/import_gloss.htm video] (by Yasmin Moslem) illustrates how to import tab-delimited glossaries into Wordfast Pro 3.</ref>
+
# In your project, click '''''Project Terminology''''' > '''''Import'''''.<ref>This [http://www.wordfast.com/tips_and_tricks/Glossaries/import_gloss.htm video] by [[User:Yasmin|Yasmin Moslem]] illustrates how to import tab-delimited glossaries into Wordfast Pro 3.</ref>
  
 +
[[File:import glossary.png|thumb|Importing a text glossary into Wordfast Pro]]
 +
===Wordfast Pro===
  
===Wordfast Pro 5 or above===
 
 
# Open a project.
 
# Open a project.
 
# Click on the '''''Project Terminology''''' tab.
 
# Click on the '''''Project Terminology''''' tab.
Line 50: Line 49:
 
# Click on '''''Browse…''''' to navigate to and select the tab-delimited text file glossary.
 
# Click on '''''Browse…''''' to navigate to and select the tab-delimited text file glossary.
 
# Chose to create a new glossary or import it into an existing one.
 
# Chose to create a new glossary or import it into an existing one.
 
[[File:import glossary.png|500px]]
 
  
  
 
== References ==
 
== References ==
 
  
 
<references/>
 
<references/>
  
 
+
[[Category:Wordfast Classic]]
 
+
[[Category:Wordfast Pro]]
----
+
[[Category:Wordfast Pro 3]]
Written by [[User:Yasmin|Yasmin Moslem]], 29 December 2011
 
 
 
Updated by [[User:Byron|Byron]], 10 January 2019
 
 
 
Version: Wordfast Pro 5.8<br>
 
Operating System: macOS
 

Latest revision as of 16:27, 16 April 2021

Wordfast Classic (WFC) and Wordfast Pro 3 (WFP3) use a tab-delimited text file format for glossaries. Wordfast Pro (WFP) version 4 and above uses a SOLR database format for its glossaries; however, it can import glossaries that are in a tab-delimited text file format.

In other words, if you have a glossary in a Word document table or a glossary in an Excel file, you need to start by converting it to a tab-delimited text file:

  • The first column must contain the source terms.
  • The second column must contain the target terms.
  • The third column may contain descriptions or other meta-data related to the terms.


Converting Glossaries for use in Wordfast

Saving a glossary from Excel

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, choose "Tab-delimited" as your file type. Note: If your language pair includes special characters that get broken 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).[1]


Converting a table to tab-delimited text in Word

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.
  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).
Saving a glossary from Word

Loading/Importing a tab-delimited text file glossary

Wordfast Classic

  1. Go to the Terminology tab and any glossary sub-tab.
  2. Click Select, and select the (.txt) file you obtained from the conversion process above.

Wordfast Pro 3

  1. In your project, click Project Terminology > Import.[2]
Importing a text glossary into Wordfast Pro

Wordfast Pro

  1. Open a project.
  2. Click on the Project Terminology tab.
  3. Click on the Import Glossary icon.
  4. Select "Tab delimited" as the File Type.
  5. Click on Browse… to navigate to and select the tab-delimited text file glossary.
  6. Chose to create a new glossary or import it into an existing one.


References

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