0

I want to use an excel file as a data source for an ms word document:

  • More than one sheet (table) of the excel files need to be displayed in the word file
  • Formatting of the tables in MS and excel must look different. I want to use excel to input data and word to create a report of the data.

Update

So far I have a word document and an excel document. The first sheet of the excel file appear in the document by: Insert -> Object -> Excel file (using link to file).

What is missing is too insert an object (as above) to the same file but so that the second sheet in the excel file is displayed in word.

Even better will be if the sheet to displayed is identified by sheet name.

  • 1
    What did you do so far? – IQV Mar 27 '17 at 7:48
  • 1
    You can try to copy from excel and paste as link in Word. – Scorpion99 Mar 27 '17 at 10:07
1

For a single set of fields

As suggested by @Scorpio99, copy the cell from Excel, and paste using Paste Special > Paste Link in Word. For an example, see this guide, or this Microsoft Office support article.

For multiple sets of fields

If the data has multiple entries (e.g. a list of names and addresses for a dozen recipients), use Mail Merge. This is designed to generate output in bulk (e.g. address labels), but can be used to generate any sort of Word layout repeatedly, using an Excel data set.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.