Tip, tricks, and updates for Windows & MS Office
Merge from Excel into Word Table
Merge from Excel into Word Table
Reader Shani Nunkumar asks:
I want to merge the data from an [Excel] spreadsheet in separate rows in a word table – how can this be done?
This is a cool feature in Word, Shani, so I am glad that you asked. It is not too much different than performing a standard mail merge. Really, there are only a few steps you will do differently than you would in a typical mail merge. And none of them are difficult steps. The first thing you will want to do is create a table on your new, blank document. If you are not sure how to do so, go to the Table menu in Word 2003. Point to Insert and click on Table. In Word 2007, click on the Insert tab, click the Table button and choose Insert Table. You will only want to make one row to start off, but insert as many columns as you will need in order to merge your data from Excel.
When you get to the part of the mail merge process that asks you to select a document type, choose Directory. Make sure to select Use the Current Document. When your task pane shows Arrange Your Directory, insert the merge fields into the appropriate cells of the table. When you get to the Complete the Merge section, click To New Document on the task pane.
Voila! You will now have a Word table that you can adjust, format or even copy and paste into another existing document.
See you online!
Tricia Goss, Editor
tricia@officeusers.org
Your Office Answers are Here!
Comment Notification
Subscribe to this post's comments using