How to Embed Excel Files in Word Documents GA S REGULAR Menu Lifewire Tech for Humans Newsletter! Search Close GO Software & Apps > MS Office
How to Link or Embed Excel Files in Word Documents
Link an Excel file to a Word doc so the doc updates when the Excel data changes
By James Marshall James Marshall Writer James Marshall is a pro journalist who covers technology and computer troubleshooting. He is also skilled with Microsoft Word, Apple Pages, and other word processors. lifewire's editorial guidelines Updated on March 11, 2022 Reviewed by Ryan Perian Reviewed by Ryan Perian Western Governors University Ryan Perian is a certified IT specialist who holds numerous IT certifications and has 12+ years' experience working in the IT industry support and management positions. lifewire's editorial guidelines Tweet Share Email Tweet Share Email In This Article
Expand Jump to a Section Link Excel to Word What Happens When You Link Excel to Word Embed an Excel Spreadsheet Frequently Asked Questions What to Know
Link: Copy cells. Right-click Link & Use Destination Styles or Link & Keep Source Formatting in Word.Embed: In Word, go to Insert > Object > Object > Create from File > Browse > choose Excel file > OK.Embed a spreadsheet table: In Word, go to Insert > Table > Excel Spreadsheet. This article explains two ways to display Excel data in Word. Instructions apply to Word for Microsoft 365, Word 2019, Word 2016, Word 2013, Word 2010, Excel for Microsoft 365, Excel 2019, Excel 2016, Excel 2013, and Excel 2010. How to Link Excel to Word
To insert any part of an Excel worksheet in a Word document: Maddy Price / Lifewire Open the Word document where the worksheet will display. Open the Excel worksheet that contains the data you want to link to the Word document. In Excel, select and copy the range of cells to include. If you plan to insert more columns or rows into the worksheet, select the entire worksheet. To select the entire worksheet, select the cell located in the upper-left corner at the juncture of the row numbers and column letters. In the Word document, position the cursor where you want to insert the linked table. Right-click and select Link & Use Destination Styles or Link & Keep Source Formatting. Destination Styles uses the default Word table formatting, which usually results in a better-looking table. Keep Source Formatting uses the formatting from the Excel workbook. The Excel data pastes directly into the Word document where the cursor was positioned. If changes are made to the source Excel file, the Word document updates with those changes automatically. What Happens When You Link Excel to Word
Linking an Excel file to a Word document ensures that the Word document is updated every time the data in the Excel file changes. It works as a one-way link feed that brings the updated Excel data into the linked Word document. Linking an Excel worksheet also keeps your Word file small because the data doesn't save to the Word document. Linking an Excel worksheet to a Word document has a few limitations: If the Excel file moves, the link to the Word document needs to be re-established.If you plan to transport the Word file or use it on another computer, you must transport the Excel file along with it.You must do data editing in the Excel worksheet. It isn't a problem unless you require different spreadsheet formats in the Word document. How to Embed an Excel Spreadsheet in Word
The process of embedding an Excel worksheet in a Word document is essentially the same as linking to an Excel worksheet. It does require a few extra clicks, but it brings all data from the worksheet into your document, not only the selected range. There are two ways to embed an Excel worksheet in Word. The first is to embed the worksheet as an object. The second is to insert a table. When you embed a worksheet, Word uses the formatting from the Excel worksheet. Make sure that the data in the worksheet looks the way you want it to appear in the Word document. Embed an Excel Worksheet as an Object
To embed an Excel worksheet as an object: Open the Word document. Go to the Insert tab. Select Object > Object. In Word 2010, select Insert > Object. In the Object dialog box, select the Create from File tab. Select Browse, then choose the Excel worksheet that contains the data you want to embed. Select OK. The Excel worksheet is embedded in the Word document. How to Embed an Excel Spreadsheet Table
An alternative is to insert the Excel worksheet as a table. This method inserts the worksheet the same way as if you embedded it as an object. The difference is that it opens a blank Excel worksheet for you to fill out. Choose this method if you haven't created the Excel file yet. To insert an Excel worksheet as a table in Word: Open a Word document. Place the cursor where you want to insert the Excel worksheet. Go to the Insert tab, then select Table. Select Excel Spreadsheet. This menu option opens a blank Excel worksheet that you can fill with data. Either enter new data or paste data from another spreadsheet. When you insert and fill out a new Excel worksheet, you have an Excel file that you can update at any time. The data in the Word table automatically updates to match the data in the Excel file. FAQ How do I embed a Microsoft Word document in Excel? In Excel, select the Insert tab > Text > Object > Create from File. Next, select Browse to find the Word file > Insert > OK. How do I create labels in Microsoft Word from an Excel list? To create labels in Word from an Excel list, open a blank Word document > select Mailings > Start Mail Merge > Labels > choose the brand and product number for the labels. Then, choose Select Recipients > Use an Existing List > navigate to the Excel address list > OK. Add the merge mail fields to complete the merge. Was this page helpful? Thanks for letting us know! Get the Latest Tech News Delivered Every Day Subscribe Tell us why! Other Not enough details Hard to understand Submit More from Lifewire How to Insert a PDF Into Word How to Hyperlink in Word Documents How to Insert a Document in Word Insert Text or Data From a Document in a Word Document How to Insert Source Code Into a Word Document How to Limit Rows and Columns in an Excel Worksheet How to Convert Excel to Word How to Print Labels from Excel How to Insert a Table in Microsoft Word 2013 How to Delete a Blank Page in Word How to Password Protect an Excel File How to Merge Two or More Microsoft Word Documents How to Make a Brochure in Microsoft Word How to Turn a PDF into a Word Document How to Copy a PowerPoint Design Template to Another Presentation How to Put a Spreadsheet in Google Slides Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up By clicking “Accept All Cookies”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. Cookies Settings Accept All Cookies