align 2 excel files 1:1 (1 column each only) ~ SDL Trado Studio 2011 ~
Thread poster: paule2000
Flemish to German
+ ...
Apr 7, 2013

Hello proz community!

It seems that I am unable to get a satisfying alignment result with my 2 very basic excel files.

Each file consists of a 1-column list only.
Now I want to align them 1:1, meaning, each cell is to be connected with the corresponding one in the other file.

The problem is, I have punctuation marks in my cells (One cell: “Otto vs. Paul”) which leads in SDL's WinAlign to a splitting of this very cell after "." (Two Cells: “Otto vs.” and “Paul”).

What can I do? I already played with the settings, but I cannot get a good result.

Is there any way to tell WinAlign, to align the excel cells “as they are”?

Would anyone help me, please?!

[Bearbeitet am 2013-04-07 16:59 GMT]

Direct link Reply with quote
Local time: 03:09
English to Hungarian
+ ...
Avoid Winalign Apr 8, 2013

There are a couple of good ways of generating a TM out of two files like that, none of which involve WinAlign.
Here's an article I wrote about them:
I'd recommend 2 a). Just copy-paste the two columns into column A and B of an xls file and run the TMX maker on them. The TMX maker now has a graphical userinterface and it supports xls input files.

Direct link Reply with quote

SDL Community  Identity Verified
United Kingdom
Local time: 03:09
Another if the excel file doesn't... Apr 8, 2013

... contain formatted text.

1. Copy both columns into one excel file
2. Correct the alignment in Excel
3. Save the file as csv (supports bilingual format)
4. Open the csv in Studio, save it as an sdlxliff and then import the sdlxliff into your Studio TM

Nice article though... very useful.



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 »

align 2 excel files 1:1 (1 column each only) ~ SDL Trado Studio 2011 ~

Advanced search

The words you want Anywhere, Anytime

WordFinder is the market's fastest and easiest way of finding the right word, term, translation or synonym in one or more dictionaries. In our assortment you can choose among more than 120 dictionaries in 15 languages from leading publishers.

More info »
You’re a freelance translator? helps you manage your daily translation jobs. It’s easy, fast and secure.

How about you start tracking translation jobs and sending invoices in minutes? You can also manage your clients and generate reports about your business activities. So you always keep a clear view on your planning, AND you get a free 30 day trial period!

More info »

  • All of
  • Term search
  • Jobs
  • Forums
  • Multiple search