Mobile menu

Best trad software for excel, text with html tags in? Help!!
Thread poster: Ben Curtis
Ben Curtis
Spanish to English
Jun 17, 2005


I have a very large excel document, around 15,000 words of technical translation. I need to copy each cell of text (an example below), into the adjacent empty cell and then translate it. I think a cat tool may be able to help me out but have no idea where to start looking... I have used wordfast with word a lot, but of course that won't work in excel. Any ideas (especially about free software) would be greatfully apreciated. Thanks.
This is the sort of thing I'm dealing with:

Información hardware del sistema, organizada en las siguientes secciones:

  • Información General: Datos del Sistema Operativo instalado, nombre e IP del servidor y procesador (CPU) actual.
  • Tiempo en marcha del sistema: Tiempo en activo del sistema. El tiempo vuelve a comenzar cuando sucede un reinicio del sistema.
  • Carga del sistema: Valor de carga del sistema actual (últimos 5 minutos y últimos 15 minutos).

    Direct link Reply with quote
Sonja Tomaskovic  Identity Verified
Local time: 23:27
English to German
+ ...
Wordfast does work on Excel Jun 17, 2005

You can work with WF on Excel files.

However, WF will simply overwrite the source text. I therefore suggest you work on a copy of your file, translate it with WF (see the WF manual on how to do that) and then copy the column with your translation into the right position of the original file.



Direct link Reply with quote

Victor Dewsbery  Identity Verified
Local time: 23:27
German to English
+ ...
Works fine with DVX, but ... Jun 17, 2005

... you need to fiddle with the Excel file first.
My suggestion:
1. Mark the column that contains your text and "Copy"
2. Mark the next free column and "Paste"
(You should now have 2 identical text columns).
3. Change the text colour in the first column to red.
4. Import the file into DVX with "Ignore red text".

1. DVX is a powerful piece of software (and a good solution for HTML, too), but it takes some time to get used to. It's not worth getting just for a single job (and it's not free, either).
2. Excel files are often a beast to translate. If the formatting is complex, you may need to spend ages preparing the file before you import it.
3. Sometimes the sentences in Excel text files are split in the middle (a line per cell, so any continuous sentences that go over several lines are hopelessly chopped to bits). I doubt if any CAT tool can handle sentences like that (so again, you would need to spend time formatting the beast before you can start work).

Direct link Reply with quote

Anjo Sterringa  Identity Verified
Local time: 23:27
Member (2003)
English to Dutch
+ ...
SDLX for Excel file Jun 18, 2005

I had a (relatively simple) Excel file to translate last week. What I did was similar to the options given above, but in SDLX. I imported the Excel file as a project in SDLX, translated it, selected preview (then you get the translation back in Excel)and then copy-pasted the translated column in the original file. Make sure to make a copy of the original file just in case some unwanted overwriting happens - I don't remember if SDLX automatically saves the translation somewhere else.
SDLX offers a FREE evaluation version (30 days) and it's easy to use. (even I can work with it...)

I don't know if there's anything else you have to do about the tags in the text - SDLX tends to handle them OK in other formats (it'll translate an XML file without needing a description of the tags for instance).

Direct link Reply with quote
xxxMarc P  Identity Verified
Local time: 23:27
German to English
+ ...
Best trad software for excel, text with html tags in? Help!! Jun 18, 2005

Have you tried OmegaT?

You would first need to convert to OOo format, which is straightforward.

After translation, you should be able to mark whole columns and copy & paste them back into the original document (or a copy of it).


Direct link Reply with quote
Ben Curtis
Spanish to English
thanks Jun 19, 2005

Thanks very much for all the replies so far, I will try the Wp and the SDLX solutions for now... any more ideas always welcome!

Direct link Reply with quote

To report site rules violations or get help, contact a site moderator:

You can also contact site staff by submitting a support request »

Best trad software for excel, text with html tags in? Help!!

Advanced search

Translation news related to CAT tools

Wordfast Pro
Translation Memory Software for Any Platform

Exclusive discount for users! Save over 13% when purchasing Wordfast Pro through Wordfast is the world's #1 provider of platform-independent Translation Memory software. Consistently ranked the most user-friendly and highest value

More info »
Anycount & Translation Office 3000
Translation Office 3000

Translation Office 3000 is an advanced accounting tool for freelance translators and small agencies. TO3000 easily and seamlessly integrates with the business life of professional freelance translators.

More info »

All of
  • All of
  • Term search
  • Jobs