The real strength of Microsoft Office lies in how its applications work together. A common example is embedding analytical data from an Excel spreadsheet into a Word document to present reports clearly and professionally. If your task involves integrating Excel into Word for a business report, financial summary, or academic paper, it is essential to insert the spreadsheet correctly to prevent broken links or formatting issues. Good thing is that Microsoft Word offers several methods to add Excel content, and this article explains each option in detail.
Inserting Excel Data into Word
In most cases, you may simply copy the required content from Excel sheet and paste it in your Word document. After pasting, a small “Paste Options” box usually appears, allowing you to choose how the data looks (for example: “Keep Source Formatting” or “Use Destination Styles”). However, this will convert the data into a plain table in Word and you will not be able to edit the content using Excel’s feature.
This article focuses on methods that allow you to insert and edit the content as an actual Excel object rather than as a static table. There are several approaches to achieve this and the steps described here apply to the Microsoft 365 version of Word on Windows.
1. Inserting a New Excel Worksheet
You can simply create a new, blank Excel spreadsheet from within Word without ever opening the Excel application separately.
- Open your Word document and go to “Insert” tab.
- Click “Table” icon on the ribbon and select “Excel Spreadsheet” option.

- This will insert an Excel worksheet with tabs and ribbon icons and allows you to enter data as you would in Excel.
- Click outside the Excel object to return to your Word document.
- You can anytime edit the embedded worksheet by double-clicking the Excel table object.

1.1. Create New Excel from Insert Tab
The below steps also will create a blank worksheet in your document.
- Go to “Insert” tab in your Word document and click the “Object” button on ribbon.
- Select “Microsoft Excel Worksheet” under “Create New” tab.
- Click “OK” button.

1.2. Show New Worksheet as an Icon
If you don’t want the Excel to occupy large space in your Word document, then you can simply show the file as an icon.
- Go to “Insert > Object > Create New”.
- Select “Microsoft Excel Worksheet” and check “Display as icon” option.

- Click “OK” button to open an Excel file and create its content.
- Save the content and show it as an Excel file icon.
- You can anytime double-click on the icon to edit its content again.

2. Inserting an Existing Excel Workbook
In most cases, you may need to insert an existing Excel sheet instead of creating a blank sheet.
- Open your Excel file, press Ctrl + A and then Ctrl + C to copy the sheet’s content. Otherwise, select a range of cells, right-click and select “Copy”.
- Switch to Word and place the cursor where you want the data.
- Go to the “Home” tab, click the dropdown arrow under “Paste”, and select “Paste Special…” option.
- In the Paste Special dialog, choose “Microsoft Excel Worksheet Object” option and click “OK”.
- The Excel file will be embedded as an editable object in Word.
- You can double-click to edit the Excel sheet’s content within Word.

Though Word will initially show the copied Excel data, editing will reveal the entire workbook (all sheets in the original Excel file) and not only the copied content. The reason you should copy some content from the Excel as mentioned in the first step is that the “Paste Special…” menu (and the relevant Excel option in the dialog box) will appear in Word only when you have some Excel content in the clipboard. Also, remember that editing in Word will not update the source Excel’s content.
2.1. Display Embedded Excel Workbook as an Icon
This is essentially the same option as explained above but inserting Excel workbook as an icon instead of visual content.
- First, copy some content from your Excel sheet.
- Go to Word “Home > Paste > Paste Special”.
- Select “Paste > Microsoft Excel Worksheet Object” and check “Display as icon”.
- Click “OK” button to insert the entire Excel file in Word as an icon.
- Double-click the file to edit its content without affecting the source file.
2.2. Insert an Existing Sheet Using Embed Option
If you don’t want to deal with copy pasting, then this will be the best option.
- Go to “Insert” menu in Word and click the “Embed” button.
- Go to “Create from File” menu and click the “Browser” button.
- Select your Excel file and click “OK” to insert it.
- You can also select “Display as icon” to show the file icon instead of its content.
3. Linking an Excel File
All the above explained methods allow editing the embedded Excel sheet without updating the source file’s content (and vice versa). However, if you want to showcase a dynamic content (a chat or table) from Excel to Word, then you should link the source Excel so that the content is synchronized between the files.
- Paste Special: Copy some content from Excel. Go to “Home > Paste > Paste Special” in Word and select “Paste link > Microsoft Excel Worksheet Object”. Click “OK” button.

- Embed: Go to “Insert > Embed” in Word and select your Excel file under “Create from file” option. check “Link to file” and click “OK” button.
- In both options, you can choose to embed the file content or display it as an icon as you prefer.

Remember to keep both Word and Excel files in the same folder and don’t change the location. Otherwise, the link will be broken and the Excel’s content will not show in Word. This is the primary reason you should not link files when sharing the content with others, especially if the recipients view the Word file in another platform like macOS.
Frequently Asked Questions on Troubleshooting
Formatting issues often occur because Word applies its own default styles. Try using the “Paste Options” and select a different format to “Keep Source Formatting” to preserve the original Excel design.
If the linked data does not refresh automatically, right-click the object in Word and select “Update Link”. If that does not resolve the issue, the connection to the source Excel file may be broken. Right-click on the Excel icon and select “Linked Object > Edit Link” option to open and save the file to reestablish the link.
Normally, double clicking the embedded Excel object activates editing mode. If it does not, check whether the document is in “Read Only” mode or “Protected View”. These modes restrict editing and must be disabled before changes can be made.
Embedding large Excel files increases the overall document size and can affect performance. If you do not need the data stored inside the Word file, consider linking instead of embedding. For data that no longer needs editing, converting the Excel object into a static image (Home > Paste > Paste Options > Picture) can significantly reduce file size.
Final Words
As you can see, there are multiple ways using Table menu, Paste Special, or Embed option to insert an Excel spreadsheet in your Word document. You can either embed the file’s content or simply link to the source Excel file and both methods support showing an icon or the entire content. Though embedding increases the file size considerably, it avoids breaking the linkage and keep the source Excel content safer. However, if you want to dynamically show a chat or analytical data from Excel, it’s a good idea to link the Excel instead of embedding. Here is a summary of available options and when you to use them.
| Method | Best Used For | Dynamic Updates? | File Size | Editing Location |
|---|---|---|---|---|
| Inserting a new Excel sheet | Creating simple, new tables directly within the document | No | Medium | Full Excel inside Word |
| Embedding as an object | Final reports where you need to preserve a specific version or formatting | No | Large | Full Excel inside Word |
| Linking as an external file | Reports with data that changes frequently, such as weekly statistics | Yes | Small | In the source Excel file |





