How to Insert Excel Data Into Word Documents

Rebecca Johnson is a former freelance contributor to Lifewire and a Microsoft Office Certified Master Instructor who specializes in Microsoft Office products.

• 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.

What to Know

• When you insert Excel data into Word, you can either link the Excel worksheet to the document or embed it.
• Embed: Highlight the data in Excel, press Ctrl+C or Command+C to copy it, then paste it where you want the data to appear in Word.
• Link: To include a link to the Excel worksheet, go to Paste >Paste Special >Paste link >Microsoft Excel Worksheet Object >OK.

This article explains how to insert an Excel spreadsheet into a Word document. Instructions apply to Microsoft Word and Excel 2019, 2016, and 2013 as well as Microsoft 365.

How to Embed Excel Data in a Word Document

Here's how to embed an Excel worksheet using the simple paste option:

1. Open the Microsoft Excel worksheet, then highlight the data you want to include in the Word document.

Copy the data. Press Ctrl+C (on a Mac, press Command+C). Or, right-click the selected data and select Copy.

The data appears in the Word document.

Here's how to embed using the Paste Special option:

1. Open the Microsoft Excel worksheet, then highlight the data you want to include in the Word document.

Copy the data. Press Ctrl+C (on a Mac, press Command+C). Or, right-click the selected data and select Copy.

Go to the Home tab and, in the Clipboard group, select the Paste drop-down arrow, then choose Paste Special.

In the Paste Special dialog box, select Paste.

Insert Special menu in Word with the Excel Worksheet option highlighted" width="1679" height="1020" />

Select Microsoft Excel Worksheet Object.

Select OK.

The Excel data appears in the Word document.

How to Link Excel Data to a Word Document

The steps to link a worksheet to a Word document are similar to the steps to embed the data.

1. Open the Microsoft Excel worksheet, then highlight the data you want to include in the Word document.

Copy the data. Press Ctrl+C (on a Mac, press Command+C). Or, right-click the selected data and select Copy.

Go to the Home tab, select the Paste drop-down arrow, then choose Paste Special.

In the Paste Special dialog box, select Paste link.

Choose Microsoft Excel Worksheet Object.

Select OK.

The Excel data appears in the Word document.

Keep these pointers in mind after you've linked the data:

• If you move the linked Excel file (for example, to another folder), the link will break. To relink it, follow the steps above again.
• To edit the data, double-click the table to open the linked worksheet in Excel.
• If you edit the worksheet in Excel, the changes appear in the Word document when you save the Excel worksheet.

Should You Link or Embed?

When you link an Excel worksheet to a Word document, every time the worksheet is updated, the changes are reflected in the document. All editing takes place in the worksheet and not in the document. Use this option if you plan to make changes to the worksheet, especially if these changes involve complex calculations.

An embedded worksheet is a flat file. Once it's part of a Word document, it behaves like a piece of that document and can be edited in Word. There is no connection between the original worksheet and the Word document it's now a part of. Use this option if you plan to make minimal changes to the table data or if the data involves simple calculations.

Embedding Options

When you embed an Excel worksheet into a Word document, you can either copy and paste from Excel to Word or embed using the Paste Special feature. The copy-and-paste method is faster but some formatting may change and some table functionality may be lost. The Paste Special feature provides more options for how the data will appear.

Get the Latest Tech News Delivered Every Day