Tick all boxes that correspond to true using in the XML configuration file.
Name your filter something that is easily recognizable and that you can remember.
Choose the format of the Excel file you need to translate (XLS or XLSX).
Under the "New Project Preferences" section, click on Filters.
At the Project List view, click on Preferences (or press F9).
Save your XML Configuration file once finished and use it to create a new XLS or XLSX filter in Wordfast Pro:.
If different sheets in the workbook require different configurations, copy the entire section between the and tags (rows 19 and 48 in the image above) and paste it as many times as necessary under the tag.
If the number of characters per cell in a column should be restricted.
Which columns should be translated and if the translation should be placed in the same or another column.
What row the translation should start and end on.
The next section (under, row 17), is used to specify for each or every sheet:.
Copy and paste the following regular expression between the and tags to convert embedded HTML tags and entities into Wordfast tags: (&+? )|(]+?>).
Moreover, they will pollute your TM with non-sensical codes. Otherwise, they will be extracted as translatable text and will be a pain to replicate in Wordfast.
If your Excel file contains HTML tags such as for bold, for italics, etc., you should convert said HTML tags into Wordfast tags.
You can change true to false or false to true depending on what you want.
#Excel import xml with preset columns pro#
The first section (under, row 4), contains default settings that are familiar from the Excel filter options in the Wordfast Pro Preferences.
#Excel import xml with preset columns for mac#
We recommend the free TextWrangler for Mac or Notepad++ for PC.
Open the excelConfig.xml template file using a text editor.
Keep this open while configuring the XML file.
Open the Excel file to be translated to identify what needs to be translated.
In time, the import wizard will be implemented which can be used instead of this method. This is definitely the most complex way of specifying content to be extracted for translation.
Extract soft return strategy (set by default to be interpreted as a tag).
Extract cells in column order (segment ordering would be A1, A2, A3, B1, B2, B3 as opposed to A1, B1, A2, B2, A3, B3).
Treat numbers stored in text format as real numbers, which means they won't be extracted since numbers are non-translatable.
Here is a list of extraction options that can be selected or deselected: For example, you might be asked not to translate certain sheets but your client has not hidden them for you. You may also want to pre-process the Excel file before importing. Modify the Excel Filter or the File to Specify Content for Translationīefore importing your Excel file, you can modify the default Excel filter (XLS and/or XLSX) in the Wordfast Pro Preferences > Project Preferences > Filtersto specify the content that needs to be extracted for translation. Simply add an Excel file to a project and all of its content will be extracted for translation. This is the default setting of the Excel filter.
2 Modify the Excel Filter or the File to Specify Content for Translation.