Translation - Μετάφραση

Resources, Technical Assistance and Technology News => Translator resources => CAT Tools Tips and Assistance => Topic started by: spiros on 07 May, 2010, 22:23:11

Title: Convert multiple excel files to tmx or Trados txt translation memory [TmBuilder]
Post by: spiros on 07 May, 2010, 22:23:11
TM builder used to crash in older to 1.0.4 versions (latest working version attached), I also recommend this alternative tool
Try also this online utility:

Convert multiple excel files to tmx or Trados txt translation memory [TmBuilder]

TMbuilder ( is a Translation Memory export creator is a small tool that makes building up TM export/import files as straight-forward as possible. The 1.01 build uses code pieces from a previously created console-based version but has a nice and handy GUI. It was written in Microsoft Visual Studio 2008 so the Microsoft .NET Framework 3.5 is necessary to use the application.

— Accepts two input formats: tab-delimited text files and MS Excel spreadsheets
— Creates output files in two file formats: Translator's Workbench 7.x/8.x (TXT) and the Translation Memory eXchange (TMX)
— Works on multiple input files and offers a merging feature—there might be just one import file
— Allows the user to specify standard TM fields, like: source and target ISO flags, segment descriptions and author name
Removes additional quotes often created by MS Excel when saving the file to the Text form
— Works with standard encodings: Unicode and UTF-8
— Rapid file creation: milliseconds for .txt and seconds for .xls input files
— Application is free for non-commercial use and can be distributed as a standalone executable program


See also:
Convert Excel glossaries to Multiterm 5 format or to Trados translation memory (txt import file) (

TM Builder crash info:

Code: [Select]
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.Runtime.InteropServices.COMException (0x80028018): Old format or invalid type library. (Exception from HRESULT: 0x80028018 (TYPE_E_INVDATAREAD))
   at Microsoft.Office.Interop.Excel.Workbooks.Open(String Filename, Object UpdateLinks, Object ReadOnly, Object Format, Object Password, Object WriteResPassword, Object IgnoreReadOnlyRecommended, Object Origin, Object Delimiter, Object Editable, Object Notify, Object Converter, Object AddToMru, Object Local, Object CorruptLoad)
   at TMbuilder1._0.Form1.utworz_tm(String plik_wejsciowy, Boolean tw, Boolean tmx)
   at TMbuilder1._0.Form1.button4_Click(Object sender, EventArgs e)
   at System.Windows.Forms.Control.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ButtonBase.WndProc(Message& m)
   at System.Windows.Forms.Button.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

************** Loaded Assemblies **************
    Assembly Version:
    Win32 Version: 2.0.50727.5472 (Win7SP1GDR.050727-5400)
    CodeBase: file:///C:/Windows/Microsoft.NET/Framework64/v2.0.50727/mscorlib.dll
    Assembly Version:
    Win32 Version:
    CodeBase: file:///H:/Downloads-H/tools05/mine/TMbuilder/TMbuilder1.0.exe
    Assembly Version:
    Win32 Version: 2.0.50727.5468 (Win7SP1GDR.050727-5400)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/
    Assembly Version:
    Win32 Version: 2.0.50727.5467 (Win7SP1GDR.050727-5400)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/
    Assembly Version:
    Win32 Version: 2.0.50727.5467 (Win7SP1GDR.050727-5400)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/
    Assembly Version:
    Win32 Version: 11.0.5530
    CodeBase: file:///C:/Windows/assembly/GAC/Microsoft.Office.Interop.Excel/

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the section.
The application must also be compiled with debugging

For example:

    < jitDebugging="true" />

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.
Title: Re: Convert multiple excel files to tmx or Trados txt translation memory [TmBuilder]
Post by: zocipro on 16 Jan, 2011, 01:48:59
Will the files then be compatible with Trados 2007 need to send like materials from my work ? THANKS.
Title: Re: Convert multiple excel files to tmx or Trados txt translation memory [TmBuilder]
Post by: spiros on 16 Jan, 2011, 01:58:38
Yes, export as tmx.
Title: Re: Convert multiple excel files to tmx or Trados txt translation memory [TmBuilder]
Post by: michaelbeijer on 27 Feb, 2015, 00:40:53
TMbuilder works fine on my computer (Win7 64-bit), but it sometimes introduces stuff like "&apos;" instead of apostrophes. It also spits out UTF-16, which I don't like. TM Maker in the LF Aligner "Grab Bag" also adds these HTML characters.

The best free TMX creator I have found is actually inside the now free Heartsome TMX Editor:

Tools > Convert to TMX … produces perfect TMXs every time!
Title: Re: Convert multiple excel files to tmx or Trados txt translation memory [TmBuilder]
Post by: spiros on 02 Mar, 2015, 15:27:29
In fact the issue was fixed in latest version (1.0.4).

Xbench does the trick too and there is an online tool also: