How to Program Excel Data to Upload Into a Word Document

Import Linked or Unlinked Excel Worksheet Information into Word Files

by Avantix Learning Team | Updated Feb 1, 2021

Applies to: Microsoft^® Excel^® and Word^® 2010, 2013, 2016, 2019 or 365 (Windows)

You can easily copy or import Excel worksheet data into Word documents. When you import from an Excel file, you can choose to import linked or unlinked data. If it's linked, you will be able to update, change and remove the links.

The following are 3 piece of cake ways to import Excel information into Word by copying and pasting:

1. Copy the data in the Excel file, switch to the Word document and then paste the data where y'all want information technology to announced as a static copy.
2. Import the Excel data into the Word certificate every bit a linked OLE (Object Linking and Embedding) object so that when the Excel file changes, the Give-and-take document will update also.
3. Create links to the Excel data in a Word table then that when the Excel file changes, the tabular array volition update.

If you choose the 2d or 3rd method, yous will need to ensure that the Excel file remains in the same location with the same name or manage the link(s) using Edit Links.

Recommended commodity: How to Create a Tabular array of Contents in Word

Do you desire to learn more almost Microsoft Word? Check out our virtual classroom or live classroom Word courses >

Inserting unlinked Excel data

Y'all tin can easily copy data from Excel and paste it into a Word document. Use this method if you do not demand to update the Discussion file when the Excel data changes.

To insert unlinked Excel information into Discussion:

1. Open the Excel file.
2. Select the data you want to copy into the Word file.
3. Press Ctrl + C or correct-click and select Copy from the drib-downwardly menu.
4. Open the Give-and-take file.
5. Position the insertion betoken where yous want the Excel data to appear.
6. Press Ctrl + V or right-click and choose Paste Values from the drop-downwards carte.
   

With this method, the Excel data will exist copied into Discussion as a table and the Word file will non update when the Excel file changes. Considering the data is pasted into a table, you can use Word'south table tools to format it and the file will be smaller because the data is not linked.

Inserting Excel data as a linked OLE object

You tin insert an OLE (Object Linking and Embedding) object when you want to insert a linked re-create of Excel data. However, one of the issues with this method is that the OLE object is like a picture of the cells and you would demand to format the data in Excel to announced the manner you desire in the Word file.

To insert Excel data into Word every bit a linked OLE object:

1. Open the Excel source workbook.
2. Select the data you want to place in the Word file.
3. Printing Ctrl + C or right-click and choose Copy from the drop-down bill of fare.
4. Open the Discussion destination document.
5. Position the insertion indicate where you want the linked Excel data to appear.
6. Click the Domicile tab in the Ribbon and select the arrow below Paste. A drop-down carte appears.
7. Select Paste Special. A dialog box volition appear.
8. Click Paste Link.
9. Nether As, select Microsoft Excel Worksheet Object.
10. Click OK.

Note the Paste link option on the left of the Paste Special dialog box:

You lot can double-click an OLE object to jump to the source Excel file.

Inserting linked Excel data into a Word table

You can insert Excel information every bit a table in Word where each jail cell is linked to the Excel information source. This is a great method because you tin maintain links but format the information the way you want in Give-and-take.

To insert linked Excel data into a Word tabular array:

1. Open up the Excel source workbook.
2. Select the information you want to place in the Word file.
3. Printing Ctrl + C or right-click and choose Copy from the driblet-downwardly menu.
4. Open up the Word destination certificate.
5. Position the insertion point where yous want the linked Excel data to announced.
6. Click the Home tab in the Ribbon and select the arrow below Paste. A drib-down menu appears.
7. Select Paste Special. A dialog box will announced.
8. Click Paste Link.
9. Under As, select HTML Format.
10. Click OK.

HTML format is selected by default in the Paste Special dialog box:

Click in the table in the Word document. As long equally Field Shading When Selected is set in Word Options, each cell volition appear with gray shading indicating that it is a field linked to Excel. You can format the tabular array in Discussion.

Updating or managing links

One of the benefits of linking data is that data in a destination document updates when you change information in the source certificate. This typically occurs automatically if both documents are open. All the same, if yous open a Give-and-take document with links and the Excel file is not open, Word should prompt you to update the links. You may also need to update links yourself or re-institute a link if the original Excel file has been moved or renamed.

To update or manage links:

1. Correct-click a linked object or HTML tabular array. A drop-downward carte appears.
2. Cull Linked Worksheet Object and then Edit Links. A dialog box appears.
3. Under Update method for selected link, Automatic update is selected by default. You lot can choose Manual update if you do non desire the data to update automatically. You would then need to click the link and click Update Now to update.
4. Brand any other changes (such as breaking a link of changing the source for a link).
5. Click OK.

The Links dialog box below displays i link:

It'south not hard to import Excel data into Give-and-take. Typically, the biggest effect occurs when other users movement or rename the source Excel file but this can be managed using Edit Links and changing the source.

This article was starting time published on March 13, 2016 and has been updated for clarity and content.

Subscribe to become more articles like this 1

Did you lot notice this commodity helpful? If you lot would like to receive new articles, bring together our email list.

More than resources

How to View Word Count in Word (4 Ways)

14+ Word Selection Shortcuts to Chop-chop Select Text

How to Superscipt or Subscript in Word (with Shortcuts)

How to Format Microsoft Word Tables Using Tabular array Styles

How to Insert a Bank check Marking or Tick Mark in Discussion (5 Ways)

Related courses

Microsoft Word: Intermediate / Advanced

Microsoft Excel: Intermediate / Advanced

Microsoft PowerPoint: Intermediate / Advanced

Microsoft Word: Long Documents Principal Grade

Microsoft Give-and-take: Styles, Templates and Tables of Contents

Microsoft Word: Designing Dynamic Word Documents Using Fields

VIEW MORE COURSES >

Our teacher-led courses are delivered in virtual classroom format or at our downtown Toronto location at i Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada (some in-person classroom courses may also exist delivered at an alternate downtown Toronto location). Contact us at info@avantixlearning.ca if y'all'd like to arrange custom onsite training or an online course on a appointment that's convenient for yous.

Copyright 2022 Avantix ^® Learning

Microsoft, the Microsoft logo, Microsoft Part and related Microsoft applications and logos are registered trademarks of Microsoft Corporation in Canada, US and other countries. All other trademarks are the property of the registered owners.

Avantix Learning | 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada M5E 1W7 | info@avantixlearning.ca

hicksfrottive.blogspot.com

Source: https://www.avantixlearning.ca/microsoft-excel/3-ways-to-import-excel-data-into-microsoft-word-documents/

Share this post