How to Import an Excel Table Into Word and Keep It Updated

How-to basics · Updated November 20, 2026

To import an Excel table into Word, select and copy the cells in Excel, then paste them into Word. Choose a regular paste for an editable Word table, or use Paste Special to preserve Excel formatting, link the data to the workbook, or embed an Excel object. Before you start, decide whether the Word copy needs to change when the spreadsheet changes; that choice determines the best method.

What You’ll Need

  • Microsoft Excel and Word for Microsoft 365 on Windows. The steps also work in many recent desktop versions, though paste menus can differ slightly.
  • The Excel workbook containing the table, saved in a location you can access. If you want a linked table, keep the workbook in a stable location.
  • A Word document where you have permission to edit and enough page space for the table.
  • For a linked result, access to both the Word document and the source workbook whenever you need to refresh the data.

Step-by-Step

  1. Choose how the table should behave. A pasted Word table is convenient when you want to edit cells in Word and do not need future Excel changes to flow through. A formatted Excel range keeps more of its spreadsheet appearance but is still a snapshot. A linked paste can update from the workbook, while an embedded object stores a copy of spreadsheet content inside the Word file. Linking is useful for frequently changing figures; embedding is useful when readers need access to spreadsheet content but the Word document must travel independently.
  2. Prepare the range in Excel. Open the workbook in the desktop Excel app and review the cells you intend to transfer. Include the header row if readers need column labels. Remove temporary notes or unused rows, check number formats, and make sure formulas display the values you want readers to see. If you only want part of a larger Excel table, select just that range. Saving the workbook first is especially helpful if you plan to link or embed it.
  3. Copy the cells. Select the table or range in Excel, then press Ctrl+C on Windows. To select an Excel table, click inside it and use the table’s selection controls, or drag across the exact cells you need. Confirm that the moving dashed outline surrounds the intended range; copying an entire worksheet or selecting extra blank rows can make the Word result unwieldy. On a Mac, use Command+C.
  4. Paste an editable Word table. Click in the Word document where the table should begin. On the Home tab, open the Paste menu and choose the ordinary paste option, or press Ctrl+V on Windows (Command+V on Mac). Word will usually paste the cells as a Word table. You can then select the table and use Word’s table layout and design controls to adjust its width, borders, alignment, and text. This is usually the simplest choice for a report that needs ordinary Word editing.
  5. Keep more of Excel’s formatting. After copying, in Word select Home > Paste and look at the paste choices. Choose Keep Source Formatting if it is offered and you want Excel’s cell appearance, such as fills, borders, and number formatting, to carry over. Depending on the selected paste option and Office version, Word may represent the result as a table or formatted content. Inspect the pasted result rather than assuming that every Excel feature, such as conditional formatting or interactive filters, will behave exactly as it did in Excel. Paste options can also appear beside the pasted content; select one there to change the result.
  6. Link the pasted range if it must stay current. In Word, choose Home > Paste > Paste Special. In the dialog, select Paste link, then choose an available Excel worksheet or formatted-text option that matches how you want the range displayed, and select OK. The exact labels depend on the content and Office build. A linked result refers to the original workbook, so save both files and avoid renaming or moving the Excel file without updating the link. When the workbook changes, the Word copy may prompt for an update or require you to update the link. If Paste Special does not offer a suitable linked option, use an embedded or ordinary paste instead.
  7. Embed an Excel object when readers need spreadsheet content inside the document. For a copied range, use Home > Paste > Paste Special, select Paste, choose Microsoft Excel Worksheet Object if it appears, and select OK. This stores an Excel object in the Word document rather than linking it to the source file. You can also insert a workbook file using Insert > Object > Object > Create from File, browse to the workbook, and select OK. In the file-insertion dialog, leave Link to file unchecked to embed it. Double-click an embedded object to open its spreadsheet content for editing. The object may take more space than a normal table, and its display in Word may show only part of the worksheet.
  8. Check the layout and save. Click the pasted content and make sure every intended row and column is present. For a wide table, select the page or section containing it and use Layout > Orientation > Landscape, or reduce the table’s width using Word’s table sizing controls. Check that the table does not run beyond the page margins and that headings remain readable. Save the Word file, then reopen it if the document will be shared, to confirm the pasted content and any links are still available.

Mac note: Copy and ordinary paste use Command+C and Command+V. Paste Special may be available through Word’s Edit > Paste Special menu or the Home tab’s Paste menu, depending on the Office version. The available formats and object options can differ from Windows. If a particular Paste Special choice is missing, use ordinary paste or check the desktop app’s available paste options. Word for the web may not expose all object and linking features; use the desktop apps for those methods.

Common Mistakes

  • Expecting an ordinary paste to update automatically. A regular paste is generally a separate copy. Changes in Excel do not automatically appear in it. Use Paste Special with a link if updates are essential, and retain access to the source file.
  • Moving or renaming a linked workbook. A link depends on the location and name of the source. If Word cannot find the workbook, the linked content may stop refreshing. Keep the workbook in a stable shared folder, or repair the link if its location changes.
  • Assuming Excel features transfer intact. A Word table is not a working Excel table. Sorting, formulas, filters, validation lists, and other spreadsheet behavior may not be retained when cells are pasted as a Word table. Keep the original workbook for calculations and interactive use.
  • Copying more cells than intended. Blank rows or columns can create a large, mostly empty Word table. Select the exact range in Excel and check the copied outline before pasting.
  • Using an object when a simple table would do. An embedded worksheet can be harder to resize, read, or edit as part of the document’s text. Choose it when spreadsheet-like editing is important; otherwise, a Word table or formatted paste is often easier to work with.
  • Ignoring page width and readability. A table that fits in Excel may not fit on a portrait Word page. Do not solve the problem by shrinking text until it is difficult to read; consider landscape orientation, narrower columns, or splitting the table.

Tips

  • Match the method to the reader’s task. Use a Word table for a document readers will edit, a linked paste when the displayed figures need refreshing, and an embedded object when recipients need a self-contained spreadsheet copy. A picture is suitable only when appearance matters more than editing or accessible cell text.
  • Keep source formatting in check. Excel fonts and colors may clash with the Word document’s styles. After pasting, apply consistent Word fonts and table styles rather than spending time reproducing every spreadsheet detail.
  • Use a short test before transferring a large range. Paste a small sample first if the workbook uses unusual borders, merged cells, or number formats. This lets you compare the available paste results before committing to a large table.
  • Make linked documents easier to maintain. Store the Word file and workbook in a shared, stable location, and tell collaborators which workbook supplies the data. Before distributing the document, check whether recipients can access that location and whether the content should be refreshed.
  • Consider accessibility. For a table readers need to navigate, use a real Word table, keep a clear header row, and avoid relying on color alone to communicate meaning. An inserted picture of the spreadsheet may not be readable by assistive technology.

Troubleshooting

The table pastes as a picture or an object instead of editable cells: Use the paste options beside the content or undo the paste, then try ordinary paste with Ctrl+V. If Word shows a Paste Special dialog, choose a table or formatted-text option rather than a picture or Excel object. The exact options depend on the copied content and app version.

The table is too wide or splits awkwardly across pages: Select the table and use Word’s table layout controls to adjust column widths or fit the table to the page. You can also switch the relevant page or section to landscape through Layout > Orientation > Landscape. For a long table, check whether repeating the header row would help readers; select the header row and use the table layout option to repeat it where available.

Formatting changes after pasting: Undo and try Keep Source Formatting from Word’s Paste menu. If the appearance still differs, check for Excel features that Word cannot reproduce as table formatting, such as conditional formatting or data bars. For an exact visual snapshot, paste as a picture if that option is available, understanding that its text will not be editable as cells.

A linked range does not refresh: Open the source workbook and confirm it is saved, then check that the path has not changed. In Word, respond to any update-links prompt, or use the link-management controls available in your version of Word to update or repair the source. If the link cannot be recovered, paste the range again from the workbook or replace it with an ordinary copy. Be cautious about enabling updates from files you do not trust.

The Paste Special option you need is missing: Confirm that you copied cells in the desktop Excel app and that the clipboard still contains them; copy the range again and reopen Paste Special. Some formats are available only for certain content or desktop versions. If the option remains unavailable, choose ordinary paste for an editable table or use Insert > Object to embed a workbook file.

Frequently Asked Questions

Can I import an Excel table into Word and keep it editable?
Yes. Copy the cells in Excel and paste them into Word with the regular paste command. Word will generally create a Word table whose text and cells you can edit, but it will not retain all Excel functions.

Will a table pasted from Excel update when the workbook changes?
Not if you use a regular paste; that creates a snapshot. To keep the Word content connected, use Home > Paste > Paste Special and select a linked option. The source workbook must remain available at its linked location.

What is the difference between linking and embedding?
A linked range points to a separate workbook and can reflect its updates, but it depends on that workbook remaining accessible. An embedded object stores a copy inside the Word document, making the document more self-contained but not automatically synced with the original.

Can I paste only selected cells from Excel?
Yes. Select the specific cells or range in Excel before copying. Check the moving outline to make sure it covers exactly the content you want, then paste into Word.

Why does my Excel table look different in Word?
Word and Excel handle layout and formatting differently, and some spreadsheet features do not transfer to a Word table. Try Keep Source Formatting, adjust the table in Word, or use a picture for an appearance-only copy.

Can I do this in Word for the web?
You can usually copy and paste cells as basic content, but browser-based Word may not offer the full set of Paste Special, linking, or embedded-object controls. For those options, use the desktop versions of Word and Excel.

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.