To insert an Excel sheet into Word, copy the cells you need from Excel and paste them into Word, or use Insert > Object to embed or link a workbook. Pasting a selected range is usually best when readers need to see the data in the document; embedding or linking is better when they may need to open or update the workbook. Before you start, decide whether the content should be editable, linked to the original file, or simply easy to read.
What You’ll Need
- Microsoft Excel and Word for Microsoft 365 on Windows, with the workbook you want to use.
- A saved copy of the workbook if you plan to link it. Word needs to be able to find that file later.
- A rough idea of how much data should appear on the page. A compact range is easier to read than a full worksheet with many columns.
The instructions below are for the desktop apps. Word and Excel for the web have fewer options for inserting and managing embedded or linked objects. On a Mac, the names and locations of Paste Special and Object commands can vary slightly by Office version; notes are included where the difference matters.
Step-by-Step
- Paste a selected range for a visible, editable table. In Excel, open the workbook and select the cells you want to include. Include headings, but avoid selecting entire columns or rows unless you really need them. Press Ctrl+C on Windows, or Command+C on Mac. In Word, place the insertion point where the table should appear. Choose Home > Paste to use the default paste behavior, or select the arrow beside Paste to review the available options. Choose Keep Source Formatting if matching the spreadsheet’s colors, borders, and number formats is important. Choose Use Destination Styles if the table should match the Word document’s fonts and colors. The pasted range appears directly on the page, where you can edit its cell content and adjust its table layout. Depending on the paste option, Word may treat it as a Word table or as an Excel object.
- Paste the range as an Excel object when spreadsheet editing matters. After copying the cells in Excel, click in Word where the range should go. In Windows Word, choose Home > Paste arrow > Paste Special. Select Paste, then choose Microsoft Excel Worksheet Object from the list and click OK. The selected cells appear as an embedded Excel object. Double-click the object in Word to open its spreadsheet editing view; click outside it to return to the document. This is useful when you want to preserve Excel behavior, such as cell formatting or formulas, but still show only a chosen range. The object is stored in the Word file, so changing the original workbook later does not automatically change this pasted copy. On Mac, try Edit > Paste Special or the Paste Special command on the Home tab, then select the Excel worksheet option if it is offered. If the object option is unavailable, paste the range normally or use the Insert Object method below.
- Embed a workbook when you want to include the file itself. In Word for Windows, choose Insert > Object, then choose Object again in the dialog if needed. Open the Create from File tab, click Browse, select the Excel workbook, and click Insert. Leave Display as icon unchecked if you want Word to show a preview of the workbook content; check it if you would rather place a workbook icon that readers can double-click. Click OK. The workbook is now embedded in the Word document, making the Word file larger but keeping the workbook data inside it. To edit the embedded file, double-click its preview or icon. Changes made this way affect the embedded copy, not the original Excel file. On Mac, look for Insert > Object and the option to create an object from a file. If those commands are missing in your version, use a copied range instead.
- Link a range or workbook when Word should reflect the source file. To link a range, copy the cells in Excel, then in Word choose Home > Paste arrow > Paste Special. Select Paste link, choose Microsoft Excel Worksheet Object, and click OK. For a workbook file, use Insert > Object > Create from File, browse to the workbook, and check Link to file before clicking OK. A linked object refers to the Excel file instead of storing a separate, fully independent copy. Keep the workbook in its current location and do not rename it unless you are prepared to repair the link. When you open the Word document, Word may ask whether to update links; allow the update only when you trust the source and want the latest data. Mac versions may offer fewer Paste Special linking options, so check the dialog available in your installation.
After inserting any method, save the Word document and check it in Print Layout. If the data is wider than the page, change the page orientation or reduce the selected range rather than shrinking it until the text is difficult to read.
Common Mistakes
Copying too much data. Selecting a whole worksheet can create a huge object, make Word slow, or produce content that is unreadable on a normal page. Select only the used cells that readers need. If the worksheet has several sections, consider inserting separate ranges with headings instead of one oversized block.
Assuming every paste stays connected to Excel. A normal paste usually creates a snapshot or a Word table. It does not necessarily update when the source workbook changes. Choose Paste Special > Paste link when you need a connection, and test that connection after saving both files.
Moving a linked workbook after inserting it. A link can break if the Excel file is renamed, moved, or stored somewhere Word cannot access. Keep linked files together in a stable folder, especially when sharing the document. Sending only the Word file may not be enough for another person to see updated linked data.
Choosing Display as icon by accident. This option places an icon rather than a visible sheet preview. That can be appropriate for an attachment, but it may confuse readers expecting to see the data on the page. If the object appears as an icon, edit its object settings or remove it and insert the file again without that option.
Expecting a worksheet to fit automatically. Word pages have fixed printable dimensions, while worksheets can extend across many columns. A pasted range may be clipped, scaled, or hard to read. Check the full width and height in Print Layout and in print preview before sharing the document.
Tips
For a report that needs to look polished, tidy the range in Excel before copying it. Set sensible column widths, remove empty rows and columns, use clear headings, and apply number formats there. Word is useful for document layout, but Excel is usually easier for preparing spreadsheet cells consistently.
Choose the paste behavior based on the reader’s task. Use a Word table when people mainly need to read or edit text in Word. Use an embedded Excel object when they should be able to open and work with spreadsheet cells without relying on a separate source file. Use a linked object only when updates from the original workbook are important and the file path can remain available.
For a wide range, try changing the relevant Word section to landscape orientation: place the cursor in that section, then choose Layout > Orientation > Landscape. If only one table needs landscape pages, insert section breaks before and after it and apply the orientation to that section. You can also reduce page margins with Layout > Margins, but keep enough space for printing.
Use descriptive labels near the inserted data, such as a short heading and a note about the reporting period. If the range is linked, identify the source workbook or explain that the values update from a file. This helps readers understand what they are seeing and reduces confusion if the numbers change later.
Finally, test the document on another computer or account if you intend to share it. Confirm that embedded objects open, linked workbooks can be reached, and the table remains legible when exported to PDF or printed. A link that works on your computer may not work for someone who does not have access to the same folder or network location.
Troubleshooting
The sheet appears as an icon instead of cells. When inserting a file, return to Insert > Object > Create from File and clear Display as icon before confirming. If you have already inserted it, delete the icon and insert the file again with the box cleared. Keep the icon if your goal is to attach an openable workbook without displaying its contents.
The data is cut off or too small. First return to Excel and select a narrower range, then insert it again. In Word, try landscape orientation, narrower margins, or a larger page size if appropriate. For a long or very wide dataset, split it into smaller tables or include a readable summary in Word and provide the workbook separately. Avoid reducing the size so far that people cannot read the values.
The Word table does not look like Excel. Undo the paste if possible, copy the cells again, and choose Keep Source Formatting or Paste Special > Microsoft Excel Worksheet Object. Check number formats and column widths in Excel before copying. Some formatting or interactive spreadsheet features may not carry over as expected, so verify the result in Word.
A linked object shows old data or a link warning. Confirm that the source workbook still exists at the same path and that you can open it. In Word, right-click the linked object and look for an update or link option; wording varies by version. If the file has moved, restore it to its former location or re-create the link from the new location. If you do not need automatic updates, replace the link with an embedded or pasted copy.
Double-clicking does not open the spreadsheet for editing. Make sure you inserted an Excel object rather than a plain Word table or picture. If the object is embedded, try right-clicking it and choosing the available worksheet or object editing command. If you inserted a picture, it cannot be edited as spreadsheet cells; delete it and paste the range again using an Excel worksheet object option.
Frequently Asked Questions
Can I insert an entire Excel worksheet into Word?
You can embed the workbook with Insert > Object > Create from File, or copy a selected worksheet range into Word. A worksheet can contain more columns and rows than a Word page can display clearly, so embedding the file does not guarantee that every cell will appear as a readable page table.
Will the inserted Excel data update when I change the workbook?
Only a linked object is intended to update from its source workbook. A normal paste and an embedded workbook are separate copies. Linked updates depend on Word being able to find the original file, and Word may ask whether to refresh the data.
Can I edit the inserted sheet in Word?
A pasted Word table can be edited as a table. An embedded Excel object can be opened by double-clicking it and edited with spreadsheet tools. A linked object can also be opened, but changes and updates depend on the source workbook and the link settings.
What is the difference between embedding and linking?
Embedding stores a copy of the workbook inside the Word document. Linking keeps a reference to a workbook stored elsewhere. Embedding makes the Word file larger but more self-contained; linking can show updated source data but can fail if the source file is moved or unavailable.
Can I insert an Excel sheet in Word Online?
Word for the web supports basic editing and may display content inserted in the desktop app, but it does not provide the same full set of object and linking controls as Word for Windows. Use the desktop version of Word to embed or link a workbook, then save the document for viewing online.
How do I make the inserted sheet fit on one page?
Start by inserting only the cells that matter, then try landscape orientation and narrower margins. For particularly wide data, splitting it into sections or using a summary table is usually clearer than forcing every column onto one page.
Related
- How to Hide Rows in Excel: Keyboard Shortcuts Guide
- Google Sheets: Highlight Duplicate Values with Color
- Hide in Excel: Keyboard Shortcuts for Rows, Columns & Sheets
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Merge Cells but Keep All Text in Excel: Safe MethodsIn Excel, merging cells normally keeps only the value in the upper-left cell and removes the contents of…
- How to Create Labels in Word With an Image and Print ThemTo create labels in Word with an image, choose the matching label-sheet layout, open it as a document,…
- Add Checkbox in Excel: Steps to Insert and Link OneTo add a checkbox in Excel for Microsoft 365 on Windows, select the cell or range where you…
- How to Mail Merge in Word UK: Step-by-Step InstructionsTo mail merge in Word, prepare a recipient list in Excel, connect it through Word’s Mailings tab, insert…
- Conditional Formatting in Microsoft Forms: What Works?Microsoft Forms does not have a built-in conditional-formatting feature for changing question or answer colors based on a…
- How to Automatically Add Page Numbers in Microsoft WordTo automatically add page numbers in Word, open the document and choose Insert > Page Number, then select…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.