In Word for Microsoft 365 on Windows, choose Insert > Object > Object, select Create New > Microsoft Excel Worksheet, then click OK. Turn on Display as icon if you want a compact Excel placeholder rather than a visible worksheet grid. You can also insert an existing workbook as an icon or as a linked file.
In Word, the word placeholder can mean either an embedded Excel worksheet icon or a blank worksheet area waiting for data. Both approaches use an Excel object. Choose an icon when you want a reader to open the spreadsheet separately; choose a visible grid when readers should see or edit spreadsheet cells inside the document. The object is separate from a normal Word table, so Excel formulas and formatting can be used inside it.
What You’ll Need
- Word for Microsoft 365 desktop on Windows for the steps below. The Word desktop app is needed to create and edit embedded Excel objects. Word for the web may display an existing object but does not provide the same object-insertion and editing controls.
- Excel installed if you plan to open or edit the embedded worksheet. Depending on your Office installation, Word may still insert an object when Excel is not immediately available, but you will need a compatible spreadsheet app to work with its contents.
- An existing workbook, if you are inserting one. For a new blank object, you do not need to prepare a spreadsheet file first.
- A saved Word document. Save before inserting, especially if the document is important, and save again after the object is in place.
Step-by-Step
- Decide what the placeholder should do. For an empty area that can later hold spreadsheet data, create a new Excel worksheet object. For a clickable symbol that opens a workbook, insert the workbook and display it as an icon. If Word should show a preview of an existing workbook, insert the file without choosing the icon option. These are different presentations of an object, not the same as adding an ordinary Word table.
- Open the document and choose the insertion point. Click in the paragraph where the object should appear. If the object needs its own line, place the cursor in an empty paragraph. An Excel object is generally treated as an inline object at the insertion point, so it can shift nearby text and affect page layout. Avoid placing it in the middle of a sentence unless that is intentional.
- Open the Object dialog. On the Word ribbon, select Insert. In the Text group, open Object, then choose Object from its menu. If the ribbon is collapsed or the window is narrow, the Text group or Object command may be tucked into a smaller menu. Expand the ribbon or use the command search box to find Object.
- Create a blank worksheet object. In the Object dialog, open the Create New tab. Select Microsoft Excel Worksheet in the object type list. Leave Display as icon cleared if you want a worksheet area visible on the page. Click OK. Word inserts an embedded worksheet, usually showing a small grid that you can populate or resize.
- Use the icon version when you mean a true placeholder. In the same Create New dialog, check Display as icon before clicking OK. Word places an Excel icon at the cursor instead of showing the cells. If the dialog offers Change Icon, use it to choose an available icon or edit its caption so the purpose is clear, such as Sales forecast or Budget workbook. The icon is a visual label; it does not contain a separate workbook unless you create or insert the object.
- Add an existing Excel workbook instead, if needed. Return to Insert > Object > Object and choose the Create from File tab. Click Browse, locate the workbook, and select it. Leave Link to file and Display as icon cleared to show workbook content in Word. Check Display as icon to show a clickable icon. Click OK to insert it.
- Choose whether to embed or link the file. With Create from File, leaving Link to file cleared embeds a copy of the workbook in the Word document. The copy travels with the document, but changes made later to the separate source workbook do not automatically update it. Checking Link to file makes the Word object refer to the source workbook instead. Keep the source file in a stable location and share it with the document recipient, or the link may break.
- Enter or review the spreadsheet content. For a newly created worksheet, double-click the grid or icon to activate the embedded object. Type into cells as you would in Excel, then click outside the object to return to Word. If you inserted an existing workbook, double-click its displayed content or icon to open or edit it, depending on the object type and your Office settings. Save the Word document after editing so the embedded changes are stored.
- Adjust the size and check the page. Click the object once to select it, then drag a corner handle to resize it while keeping its proportions. Avoid dragging a side handle if it makes the content look stretched. For a visible worksheet, enlarge the object enough to show the useful columns and rows. Use Print Layout or print preview to check that the object fits on the page and does not overlap text.
On Mac: Word for Mac has different ribbon and object-dialog options, and availability can vary by Office version. If Insert > Object does not offer the Excel worksheet or icon options, open the workbook in Excel, select the cells, copy them, then switch to Word and use Edit > Paste Special if available. Choose an Excel worksheet object for an editable embedded object, or choose a picture format for a static visual. A pasted range is not always equivalent to inserting an entire workbook. Menu wording and available Paste Special formats can differ between Mac releases.
Common Mistakes
- Choosing a Word table by mistake. Insert > Table creates cells that belong to Word, not Excel. A Word table is useful for simple document data but does not provide an embedded Excel worksheet. Use Insert > Object when you need an Excel object.
- Expecting the icon to show spreadsheet contents. Display as icon deliberately hides the worksheet preview. Double-click the icon to open or edit the object. If readers need to see data immediately, insert the object without the icon option or paste a visible range instead.
- Assuming an embedded workbook updates from the original file. An embedded object is a copy. Editing the original workbook later does not refresh the copy in Word. Choose Link to file only when you specifically want the document to point to the source workbook and can maintain that file path.
- Moving or renaming a linked workbook. A link can stop working when the source file is moved, renamed, or unavailable to the person opening the document. Store linked files in a shared, stable location and test the document from the recipient’s environment.
- Resizing the object until it is hard to read. A small worksheet preview may show only a few cells; enlarging it can also change how much of the sheet is visible. Select the object and adjust its size, then open it to review the complete spreadsheet. Do not assume the page preview shows every row or column.
- Expecting the web version to edit an OLE object. Embedded Excel objects rely on desktop Office features. If you need to create or edit the object, open the file in Word desktop rather than relying on Word for the web.
Tips
- Make an icon self-explanatory. If the object dialog lets you change its caption, use a short label that tells readers what opens when they double-click it. An icon marked Excel object is less useful than one marked Quarterly sales workbook.
- Keep the document portable. Embedding is usually the safer choice when you need to send one self-contained Word file. Remember that embedded workbook contents increase the document’s file size, especially if the workbook contains many sheets, images, or other data.
- Use a link only when live updating matters. Linking can keep displayed content connected to the source workbook, but the source path must remain accessible. It is a poor choice for a document that will be emailed separately from its workbook or archived without its linked files.
- Think about what the reader needs to do. Use a visible worksheet when the data should be part of the page and easy to inspect. Use an icon when the workbook is supporting material or would take too much space. If the reader only needs a readable snapshot and must not edit cells, a picture or pasted table may be more appropriate.
- Test the object after saving. Close and reopen the document, then check that the icon or worksheet still appears and opens as expected. This is especially useful before sending a file to someone using a different computer or Office version.
Troubleshooting
- The Object command is missing. Confirm that you are using the Word desktop app, not Word for the web. On Windows, expand the ribbon and look under Insert > Text > Object. If the ribbon is simplified, maximize the Word window or search for Object in the command search field.
- The inserted object appears as a grid when you wanted an icon. The Display as icon box was probably left unchecked. Delete the unwanted object and insert it again with the icon option selected. If you do not want to recreate it, right-click the object and look for an option to convert or change its display; available commands vary by object and Office build.
- The object appears as an icon when you wanted visible cells. Insert it again and clear Display as icon. If the object is an existing workbook, Word may show a preview or an icon depending on the options selected. Double-clicking the icon opens the workbook, but does not turn it into an on-page grid automatically.
- Double-clicking does not open Excel. First make sure the document is not in Protected View or opened as read-only. Try right-clicking the object and selecting the available worksheet or object editing command. Check that Excel is installed and associated with spreadsheet files. If the file came from another person, confirm that the object was embedded rather than linked to a missing workbook.
- The linked workbook cannot be found. Restore the source workbook to its original folder and name, or update the link to point to the new location using Word’s file-link controls. If you cannot provide a stable source file, replace the link with an embedded copy so the Word document contains the workbook data.
- The worksheet is cut off or moves the text. Select the object and resize it with a corner handle. Check paragraph spacing around it and use print preview to see page breaks. For a wide sheet, consider showing only the relevant columns, using a landscape page for that section, or inserting a compact icon with a descriptive caption instead.
- Someone cannot edit it in Word for the web. Ask them to open the document in the desktop Word app. If that is not possible, share the Excel workbook separately through a location they can access, or replace the object with a static image or table if editing is not required.
Frequently Asked Questions
Is an Excel placeholder in Word the same as a Word table?
No. A Word table is built into the document and is edited with Word’s table tools. An Excel placeholder created as an object contains or represents spreadsheet content and can be opened with Excel. Use a Word table for simple text and figures; use an Excel object when spreadsheet editing or workbook functionality matters.
Can I insert a blank Excel worksheet without creating a separate workbook first?
Yes. In Word for Windows, choose Insert > Object > Object, open Create New, select Microsoft Excel Worksheet, and click OK. Word creates the embedded object in the document; you do not have to save it as a separate workbook before inserting it.
Can I insert just one sheet from an existing Excel file?
You can copy the desired cell range from Excel and paste it into Word, choosing an Excel object format if Paste Special offers one. Inserting a workbook through Create from File generally inserts the workbook object, not just a selected sheet range. For a simple, visible excerpt, copy only the relevant cells instead.
Will edits in Word change my original Excel file?
If you inserted an embedded copy, edits to the Word object affect that embedded copy, not the separate source workbook. If you chose Link to file, Word refers to the source file, so changes and updates depend on that link remaining available. Check which option you selected before relying on updates.
Can I insert an Excel placeholder in Word for the web?
Word for the web does not provide the same controls for creating and editing embedded Excel objects as Word desktop. Use Word for Microsoft 365 on Windows or Mac to insert the object. A web user may need to open the document in the desktop app to work with it.
What is the best option if I only need readers to see the spreadsheet?
Use a visible embedded worksheet or paste the relevant cells as a table or image. An icon is best when readers should open the workbook rather than inspect its data on the page. For a document that must display consistently and cannot depend on Excel being installed, a static image or Word table is often more reliable.
Related
- How to Import an Excel Spreadsheet Into a Word Document
- Import Excel into a SharePoint List: Step-by-Step
- How to Highlight a Row in Excel with a Keyboard Shortcut
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Archive Emails in Outlook 365To archive email in Outlook 365, select a message and choose Archive on the toolbar or ribbon. Outlook…
- Google Sheets Checkboxes: How to Add and Use ThemTo add checkboxes in Google Sheets, select the cells where you want them and choose Insert > Checkbox.…
- Remove a Page Break in Excel: Manual and AutomaticTo remove a manual page break in Excel for Microsoft 365 on Windows, select the cell immediately below…
- Excel Row Limit: How Many Rows Can a Sheet Hold?A worksheet in current Microsoft Excel for Microsoft 365 can hold 1,048,576 rows, numbered 1 through 1,048,576. That…
- Export Outlook Contacts: Steps, Formats, and TipsTo export Microsoft Outlook contacts, open the People or Contacts area and use its export command to save…
- Excel Text to Columns: How to Keep Leading Zeros SafelyYes—Excel Text to Columns can keep leading zeros, but you must set the affected column’s format to Text…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.