Integrating information from Word to Excel (not mail merge)

Apr 14, 2021
Reaction score
I have a student who has put together an Excel spreadsheet for Fantasy Football. He has all of the player names in Word, and all of the stats in Excel. How does he get the stats from Excel into a Word document he created? There is no access to Internet for his class.

For example, if one of the guys in the FF League wanted to get the updated info on a player to see if he starts him this week or not, they want to click the players name on the word doc, and have it go to the specific rows for that player's updated stats, not the top of the first page of the document.

Any help on this would be appreciated.



Microsoft MVP
Mar 2, 2012
Reaction score
Depending on how the Excel data are laid out, you could use a series of DATABASE fields in the Word document - one for each player. Insert a Heading paragraph for each payer above the corresponding DATABASE field and use a Table of Contents linked to those headings for navigation.

An example of DATABASE field usage you could adapt can be found at:

Whether or not the class has internet access is not a relevant consideration.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question