Handling comments when exporting Excel files
Thread poster: msoutopico

msoutopico  Identity Verified
Local time: 17:06
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]


Local time: 19:06
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" translatoricon_smile.gif

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,



msoutopico  Identity Verified
Local time: 17:06
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


VIELLES Ophélie  Identity Verified
Local time: 18:06
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.icon_smile.gif

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

Best regards,


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

Manage your TMs and Terms ... and boost your translation business

Are you ready for something fresh in the industry? TM-Town is a unique new site for you -- the freelance translator -- to store, manage and share translation memories (TMs) and glossaries...and potentially meet new clients on the basis of your prior work.

More info »
WordFinder Unlimited
For clarity and excellence

WordFinder is the leading dictionary service that gives you the words you want anywhere, anytime. Access 260+ dictionaries from the world's leading dictionary publishers in virtually any device. Find the right word anywhere, anytime - online or offline.

More info »

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