Importing Excel spreadsheet data into to Word
July 6, 2008 12:05 AM Subscribe
How can I make readable Word tables out of a large Excel spreadsheet?
posted by lunchbox to computers & internet (7 answers total) 3 users marked this as a favorite
Here's a question for the Excel/Word gurus.
I have created some data in Excel that I need to put into a Word document (.docx) in table form, preferably so that I can continue to edit the Excel spreadsheet and have the Word tables dynamically update. I tried using "Paste Special" to insert one of my worksheets as an Excel Object, but the spreadsheet is too wide to fit in my portrait-oriented Word document. What is the best way to make this data fit?
I have thought of changing some of the pages in my document to "landscape", so that all the table fields can fit. However, it seems I can only change the page orientation for the "rest of the document" to landscape, and I want to change only the middle of my document.
Also, inserting as an Excel Worksheet is quite unappealing aesthetically. The table looks grainy, and when I export to .mht, the object is converted to an image file, so that I cannot select the text.
Another, closely related question: in some situations, I want to make a bunch of tables out of one spreadsheet. In other words, let's say I have the following Excel spreadsheet:
Name | Age | Sex
John | 12 | Male
Jane | 13 | Female
I want to convert this to two side-oriented tables of the following format:
Name | John
Age | 12
Sex | Male
Name | Jane
Age | 13
Sex | Female
Ideally, I would like to put these two tables in different places in my document, and have them automatically update when the spreadsheet changes. This seems very similar to the Mail Merge feature, except I want the output to be in my document, not to other formats.
Any ideas? Thanks!