Translatiang EXCEL docs with different colums in MEMOQ
Thread poster: Magali GUENETTE

Magali GUENETTE
France
Local time: 07:01
English to French
+ ...
Apr 10, 2012

Dear all,

I have an Excel document where the German colum and some other columns containing codes should not be touched, my translation should be entered in a different column next to the German Source text column.

How do I do that?

I hid the "untouchable" columns in Excel thinking this would do the trick. BUt it doesn't...


WF Pro is great for that you can choose in which column the translation should go. But in Memo Q I cannot see this possibility yet. Does it exist ?

I'd like to switch altogether to MEMOQ hence the question, rather than using Wordfast Pro.

TIA for your answers

Magali


 

Damian Harrison
Germany
Local time: 07:01
German to English
C&P Apr 10, 2012

Copy the content which you have to translate into new columns, then import this content into MemoQ using the Import As > Select Ranges function.

 

Jaroslaw Michalak  Identity Verified
Poland
Local time: 07:01
Member (2004)
English to Polish
Copy text to be replaced Apr 10, 2012

In general MemoQ can only replace original text with translation, so first you have to copy the original column to the target column. Then you can select to translate only this column with the settings available in "Import as".

 

Tomás Cano Binder, BA, CT  Identity Verified
Spain
Local time: 07:01
Member (2005)
English to Spanish
+ ...
Simple! Apr 10, 2012

However, please first tell us what version of Excel (XLS or XLSX) and memoQ.

(The process is very simple! You'll see! I will explain as soon as you report what kind of Excel file you have.)


 

Guillaume Chareyron  Identity Verified
France
Local time: 07:01
German to French
+ ...
Just select the ranges to be translated Apr 10, 2012

Bonjour Magali!

Just copy your source text to the target column. Then, in MemoQ, click on Add document as, select you excel-file and a dialog will appear. Just choose "Import only these ranges" and then select the ranges in Excel.

Cheers
Guillaume


 

Magali GUENETTE
France
Local time: 07:01
English to French
+ ...
TOPIC STARTER
Just select the ranges to be translated Apr 10, 2012

Thank you.

I use either Excel 2003 or 2010 indifferently since they are both installed on my laptop.

And my MemoQ version is 5.0.60.

I did copy source text in target colum, but the result is taht Memo Q translated both columns... I just had to recopy the source text in source column but doing all this is time consuming.

I could not find where I can choose what column to translate in IMport as...
so apparently it is in Add document as...

I'll try that again.

Plus in some files I can see that some columns are partly translated.... How do I avoid certains cells (as opposed to certains columns)

TIA for further answers

magali


 

Selcuk Akyuz  Identity Verified
Turkey
Local time: 08:01
Member (2006)
English to Turkish
+ ...
Can Wordfast do it? Apr 10, 2012

Magali GUENETTE wrote:

Plus in some files I can see that some columns are partly translated.... How do I avoid certains cells (as opposed to certains columns)

TIA for further answers

magali


Hi Magali,

Does WF import existing translations into the source or target? AFAIR, existing translations were imported as source segments (not an ideal solution) but my WF knowledge is limited.

Between, Trados Studio has a good CSV filter for such scenarios.

Selcuk


 

Tomás Cano Binder, BA, CT  Identity Verified
Spain
Local time: 07:01
Member (2005)
English to Spanish
+ ...
Depends Apr 10, 2012

Magali GUENETTE wrote:
How do I avoid certains cells (as opposed to certains columns)

Indeed it should be Add document as...

If your Excel document is an XLS file, you have to select what ranges you do not want translated. You simply select the ranges (can be full columns, rows, or ranges of cells), then click Add Ranges. Keep selecting and adding ranges to select all the items you want to stay as is.

In the case of an XLSX document, you can do as above, or --much simpler-- select the range you want to translate, and memoQ then ignores all the rest. The options in Add document as... differ depending on the type of Excel file.


 

Magali GUENETTE
France
Local time: 07:01
English to French
+ ...
TOPIC STARTER
depends Apr 11, 2012

THanks. I indeed selected a range to exclude columns but had not thought to do it for separate cells

Magali


 

Dominique Pivard  Identity Verified
Local time: 08:01
Finnish to French
Wordfast Pro as workaround Apr 14, 2012

Magali GUENETTE wrote:
I could not find where I can choose what column to translate in IMport as...
so apparently it is in Add document as...

Plus in some files I can see that some columns are partly translated.... How do I avoid certains cells (as opposed to certains columns)

You can do both things in Wordfast Pro, using its advanced wizard:
1) tell it to put translations of column A into column B, without touching column A
2) tell it to ignore cells that already have a translation in column B

I explain this in the following video:
http://wordfast.fi/blog/cat-tools/2012/03/14/how-to-translate-excel-columns-in-wordfast-pro/

And since version 5.0.53, memoQ supports the TXML format, so once you have done the above in Wordfast Pro, you can open the TXML in memoQ. Once your document is translated in memoQ, you can export it to TXML, open it in Wordfast Pro and save the translated Excel file there.


 

Magali GUENETTE
France
Local time: 07:01
English to French
+ ...
TOPIC STARTER
Thanks Dominique Apr 15, 2012

Yes translating Excel in Wordfast Pro almost has no secret for me now and I loved your video which I had looked at when first posted on WFast Yahoo Groups for French speakers. The choice of columns and cells is great.

BUT

I'm really trying to get used to Memo Q now, and avoid to use 2 or 3 CAT tools at the same time since my translations and TM often have to be corrected once the clients give their final approvals of the texts in Word file first and then in PDF file, I really need to reduce the amount of files and TM to be handled. Plus I share the TM with some colleagues, and we have decided that MemoQ would cover most of our needs.

I'm now in the process of converting most of my WF TMs and glossaries for MEMOQ...
and it is been going fine so long.

I managed to select the propre range of cells in MemoQ, after copying my source text in target cells, so evthing is OK now.

Magali


 


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


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

Translatiang EXCEL docs with different colums in MEMOQ

Advanced search






BaccS – Business Accounting Software
Modern desktop project management for freelance translators

BaccS makes it easy for translators to manage their projects, schedule tasks, create invoices, and view highly customizable reports. User-friendly, ProZ.com integration, community-driven development – a few reasons BaccS is trusted by translators!

More info »
memoQ translator pro
Kilgray's memoQ is the world's fastest developing integrated localization & translation environment rendering you more productive and efficient.

With our advanced file filters, unlimited language and advanced file support, memoQ translator pro has been designed for translators and reviewers who work on their own, with other translators or in team-based translation projects.

More info »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search