Help with Excel spreadsheets embedded in Word file
Thread poster: Mariano Saab

Mariano Saab
Argentina
Local time: 19:48
Member (2013)
Spanish to English
+ ...
Jan 27, 2015

Hi all,

Hope you can help me. I received a .docx file for translation. It has 6 Excel spreadsheets inserted in the Word file, which I can edit by double-clicking each sheet. Is there any way to export those spreadsheets to Excel so I can import them to a CAT Tool? The sheets have hundreds of repeated terms so it would significantly save me a lot of time to translate them.

I tried converting the .docx to PDF and then exporting it to Excel but the format is messed up. I've also OCR'd the file with ABBY but, again, the format is not so good. I've asked the client for the original Excel sheets but they don't have them.

If anyone can point me in the right direction, I would greatly appreciate it.

Thank you very much in advance.


Direct link Reply with quote
 

Lori Cirefice  Identity Verified
France
Local time: 23:48
French to English
Right click and open/edit Jan 27, 2015

As mentioned here

http://www.proz.com/forum/office_applications/182828-extracting_embedded_excel_files_from_word_document.html

or here

http://www.mrexcel.com/forum/excel-questions/403445-extracting-embedded-excel-word-document.html


Direct link Reply with quote
 

Ben Senior  Identity Verified
Germany
Local time: 23:48
German to English
Copy and paste? Jan 27, 2015

Hi Mariano,

In the table in Word click in one cell to activate it and use CTRL+A to select everything in the table, Press Ctrl+C to copy the data and then go to cell A1 in Excel, press Ctrl+V to paste it into Excel. If you want to put several tables into one Excel spreadsheet, leave a blank line after the last line of the last table pasted, stay in column A and repeat the process above.

You didn't say which CAT tool you are using, but SDL Studio deals with the tables in situ in the Word document and can also localise numbers, currency, etc.

HTH

Regards
Ben


Direct link Reply with quote
 

Mariano Saab
Argentina
Local time: 19:48
Member (2013)
Spanish to English
+ ...
TOPIC STARTER
Thank you Lori and Ben Jan 27, 2015

Thank you both for your all help!

On Lori's second link there is a way to locate the embedded objects. I am using memoQ 2013 R2, but I think the filter configuration for embedded Excel objects is only available in memoQ 2014 (unless somebody knows how to do it in my version of memoQ).

Thanks again, you have helped me a lot!

[Edited at 2015-01-27 15:19 GMT]


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 »

Help with Excel spreadsheets embedded in Word file

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 »
SDL Trados Studio 2017 Freelance
The leading translation software used by over 250,000 translators.

SDL Trados Studio 2017 helps translators increase translation productivity whilst ensuring quality. Combining translation memory, terminology management and machine translation in one simple and easy-to-use environment.

More info »



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