To put Excel data in Word, copy the cells you want in Excel and paste them into Word as a table, or use Word’s Insert > Object command to add a workbook as an embedded or linked file. Copying a range is usually best for a readable report; linking or embedding is better when readers need the workbook itself. Before starting, decide whether the Word document should update when the Excel file changes.
What You’ll Need
- A desktop version of Microsoft Excel and Word for Microsoft 365 on Windows for the full set of object and linking options. Word for the web has more limited support for embedded objects.
- The Excel workbook saved in a known folder. If you plan to link to it, keep it there and share it with the Word document.
- A clear idea of what you want to include: selected cells, a whole workbook as an object, or a non-editable visual copy.
- Enough room on the Word page for the table or object. A wide worksheet may need a landscape page or smaller print area.
Step-by-Step
- Choose the import method. Use a pasted table when readers need to see the figures in the document and you want to format them like Word content. Use a linked Excel object when the document should reflect later changes in the workbook. Embed the workbook when recipients need the Excel content but the Word file must carry its own copy. Paste as a picture when appearance matters more than editing. These choices are not interchangeable: a normal pasted table does not automatically stay in sync with Excel.
- Prepare the Excel data. Open the workbook in Excel and select the worksheet and cell range to include. Check that headings are clear, unnecessary columns are removed, and numbers show the intended decimal places, dates, and currency. If the range is very wide, consider importing only the relevant columns or splitting it into smaller tables. Save the workbook before importing, especially if you will create a link or an embedded workbook object.
- Copy the cells in Excel. Drag across the cells, or click the first cell and hold Shift while selecting the last cell. Press Ctrl+C on Windows. On a Mac, press Command+C. To copy a whole worksheet, click the square at the upper-left corner between the row numbers and column letters, then copy; however, a full-sheet selection can create a very large table, so use it only when you need all the cells.
- Paste the range as a Word table. Open the Word document and click where the table should begin. Press Ctrl+V on Windows or Command+V on Mac. Word normally inserts the selected cells as a table. After pasting, use the Paste Options button if it appears. Choose an option that keeps the Excel formatting when the colors, borders, and number formats are important, or use destination formatting when the table should match Word’s existing style. Available options can vary with the selected content and Office version.
- Adjust the table to fit the page. Click inside the pasted table. Use the table layout controls to adjust column widths, or select the table and choose Table Layout > AutoFit > AutoFit Window in Word for Windows. This fits the table to the available page width, though it can make columns narrow. If the table remains too wide, change that page to landscape using Layout > Orientation > Landscape, reduce margins, or remove less important columns. Check the printed or PDF view as well as the editing view.
- Insert a workbook as an object when you need the file itself. In desktop Word for Windows, click the insertion point, then choose Insert > Object > Object in the Text group. In the dialog, open the Create from File tab and select Browse. Find and select the Excel workbook, then choose Insert. Leave Display as icon unchecked to show a preview of the worksheet object in the document; select it to show a clickable icon instead. Choose OK. Double-clicking an embedded object usually opens it for editing in Excel.
- Decide whether the object should be linked or embedded. In the Create from File tab, select Link to file to make Word refer to the workbook at its saved location. Changes to the source workbook can then be reflected in Word when links are updated. Leave Link to file unchecked to embed a copy inside the document. An embedded copy travels with the Word file but does not automatically track later edits to the original workbook. If you select Display as icon, the object appears as an icon rather than a worksheet preview. On a Mac, object-insertion options and labels vary by Word version; copying and pasting a range is the most consistent cross-platform method. Use desktop Word if the Object command is unavailable in Word for the web.
- Check and save the result. Review the document in Print Layout and confirm the imported content is readable, not clipped, and on the intended page. Save the Word document. If you linked the file, keep the workbook at its current path and send or store it with the document; a link to a file on your computer may not work for someone else. If you embedded it, check that the Word file size is acceptable and that double-clicking the object opens the expected workbook.
Common Mistakes
Expecting a pasted table to update automatically. A normal copy-and-paste makes a separate Word table. Later changes in Excel will not appear there unless you paste again. Choose a linked paste or linked object if a live connection is required, and understand that the source file must remain available.
Linking to a workbook that will be moved or renamed. Word stores a reference to the file location. If the workbook is moved, renamed, or kept on a drive another reader cannot access, the link can break. Put related files in a shared folder and keep their names and locations stable.
Importing too much data. A complete worksheet can make Word slow, unwieldy, or difficult to print. Select only the needed range and verify the number of rows and columns before copying. Large datasets are often easier to share as a separate workbook, with a concise summary in Word.
Assuming an embedded object is the same as a linked object. An embedded workbook is a copy held inside the document, so edits to the original workbook do not refresh it. A linked object relies on the separate source workbook. Pick the behavior intentionally and tell recipients which file they need.
Ignoring layout and accessibility. A table that looks fine in Excel may be too wide in Word, and a picture of a table is not as accessible or editable as real text. Keep a header row, use a readable font, and avoid relying on color alone to explain meaning.
Tips
- For a report that should be easy to read, paste a focused cell range as a Word table, then apply a Word table style and check that headings repeat or remain visible where needed.
- For a stable visual snapshot, paste the copied range using Word’s Paste Special options and select a picture format when offered. The result will not behave like spreadsheet cells, but it is less likely to reflow or be accidentally edited. Menu choices can differ by Office version.
- Use a linked object only when keeping Excel as the source of truth matters more than portability. Place the workbook and Word file in a shared location, and confirm that intended readers have permission to both.
- Use an embedded object when the recipient needs to open the workbook from Word but should receive a self-contained document. Remember that embedding can increase the Word file size and stores a copy of the workbook’s contents.
- For a wide table, test landscape orientation and page margins before shrinking text. Tiny type may technically fit but can make the data unusable on screen or on paper.
- On Mac, use Command+C and Command+V rather than the Windows Ctrl shortcuts. Word’s ribbon organization and available Object options can differ; if the object route is missing, paste the required range or use desktop Word for Windows for the documented Create from File steps.
Troubleshooting
The table pastes with unexpected formatting. Undo the paste with Ctrl+Z on Windows or Command+Z on Mac, then paste again and use the Paste Options button to try a different formatting choice. You can also select the table in Word and apply a Word table style. If fonts, fills, or borders are distracting, paste as plain text if that option appears, then convert or format the text as needed.
The table is cut off or runs past the margins. Select the table and use AutoFit to fit it to the window, or switch the relevant page to landscape. Reduce margins or adjust column widths, and check whether a long entry is forcing one column to expand. If it still cannot fit at a readable size, split the range or use a linked or embedded workbook instead of forcing the entire sheet into the page.
The Excel object appears as an icon instead of a preview. When inserting the file, clear Display as icon if you want a worksheet preview. If the object is already inserted, delete it and insert it again with the desired setting. The icon itself is not a sign that the workbook failed to import; double-click it to open the embedded or linked file.
A linked workbook cannot be found or updated. Check that the source workbook still exists at the same path and that you can open it. If it has been moved, recreate the link from the new location or restore the original path. If a prompt asks whether to update links, update only when you trust the source and want its current data. For sharing, use a location accessible to the recipient rather than a personal local folder.
The Object command is missing or disabled. Check that you are using the desktop Word app and that the document is editable rather than restricted. Word for the web may not offer the same object-insertion controls. Open the document in the desktop app, or copy and paste selected cells as a table. If the workbook format is unsupported or protected, open and save a usable copy in Excel first.
Frequently Asked Questions
Can I insert an entire Excel workbook into Word?
Yes. In desktop Word for Windows, use Insert > Object > Object > Create from File and select the workbook. Embed it for a self-contained copy, or select Link to file if it should refer to the separate workbook. The visible preview is not necessarily a convenient way to display every sheet, so recipients may need to open the object in Excel.
How do I keep an Excel table updated in Word?
Use a linked paste or a linked object rather than an ordinary paste. For a range, copy it in Excel, then in Word use Home > Paste > Paste Special and choose Paste link with an appropriate Excel or formatted representation if that option is available. The source workbook must remain accessible, and the link may need to be updated when Word opens.
Can I edit Excel cells after importing them?
A pasted Word table can be edited as a Word table, but it is no longer the original Excel range. An embedded Excel object can be opened and edited in Excel from Word. A linked object uses the separate workbook as its source; edit that workbook and update the link to reflect changes.
Can I import Excel into Word without showing gridlines?
For a pasted range, turn off worksheet gridlines in Excel or format the selected cells before copying; the appearance depends on what is copied and the paste option used. For a linked or embedded object, adjust the worksheet display in Excel and check the object preview. A picture paste gives the most fixed appearance but cannot be edited as cells.
Does this work in Word for the web?
You can paste many copied cell ranges into a Word document in a browser, but object embedding and link controls are limited compared with desktop Word. For a linked or embedded workbook, open the document in the desktop app and use the Object steps. Check pasted tables in the browser because formatting may differ from desktop Word.
Which method should I choose for a final report?
Use a Word table for data readers need to scan or edit directly in the report. Use a picture for a fixed visual snapshot, an embedded workbook when the recipient needs a self-contained Excel copy, and a linked object when updates from a separate shared workbook are important.
Related
- How to Find a Grade in Excel
- Goal Seek in Excel: How to Find and Use It Step by Step
- Find the Financial Year From a Date in Excel Easily
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 Insert a CAC Signature in WordTo sign a Word document with a CAC, open it in the desktop version of Word for Windows,…
- Excel Repair Software Free Full Version: What Works?There is no legitimate universal “free full version” of Excel repair software that can guarantee recovery of every…
- Excel Consolidate Multiple Sheets: Steps and OptionsTo consolidate multiple sheets in Excel for Microsoft 365 on Windows, go to Data > Consolidate, choose a…
- Excel Page Break Based on Cell Value: How to Set ItExcel cannot create a page break directly from a cell value with a worksheet formula or built-in conditional…
- Color Duplicates in Google Sheets: Conditional FormattingTo color duplicate values in Google Sheets, select the cells, open Format > Conditional formatting, choose Custom formula…
- How to Rename a Sheet in Excel Using the KeyboardIn Excel for Microsoft 365 on Windows, select the worksheet you want to rename, then press Alt, H,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.