Excel Worksheet in Word: How to Insert and Format It

How-to basics · Updated November 20, 2026

To insert an Excel worksheet into Word, use Insert > Table > Excel Spreadsheet for a new, editable sheet, or copy cells from Excel and paste them into Word for existing data. To insert an existing workbook as an object, use Insert > Object > Object > Create from File. The best method depends on whether you need the content to stay editable, update from Excel, or simply appear as a clean table in your document.

What You’ll Need

  • Microsoft Word and Excel for Microsoft 365 on Windows, or desktop versions that support the options described below.
  • An existing Excel workbook if you are inserting or copying data that is already prepared. For a new worksheet, Word can create an embedded Excel sheet for you.
  • A saved location for both files if you plan to link the Word content to a separate Excel workbook. Keep the workbook accessible at that location.
  • A little page space: a wide worksheet may need landscape orientation, smaller text, or fewer columns to fit legibly.

Step-by-Step

  1. Choose how the worksheet should behave. Before inserting anything, decide whether readers need to edit the spreadsheet, whether Word should show future Excel changes, or whether the content just needs to be readable in the document. An embedded object stores a copy of spreadsheet data inside the Word file and can be edited by double-clicking it. A linked object refers to an external workbook and can reflect its updates, but depends on the workbook remaining available. A pasted table or picture is convenient for sharing, but is not the same as an active Excel worksheet. Use the method below that matches your goal.
  2. Save the Excel workbook first if it already exists. In Excel, open the workbook and check the specific sheet and cell range you intend to put in Word. Remove unnecessary columns or rows from the selection, and make sure headings and number formats are clear. Save the workbook with a descriptive name. If you are linking it, decide on a stable folder before linking; moving or renaming the workbook later can break the connection. If the workbook contains several sheets, note which one should be visible when the document opens.
  3. Create a new editable Excel sheet inside Word, if that is what you need. In Word for Windows, click where the sheet should appear, then choose Insert > Table > Excel Spreadsheet. Word places a small embedded spreadsheet at the cursor. Click inside it and enter data, or paste cells from Excel. While the object is active, Excel-style gridlines and editing controls appear; click outside it to return to normal Word editing. Double-click the embedded sheet later to edit it again. This creates a new embedded object, not a live link to a separate workbook.
  4. Copy an existing range when you want a table in the document. In Excel, select only the cells you need and press Ctrl+C on Windows. Switch to Word and click the insertion point. Choose Home > Paste, then select a paste option from the small options button if it appears. Options can include keeping the Excel formatting, matching Word’s document style, or pasting as a picture. The exact labels can vary with Office updates and the copied content. A regular pasted table is often the simplest option when readers should be able to read and edit the cells as a Word table, rather than open an Excel object.
  5. Paste a copied range as an embedded or linked Excel object. In Excel, select and copy the range. In Word for Windows, choose Home > Paste > Paste Special. In the dialog, select Microsoft Excel Worksheet Object. Choose Paste to embed a copy, or choose Paste link if that option is available and you want Word to refer to the Excel source. Confirm with OK. The object may show the selected cells as a compact preview; double-click it to open the worksheet editing view. Linking is useful for data that changes, but it is less portable than embedding because Word needs access to the source file.
  6. Insert an existing workbook as an object from a file. In Word, click where the object should go and choose Insert > Object > Object. Open the Create from File tab, click Browse, select the Excel workbook, and confirm the file selection. Leave Link to file unchecked to embed a copy in the Word document. Check it to link to the external workbook. Select Display as icon if you want a clickable workbook icon instead of a visible spreadsheet preview, then click OK. This inserts the workbook as an object; it is not a guarantee that every sheet in the workbook will be displayed as a full-page table.
  7. Set the visible size and layout. Click the inserted object once to show its sizing handles. Drag a corner handle to resize while preserving its proportions where possible; avoid dragging a side handle if it distorts the preview. For a table pasted as Word cells, select the table and use the layout tools to adjust column widths, or choose Table Layout > AutoFit and an appropriate fit option. If the data is too wide, consider Layout > Orientation > Landscape for the relevant page, narrower margins, or a smaller selection. Check that headings and values remain readable at normal print size.
  8. Test editing, updates, and saving. Double-click an embedded worksheet object to confirm it opens for editing, then click outside it to return to Word. For a linked object, change and save the source workbook, then return to Word and use the object’s right-click update or link command if it does not refresh automatically. The command wording can vary by Office build. Save the Word document as a .docx file, close it, and reopen it to check the result. For a linked file, test on the computer or shared folder where the document will actually be used.

Common Mistakes

  • Choosing a picture when you need editable data. A picture preserves appearance but its cell values cannot be edited as spreadsheet cells. Select an Excel object or a Word table instead.
  • Linking without considering file access. A link can fail if the workbook is moved, renamed, stored on an unavailable drive, or inaccessible to the recipient. Embed the data when the document must work independently, or distribute the linked workbook in a stable shared location.
  • Copying an entire sheet unintentionally. A worksheet can have formatting or used cells far beyond the visible data. Select the intended range in Excel before copying, and inspect the result in Word.
  • Expecting a linked object to behave like a normal Word table. Linked Excel content is managed through its source workbook; editing or formatting it may open Excel. If recipients need to edit individual cells directly in Word, a Word table may be a better fit.
  • Ignoring page width and print appearance. A sheet that looks acceptable on screen can be clipped or unreadable in print. Use Print Layout and, if practical, Print Preview to check the whole range before sharing.
  • Assuming embedding and linking are interchangeable. Embedding increases the Word file size but keeps a copy inside it. Linking can keep content current but creates a dependency. Check the chosen option in the insertion dialog rather than assuming Word selected the one you intended.

Tips

  • Use a Word table for short, mostly static data. It is easy to format alongside surrounding text and travels with the document. Use an embedded object when spreadsheet editing or workbook features matter.
  • Keep the range focused. A few relevant columns are easier to read than a complete working sheet. Remove blank-looking columns, helper calculations, and unrelated notes from the copied selection.
  • Prepare Excel formatting before copying. Set sensible column widths, use descriptive headers, and apply consistent number formats. This reduces the amount of repair needed in Word.
  • Use a linked object only when updates are valuable. Linking works best when you control both files and can keep them together. For email attachments or archival documents, embedding or pasting a table is generally more reliable.
  • Remember that an embedded object is a copy. Changes made later to the original Excel workbook do not automatically update an embedded copy. If the source changes, update the embedded data manually or replace it.
  • Make a backup before changing important documents. Save a separate copy of the Word file before replacing a large object or changing its link. This makes it easier to recover the original layout if the result is not right.
  • Consider the reader’s software. An Excel object may open differently depending on the recipient’s Office version and device. If the document must be easy to view on phones or in basic document viewers, a simple Word table or a clear image may be more dependable.

Troubleshooting

The worksheet does not appear after insertion. If you selected Display as icon, Word is showing an icon by design; double-click it to open the object. Otherwise, check whether the object is very small, positioned on another page, or hidden by surrounding content. Use Print Layout, click near the insertion point, and look for the object’s outline or sizing handles.

The spreadsheet is cut off at the page edge. Reduce the selected range, resize the object from a corner, or change the relevant page to landscape orientation. For pasted Word tables, adjust column widths or use AutoFit. If the content must remain legible, splitting a wide sheet into two smaller tables is often better than shrinking it until the text is too small to read.

The content does not update when Excel changes. First check whether you inserted a link or an embedded copy. An embedded copy does not track changes in the source workbook. For a linked object, make sure the source file still exists at its original location, open and save it, then use the update option from the object’s context menu. If Word cannot find the workbook, relink or insert it again from its current location.

The Paste Special choice is missing. Confirm that you copied cells in the desktop Excel app, not just text from another program, and try copying the range again. Some Office versions, file types, and paste contexts show fewer choices. You can use a regular paste for a Word table, or insert an Excel object through Insert > Object. If the document is open in Word for the web, open it in the desktop app for the full object-insertion controls.

The object opens in Excel instead of editing in place. This can be normal, depending on the object type and Office configuration. Double-click the object or use its right-click menu to open or edit it. If recipients should not need to open Excel, paste the content as a Word table or picture instead.

The Mac menu looks different. Word and Excel for Mac have similar ways to copy and paste, but the ribbon labels, Paste Special options, and object-link controls may differ by version. Use the Mac menu or ribbon’s Paste Special command when available, and look for the Excel worksheet object option. The Windows path Insert > Object > Object > Create from File may not match the Mac interface exactly; if the required link option is absent, paste an embedded copy or a Word table. On Mac, use Command+C and Command+V in place of Windows Ctrl+C and Ctrl+V.

Frequently Asked Questions

Can I insert just one Excel worksheet rather than the whole workbook?

Yes. To show selected data, copy the desired cells from that worksheet and paste them into Word as a table or Excel worksheet object. When inserting a workbook from a file, Word inserts the workbook object, not a hand-picked range as a formatted Word table. For precise control over the visible cells, select and copy the range in Excel first.

Will an Excel worksheet in Word update automatically?

Only a linked object can reflect later changes from its Excel source, and it needs access to that workbook. An embedded object is a stored copy, while a pasted Word table or picture is separate from the original sheet. If keeping the content current is essential, confirm that you selected Paste link or Link to file.

Can I edit the inserted worksheet in Word?

You can edit an embedded Excel object by double-clicking it; Word activates spreadsheet editing for that object. A linked object can also be opened or edited through its source, subject to access and permissions. A pasted Word table is edited using Word’s table tools, and a pasted picture is not cell-editable.

What is the best way to insert Excel data for printing?

For a small, simple range, paste it as a Word table and check the page in Print Layout. For complex formatting that must look like Excel, use an embedded object or picture, then check its size and page orientation. A linked object is not automatically better for printing; choose it when updates from the source matter.

Can I insert an Excel worksheet in Word for the web?

Word for the web can handle common pasted content, but it does not provide all the desktop object and linking controls. If you need to embed or link an Excel workbook, open the document in desktop Word and use its Insert or Paste Special options. A regular pasted table is a practical alternative when desktop Word is unavailable.

Why did the Word file become much larger?

Embedding a workbook stores spreadsheet content inside the document, so the Word file can grow, especially if the workbook contains several sheets, formatting, or other data. If size matters, insert only the needed cell range or paste a Word table. Linking can reduce the amount stored in Word, but the linked workbook must remain available to anyone who needs to view or update it.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.