Excel Table in Word: Insert, Link, or Embed an Excel File

To put Excel data in a Word document, select and copy the cells in Excel, then paste them in Word; choose a paste option that suits your needs. For a worksheet you can edit inside Word, use Insert > Table > Excel Spreadsheet. Choose a linked version when the Word document should reflect changes to a separate Excel file, or an embedded version when the workbook should travel with the document.

Choose the right way to add Excel data

There is no single best method: the right choice depends on whether readers need to edit the numbers, see future updates, or simply read a clean table. A pasted range is usually the simplest option for a report that is nearly finished. A native Word table is useful when the content should follow the document’s layout and be edited with Word’s table tools. A linked or embedded Excel object is more appropriate when spreadsheet behavior matters.

Paste as a Word table: Creates cells that can be formatted with Word’s table features. It is convenient for ordinary text and figures, but does not preserve Excel formulas as working formulas.
Paste as a picture: Keeps the visual appearance fixed. It is useful for a chart-like layout or a table that must not reflow, but readers cannot edit its cell contents as a table.
Link to Excel: Keeps a connection to a separate workbook, so the Word content can be updated from its source. The source file must remain available at its linked location.
Embed an Excel worksheet: Stores a copy of the spreadsheet object in the Word file. It can be opened and edited from Word, but edits to the original workbook do not automatically become edits to the embedded copy.

These options are not interchangeable. For example, an ordinary pasted Word table may look like the Excel range but will not recalculate a formula when its source cells change. If recalculation or spreadsheet editing is required, use an Excel object rather than relying on the appearance of pasted cells.

Paste a range as a Word table

For a straightforward table, copy the desired range in Excel and paste it into Word. In Excel for Microsoft 365 on Windows, select the cells and press Ctrl+C. In Word, click where the table should begin and press Ctrl+V. On a Mac, use Command+C and Command+V. Word usually inserts the copied cells as a table, but the exact appearance depends on the paste choice, the source formatting, and the versions of Office involved.

When paste options appear, choose the one that best fits the document. Keep Source Formatting is intended to retain more of Excel’s appearance; Use Destination Styles adapts the content to Word’s styles. If the default result is unsuitable, open Word’s Home > Paste menu or use Paste Special to inspect the available formats. Choices can vary by Office version and by what was copied. A picture option preserves a fixed image, while a text or formatted-text option is more suitable when the content should remain editable in Word.

Before copying, remove anything that should not appear in the report. Select only the needed cells rather than the entire worksheet, and consider whether hidden rows, column headings, totals, or notes belong in the final document. If a range is very wide, simplify it or plan to use a landscape page; a large spreadsheet pasted at its original width can become difficult to read in a standard portrait page.

Insert an Excel worksheet inside Word

To create an editable Excel grid directly in a Word document, click the insertion point and choose Insert > Table > Excel Spreadsheet in Word for Microsoft 365 on Windows. Word places a worksheet object in the document. You can enter or paste data into its cells, and Excel-style controls become available while the object is active. Click outside the object to return to normal Word editing.

This method is useful for a small calculation or a compact data area that needs spreadsheet behavior. It is not always the best way to include a large analysis workbook: a worksheet object occupies space on the page, may be awkward to navigate in a long report, and can make the Word file larger. If the worksheet is too large to read at normal page size, consider adding a concise Word table and providing the workbook separately.

The worksheet inserted this way is part of the Word document, not a live window onto an existing workbook. Treat it as a separate copy: changing the original Excel file will not update it automatically. Interface labels and object-insertion options can differ in Word for Mac and Word for the web. For creating or managing Excel objects, use the desktop version of Word and check the options available in that version.

Link a Word table or object to an Excel workbook

A link is useful when Excel is the source of truth and the Word document should be refreshed from that source. In Excel, copy the cells. In Word for Windows, use Home > Paste > Paste Special, then choose a linked Excel format if it is offered. The wording in the dialog can vary. Another route for a workbook object is Insert > Object > Object > Create from File, browse to the workbook, and select Link to file before confirming. The latter inserts a workbook object; it is not necessarily the same as a neatly sized range of cells.

A linked item depends on the source workbook. Keep the workbook in a stable location, and do not rename or move it without checking the link. If a colleague receives only the Word file, they may not have access to the linked workbook or its network location. They may see the last saved display, be asked to update the link, or be unable to refresh it. Link-update prompts can also be affected by Office security settings, so do not enable updates from an unknown source without verifying the file.

When the Excel values or formatting change, Word may not refresh the displayed content immediately. Depending on the link and Office settings, you can right-click the linked item and choose Update Link. If the source cannot be found, use the link-management options in Word to inspect or change the source rather than assuming the numbers are current. For a document that must remain self-contained, embedding or pasting a final snapshot is often more reliable than a link.

Embed a workbook rather than link it

Embedding stores the workbook object within the Word document. In Word for Windows, choose Insert > Object > Object > Create from File, browse to the Excel workbook, and leave Link to file unchecked. Select Display as icon if you prefer an icon instead of a visible worksheet preview. Otherwise, Word may show workbook content in the document. Double-clicking an embedded object generally opens it for editing in the associated Office application.

Embedding is useful when recipients need access to the spreadsheet data but should not depend on a separate file path. It also means the embedded workbook can become outdated: edits made to the original Excel file after insertion do not flow into the copy in Word. If you need to revise the embedded copy, edit that object from Word and save the document. Avoid confusing this with a link, which refers to an external source rather than storing an independent workbook copy.

Consider file size and sharing needs. An embedded workbook adds its contents to the Word file, and a complex workbook can noticeably increase the document’s size. If the workbook contains information that should not be shared, embedding it may expose that information even if only a small range is visible in the document. Review the workbook’s sheets and contents before inserting it.

Convert spreadsheet data into a native Word table

A native Word table is often the best choice for a polished document that will be edited primarily in Word. Copying and pasting a cell range commonly creates an editable Word table. You can then adjust its borders, alignment, column widths, shading, and text using Word’s table tools. The table can flow with the surrounding paragraphs, unlike a large worksheet object that may behave more like a separate item on the page.

For plain text that is separated by tabs or another consistent delimiter, Word can also convert text into a table. Place the cursor in the text, then choose Insert > Table > Convert Text to Table and review the separator and column settings before confirming. This is helpful when a pasted range arrives as lines of text instead of cells. It is not a way to preserve Excel calculations: formulas are not turned into working Word formulas by conversion.

Once the data is a Word table, it can be sorted in some cases using Word’s table tools, but it does not provide the full calculation, charting, and data-analysis environment of Excel. If the document needs regularly updated values, keep the authoritative calculations in Excel and either link the relevant range or paste refreshed values before distributing the report.

Fit and format the table on the page

A table that looks good in Excel may not fit the page in Word. Spreadsheet columns can be wider than the printable area, and a Word page has margins, headers, and footers to account for. After pasting, inspect the document in Print Layout and check that headings, figures, and the final column are visible. Avoid shrinking text until it is unreadable just to force a wide table onto one page.

Use a landscape page for a wide table when the surrounding document can accommodate the change.
Shorten unnecessarily long column headings, while keeping their meaning clear.
Remove empty columns and rows before copying, and use a smaller relevant range instead of an entire sheet.
For a Word table, adjust column widths or use the table layout controls to fit the contents or page.
For a fixed visual snapshot, consider pasting as a picture, then check its size and clarity at the document’s print scale.

Formatting can change between applications. Excel number formats may appear differently after conversion, and a Word style can replace some source colors or fonts. Review dates, decimal places, percentages, currency symbols, and negative numbers carefully. A percentage such as 0.25 might be displayed as 25% in Excel; if the pasted result is plain text or values, verify that readers see the intended representation rather than an unexplained decimal.

Common problems and practical fixes

If only part of a selection appears, confirm that the intended cells were selected before copying and that the paste location is not inside an existing table cell. If the result is a picture rather than editable cells, undo the paste and choose a table or text-based paste option. If a linked range displays old values, verify that the Excel source is accessible and update the link; do not assume a stale preview reflects the latest workbook.

Unexpected row heights or column widths often come from the difference between spreadsheet and page layouts. Try pasting with destination styles, reducing the range, or changing page orientation. If formulas appear as values, that is normal for a Word table paste: the displayed result was copied, but Word does not retain Excel’s cell-calculation system. Keep calculations in the workbook or insert an Excel object when that functionality is needed.

For sharing, decide whether recipients need the source file. A link is compact but depends on access to the workbook. An embedded copy travels with the document but can be larger and can become stale. A Word table or picture is simpler to distribute but should be treated as a snapshot unless someone refreshes it manually.

Frequently Asked Questions

Can I insert an Excel table in Word and keep it editable?
Yes. Copy the range and paste it as a Word table for ordinary cell editing, or use Insert > Table > Excel Spreadsheet to create an Excel worksheet object. The first is edited with Word’s table tools; the second retains spreadsheet-style editing.

Will an Excel formula still work after I paste the cells into Word?
Not as a working Excel formula in a normal Word table. Word generally receives the displayed cell content, not a live calculation tied to Excel cells. Use an Excel object if the spreadsheet calculations need to remain available.

How do I make a Word table update when Excel changes?
Paste the cells using a linked Excel paste option, or insert a linked workbook object through Insert > Object > Object > Create from File and select Link to file. Keep the source workbook accessible, then update the link when needed.

What is the difference between embedding and linking an Excel file?
An embedded workbook is a copy stored inside the Word document; changes to the original workbook do not update that copy. A linked object refers to an external workbook and can be refreshed from it, but may stop working if the file is moved or unavailable.

Can I do this in Word for the web?
Basic copying and pasting may work, but the web app does not provide the same full set of desktop object and link-management controls. Use desktop Word when you need to create, embed, or troubleshoot an Excel object.

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.