Converting Excel to MS-Word
Thread poster: Jonathan MacKerron

Jonathan MacKerron  Identity Verified
Member (2005)
German to English
+ ...
Dec 12, 2007

I have several large Excel files (Excel 2000 is running on my computer) that I need to convert to MS-Word.
Does anyone know if this is possible, and if so, how?
Many thanks in advance,
J


Direct link Reply with quote
 

Maayan Steinberg  Identity Verified
Israel
Local time: 20:57
English to Hebrew
you can copy it as a table Dec 12, 2007

i tried few options, and the only reasnable one is this:

you chose all the rows/columns in Excel that you need in Word->>"copy"->> go to a new Word file->>>"paste".
you'll get the table in word, but you might have to arrange it a little.

as far as i know that's the only way.

good luck


Direct link Reply with quote
 

Jonathan MacKerron  Identity Verified
Member (2005)
German to English
+ ...
TOPIC STARTER
thanks Dec 12, 2007

do you then have to reformat in Word? - todah rabah

Direct link Reply with quote
 

Maayan Steinberg  Identity Verified
Israel
Local time: 20:57
English to Hebrew
it's just that somtimes Dec 12, 2007

the table is too wide for the Word standard page, so you have to adjust it a little.

besides that, the table stays exactly the same as it was in Excel. Visually that is...you dont have all the Excel functions in Word.


Direct link Reply with quote
 

Tony M  Identity Verified
France
Local time: 19:57
Member
French to English
+ ...
Not QUITE...! Dec 12, 2007

maayanst wrote:

the table is too wide for the Word standard page, ...


I resorted to spreading the Word document right across both my screens — mind-boggling, but workable (just!)

besides that, the table stays exactly the same as it was in Excel.


Actually, not quite! You need to be very careful here — I just came horribly unstuck, which caused me hours of extra work!

I had occasion to copy-&-paste 3 columns but some 2200 lines of XLS into a DOC — I actually in the end got better results using 'paste special > 'RTF formatted text', although I don't think that had anything to do with the problems I then encountered.

When I pasted the DOC back into the XLS, to my horror, I found it was misaligned in various places!

It turned out that what had happened was that merged cells in the XLS had turned into fused cells in the Word table, but they didn't go back the same, thus creating spurious extra lines in the XLS, which had to be meticulously stripped out to restore order.

Now I'm not sure at what point this all went wrong, but I have a feeling it may have been because of 'soft returns' included in the XLS cells getting converted into 'hard returns', which then created spurious extra cells in the Word table — and needless to say, the whole situation was exacerbated by having translated via Wordfast on the way!!

So I would urge caution, check the formatting of the XLS cells carefully first, and maybe do a trial run on a (representative) section first.

Certainly, when I first tried this (on a simpler XLS) going direct (i.e. not via RTF), the formatting was well preserved, within the constraints of the Word page size, of course.

And another word of caution: if the spreadsheet contains pull-down 'choice' boxes, that can cause chaos!

[Edited at 2007-12-12 18:19]


Direct link Reply with quote
 

Jonathan MacKerron  Identity Verified
Member (2005)
German to English
+ ...
TOPIC STARTER
Thanks Tony Dec 12, 2007

Based on the little experience I've had with Excel conversion, it surely is fraught with problems. Am thinking of cutting my losses and translating it in Excel, despite the limitations.

Direct link Reply with quote
 

Jan Sundström  Identity Verified
Sweden
Local time: 19:57
English to Swedish
+ ...
Use a proper CAT tool! Dec 13, 2007

Jonathan MacKerron wrote:

Based on the little experience I've had with Excel conversion, it surely is fraught with problems. Am thinking of cutting my losses and translating it in Excel, despite the limitations.


Hi Jonathan,

I don't know which CAT tool (if any) you're using, but if you don't have any tool, I'd do like this:

Download Trados (free trial), and convert the excel sheet to TTX in Tageditor.
Download TTXpress.
Translate the TTX in Word.
Cleanup the TTX back to the XLS format.

This operation can also be done in other free/share/trialware CAT tools, just take your pick. There is nothing more annoying than just translating in Excel without any translation aid!

/Jan


Direct link Reply with quote
 

Jonathan MacKerron  Identity Verified
Member (2005)
German to English
+ ...
TOPIC STARTER
Thanks Jan Dec 13, 2007

I'll give it a try

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 »

Converting Excel to MS-Word

Advanced search






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



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