Author Topic: Convert Excel files (xls, xlsx) to TMX (free online tool)  (Read 14115 times)

spiros

  • Administrator
  • Hero Member
  • *****
  • Posts: 299288
  • Gender: Male
  • point d’amour
    • spiros.doikas
    • greektranslator
    • doikas
    • 102094522373850556729
    • lavagraph
    • Greek translator CV
Convert online Excel files (xls, xlsx) to TMX

https://translatum.gr/cgi-bin/excel-to-tmx.pl

xlsx/xls/tsv > tmx is part of a series CAT conversion tools developed by Translatum:

tmx > text (read Help)
xlsx/xls/tsv > tmx (read Help)
xlsx/xls/tsv > MultiTerm xml (read Help).

This tool converts the following types of files to a tmx memory file. It accepts as input the following types of files:

— xlsx file
— xls file
— tab separated text file (it must be in UTF-8 format)

You can better prepare your files for this conversion by following some specific steps.
Make sure only plain LATIN characters (without accents) are contained in the file name. [Important!]
Make sure there is no header row. If there is one, then delete it. A header row could contain descriptive information about the column content, i.e. language name.
Make sure there are no leading, trailing or multiple spaces (You can use the free ASAP Utilities to fix that in Excel by going to ASAP Utilities > Text > Delete leading, trailing and excessive spaces).
Make sure there are no empty rows (You can use the free ASAP Utilities to fix that in Excel by going to ASAP Utilities > Columns and rows > Delete all empty rows).
Make sure there are no empty cells (i.e. cells where source or target text is missing). To fix that, Sort text first on Column A, scroll down to check on any orphan entries, and then repeat with Column B.

A typical file structure is with source language in Column A and target language in Column B (in Sheet 1). You may have different notes in each cell of Column C if you want to further specify your translation units. If you have a note that applies to the whole file, just enter it in the tool in the Add A Note (optional) box. I.e. it could be “Medical” or you could have the customer name there. If you have different values in Column C for each translation unit check the Last Column check box.

In the Enter Column 1 Language check box enter the column 1 language code. It could be EN, EN-US, FR, FR-FR, etc. Please see a list of these codes (you need the code listed in the Culture Name column). Make sure that the codes match the ones used by the translation memory in which you would like to import the tmx file. If they do not match, you may need to open the tmx file with a text editor like Notepad++ and run a find/replace to fix the language code. In the Enter Column 2 Language check box enter the column 2 language code.

(Note that you can add more languages by clicking on Add new column, thus creating a multilingual tmx file).

In the Creator box enter your first name (in Latin characters) or leave it blank (Translatum TMX maker will be used).

Click Submit to upload the file and wait until the conversion is completed and a download link is displayed. Right click on the download link and save the file in the desired location. Unzip it and then import it to your CAT tool. Please read how to import a tmx file in various CAT tools.

Maximum file size limit is 10 MB. In case your file is larger than that you can a) split your file into smaller ones b) if your file is xls save it first as xlsx (the file size is reduced in xlsx format).

Files are deleted hourly and they are not used for any purpose.

The tool was based on a free script by Hungarian translator András Farkas.


The video below illustrates the procedure of conversion of an Excel file and its import to SDL-Studio 2014:

« Last Edit: 21 Jun, 2017, 15:59:38 by spiros »


UFZ

  • Semi-Newbie
  • *
  • Posts: 4
  • Gender: Female
Re: Convert Excel files (xls, xlsx) to TMX (free online tool)
« Reply #1 on: 20 Jun, 2017, 10:49:59 »
Hi, I wonder if this program still works?
I was using it 2 weeks ago, went on 2 week vacation, came back and can't convert any file.
Instead of opening a page this link: https://translatum.gr/cgi-bin/excel-to-tmx.pl keeps saving a file on my computer, it happens each and every time.
Could you help me out, am I doing sth wrong or has it stopped working?



spiros

  • Administrator
  • Hero Member
  • *****
  • Posts: 299288
  • Gender: Male
  • point d’amour
    • spiros.doikas
    • greektranslator
    • doikas
    • 102094522373850556729
    • lavagraph
    • Greek translator CV
Re: Convert Excel files (xls, xlsx) to TMX (free online tool)
« Reply #2 on: 20 Jun, 2017, 12:23:01 »
This is being investigated; will let you know when I have news.


UFZ

  • Semi-Newbie
  • *
  • Posts: 4
  • Gender: Female
Re: Convert Excel files (xls, xlsx) to TMX (free online tool)
« Reply #3 on: 21 Jun, 2017, 08:57:44 »
Thank you

spiros

  • Administrator
  • Hero Member
  • *****
  • Posts: 299288
  • Gender: Male
  • point d’amour
    • spiros.doikas
    • greektranslator
    • doikas
    • 102094522373850556729
    • lavagraph
    • Greek translator CV
Re: Convert Excel files (xls, xlsx) to TMX (free online tool)
« Reply #4 on: 21 Jun, 2017, 16:01:40 »
Should be fixed now.

UFZ

  • Semi-Newbie
  • *
  • Posts: 4
  • Gender: Female
Re: Convert Excel files (xls, xlsx) to TMX (free online tool)
« Reply #5 on: 03 Aug, 2017, 10:30:38 »
It is, thank you!