Help with Excel spreadsheets embedded in Word file
Thread poster: Mariano Saab
Mariano Saab
Mariano Saab
Argentina
Local time: 01:26
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'v
... See more
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.
Collapse


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

As mentioned here

htt
... See more
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
Collapse


 
Ben Senior
Ben Senior  Identity Verified
Germany
Local time: 06:26
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
... See more
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
Collapse


 
Mariano Saab
Mariano Saab
Argentina
Local time: 01:26
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]


 


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






Protemos translation business management system
Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!

The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.

More info »
CafeTran Espresso
You've never met a CAT tool this clever!

Translate faster & easier, using a sophisticated CAT tool built by a translator / developer. Accept jobs from clients who use Trados, MemoQ, Wordfast & major CAT tools. Download and start using CafeTran Espresso -- for free

Buy now! »