Handling comments when exporting Excel files
Thread poster: msoutopico

msoutopico  Identity Verified
Local time: 19:57
English to Galician
+ ...
Jan 5, 2014

Hi there,

I use memoQ 6.2 but I would like to know whether comment handling is expanded in higher versions.

Imagine an Excel with several columns:
A. source (input)
B. translation (output)
C. translation note (input)
D. feedback from translator (output)

I can import the range of cells in col. B as the translatable text and I think I can import the translation notes in col. C, so that the translator can see those instructions in memoQ with no need to check the Excel.

Then, I can enter segment-related comments in memoQ as I translate with Ctrl+M. The question is: is there any way I can add those comments to the cells in col. D during export in the most recent version?

If not, does anyone have a workaround for something like that? Or, does anyone know whether this is possible in any other tool?

Thanks a lot in advance for any opinions.

Cheers, Manuel

[Edited at 2014-01-05 14:17 GMT]

Direct link Reply with quote
Local time: 22:57
Russian to English
+ ...
Power Utility Pack Jan 7, 2014

Hi Manuel,

I'm not sure that I got right your explanation, but about a month ago I did a trnslation from French into Russian. There were 6 or 8 sheets with many rows each. The worst thing was that many cells had quite large comments, which the client required to be translated too.

First, I tried to translate them in their panes, but it was too hard for a "lazy" translator

Well, I searched the Web and found those PUP for Excel (http://spreadsheetpage.com/index.php/products). I installed them in my 2013 Excel and upon a single pushing on the button got an Excel list with each and every comment from the translated file, arranged as simple cells.

Having translated it as usual file in Memo, I did the export and, then, copy-pasted the contents back into Comment Panes of cells. Unfortunately, I did not find how to automate the process of copying them back.

It would be great if this helps you.

Kind regards,


Direct link Reply with quote

msoutopico  Identity Verified
Local time: 19:57
English to Galician
+ ...
Export memoQ comments to another column Jan 8, 2014

Hi Vic,

Thank you very much for your answer, very much appreciated.

In my case I don't need to translate the comments from the source spreadsheet. Instead, what I need is to include the comments that I can add in memoQ in the exported file.

I know I can export a bilingual table in RTF that includes those comments, but I would like to do it in the same format of my source file (Excel).

It probably can't be done, but copying from the bilngual RTF and pasting in the Excel column is better than nothing.

In any case I'll have a look at the PUPs, they might be useful nonetheless. Thanks a lot for the tip!

Cheers, Manuel

Direct link Reply with quote

VIELLES Ophélie  Identity Verified
Local time: 20:57
Member (2012)
English to French
+ ...
Did you find anything? Feb 4, 2014

Hi Michel,

I was looking for the exact same information: exporting comments back in an Excel file with MemoQ.

Did you find any straightforward solution (better than exporting in RTF and pasting into the Excel file back again?). If so, your help would be appreciated, as I work a lot with Excel files.

If you didn't find anything yet, it could be interesting to ask on the MemoQ community group directly...

Best regards,

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 »

Handling comments when exporting Excel files

Advanced search

SDL MultiTerm 2017
Guarantee a unified, consistent and high-quality translation with terminology software by the industry leaders.

SDL MultiTerm 2017 allows translators to create one central location to store and manage multilingual terminology, and with SDL MultiTerm Extract 2017 you can automatically create term lists from your existing documentation to save time.

More info »
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 »

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