Converting excel data/worksheet into a word document

Converting excel data/worksheet into a word...

Didn't find your answer?

I often produce figures/data in excel and want to present the data in MS Word format as part of a report. Is there an easy way to convert an excel worksheet into Word format? I am able to convert an excel document into a PDF (excel 2010) but would also like to convert to a MS Word format also.

Is there a clear and easy way to carry out the excel to word conversion and hold the same layout as it appears in the excel format?

Replies (12)

Please login or register to join the discussion.

avatar
By WhichTyler
03rd Jan 2012 16:03

If Only...

You can embed an Excel table in a word doc via Paste special, but this can be troublesome.

If any one has a better idea, I'd be glad to hear it too! I think they are fundamentally different beasts, and have spent many happy hours trying to bridge the gap...

Thanks (0)
By Democratus
03rd Jan 2012 16:16

There is a special copy

If you hold down the shift key when selecting edit copy you will find a "copy picture" option. This will allow you to embed the selected area as a picture rather than a table into word and it avoids the whole sizing issue which is probably what WhichTyler is refering to.

Thanks (0)
avatar
By WhichTyler
03rd Jan 2012 16:30

Thanks

That could be useful where the Excel is finalised & fully formatted. I usually find that it needs some tweaking as soon as it is in Word...

Thanks (0)
avatar
By Bennettd305
04th Jan 2012 09:09

Many thanks

Thanks you for the comments.  I will try them and see where it leads. 

It is a bit frustrating when I produce a formatted report in excel such as a Balance Sheet for example and then convert it to word as part of the report and from there it goes to pot and subsequently needs a lot of tweaking to bring it back to anything that it resembled in excel. 

Thanks (0)
avatar
By bernard michael
04th Jan 2012 09:11

Not sure it if helps.Highlight the Excel doc where required and cut & paste to a word page/report. It will appear exactly as the Excel doc

Thanks (0)
avatar
By Bennettd305
04th Jan 2012 09:46

many thanks

Have tried the shift/copy and embedding as a picture. It works well but does not allow for editing.  Its useful when there is no further editing required.

Have also tried selecting and copying.  Agian it works on certain worksheets but somehow the table has spilled over the right hand side margin and then it is back to the tweaking issue.  I think this is something to do with adjusting the scaling % in excel in the page setup when it is less than 100%. 

Thanks (0)
avatar
By bernard michael
04th Jan 2012 10:45

After transferring the Excel info to a Word doc as I suggested you can then adjust the size of any part of it by using the space toolbar in Word ( where the font is selected)

Thanks (0)
avatar
By JohnBanfield
13th Jan 2012 15:47

Troublesome ?

You can insert an Excel spreadsheet into the Word doc, then simply copy into it from the original Excel spreadsheet. It doesn't have to be Paste Special, and you can modify it any way you want, so why is it troublesome ?

I can control Excel in any shape or form I want, but often get frustrated with formatting on Word docs !

The picture option can be ok but you can't change it once its there, whereas you can change the Excel spreadsheet within word. Note that you can also save the spreadsheet as a pdf and insert the pdf into Word as well.

 

John

Thanks (0)
pic
By jndavs
21st Feb 2012 12:04

Excel to Word
There is no easy way to do this that I am aware of.
As others have pointed out, you can use linking or embedding for transferring data between MS Office and other files but these will usually entail a certain amount of tweaking in the destination application.

You could set up macros to do this if you find that the whole process or destination formatting is repeatative.

Alternatively Excel has the facility to save sheets as PDFs (or use something like CutePDF) and there are utilities around that will convert PDFs into Word documents. You may want to try http://www.trulyfreeware.com/

Edit: Since writing the above site seems to have disappeared, a shame since it housed one of the best PDF to Word converters I have used. try http://www.freewaregenius.com/2010/03/06/how-to-convert-pdf-to-word-doc-... for some other examples.

Thanks (0)
avatar
By BillC
11th Feb 2012 14:44

Try Paste Special

I use Excel data in Word documents regularly and generally use one of two techniques.  You will get to know which technique to use based on what you need to do with the data once it is in Word.

Both techniques require you to select the Excel data and then Copy.  Go to Word and Choose Paste Paste Special.

Paste Special with Paste: Microsoft Office Excel Worksheet Object allows you to paste the Excel data as an Excel object effectively copied from the original worksheet and then to manipulate the pasted object as if it was an Excel worksheet. Data and formulae transfer from the worksheet.   Any formatting can be carried out as if it was in Excel, but the data will remain as it was captured.  Any change in the underlying data will not reach the pasted object.

Paste Special with Paste link: Microsoft Office Excel Worksheet Object allows you to paste the Excel data as a link to the Excel worksheet.  Any changes in formatting needs to be done in the original worksheet BUT the benefit is that the data is linked so that any change in the underlying data will be reflected in the Word report.

Both techniques allow the image to be resized at constant ratio or horizontally and vertically separately.  Position of the image can be used using Word tabs.

Hope that this helps

 

 

 

Thanks (0)
By gustavf
21st May 2013 12:46

Covert Excel to Wurd

in Excel go to SaveAs and drop the file type box down to  a web page or HTML file. Now use explorer to locate this file. Right click and select open with ( not open) and select Word , now in Word go SaveAs  and drop down box and select Word file. Take the rest of the day off.

Thanks (0)
avatar
By j0nnybr4v3
02nd Feb 2015 23:55

Nice, i can now convert excel type into word format..Recommend this to my friends..

.

Buy Datpiff Downloads

Thanks (0)