Excel Data to Word: Choose the Best Way to Transfer It

To put Excel data in Word, select the cells in Excel, press Ctrl+C, click where the data should go in Word, and press Ctrl+V. This creates a Word table you can edit separately; to keep it connected to Excel, use Paste Special and choose a Paste Link option instead.

Choose how the data should behave

The best method depends on whether you need a simple table, an automatically refreshable copy, a complete Excel object, or a fixed visual. These choices affect what readers can edit and whether changes in the workbook appear in the document. Decide before pasting, especially for a report that will be revised repeatedly.

Paste as a Word table: Best for a compact range that needs Word formatting. The pasted cells are independent of the workbook.
Paste as a link: Best when the Word copy should reflect changes made to the Excel source. The source workbook must remain accessible.
Embed an Excel object: Best when recipients need the spreadsheet inside the Word file and may need to edit it. This can increase the document’s size.
Paste as a picture: Best when appearance matters more than editing or updating the underlying values.

For example, a final report table that will not change is usually easiest to manage as a Word table. A monthly sales summary that changes in Excel may be better linked. A small chart or carefully formatted range that must look identical on every computer may be safer as a picture.

Copy cells into Word as a table

In Excel for Microsoft 365 on Windows, select the cells you need, including headings if they belong in the document, and press Ctrl+C. In Word, click the insertion point, then press Ctrl+V. Excel’s cells normally appear as a table, and you can edit the text and layout using Word’s table tools. This copy does not stay connected to the original worksheet: changing a value in Excel will not change the pasted table.

Word may show a Paste Options button beside the pasted content. Its choices can include keeping the source formatting, matching the destination document’s style, or retaining text only. Select a choice that suits the document rather than assuming the default appearance will be right. If you do not see the button, use Word’s Home > Paste menu; available choices depend on the copied content and Office version.

On a Mac, use Command+C and Command+V instead of Ctrl+C and Ctrl+V. The same general distinction applies: a normal paste is a separate copy, not a live connection. Menu labels and paste choices can differ slightly by platform and Office build, so inspect the result before distributing the document.

For a more controlled paste in Word on Windows, use Home > Paste > Paste Special. The dialog offers formats appropriate to the copied range. Choose a text or formatted-text option for editable document content, or an image option for a visual copy. Choosing a format that keeps Excel as an object is different from creating a regular Word table.

Link a Word table to its Excel source

A linked paste keeps a connection between the Word content and the Excel workbook. In Excel, copy the range. In Word for Windows, click the destination and select Home > Paste > Paste Special. In the dialog, choose Paste link, then select an Excel object or another suitable format from the list and confirm. The available format names can vary with the copied range and Office version. If the dialog does not show a Paste link choice, check that the content was copied from Excel and that you are using the desktop apps.

When the source cells change, the linked content can be updated from the workbook. Word may update links when a document opens, depending on its settings and security prompts; you can also right-click linked content and look for an update command. Keep the workbook at a stable location and do not rename or move it casually. A link can break if Word cannot find the source file, and a recipient who lacks access may see old content or be asked to locate the workbook.

A link is not the same as sharing a live online spreadsheet. It points Word to a file location; it does not guarantee that every recipient can reach that location or see changes immediately. Before sending a linked document, open it on the intended computer or account and confirm that the content displays correctly. For a final, self-contained document, consider converting the linked content to an unlinked copy after the numbers are approved.

Embed a workbook or paste a picture

An embedded Excel object stores spreadsheet content within the Word document rather than relying on a separate source file. To insert a workbook as an object in Word for Windows, use Insert > Object > Object, choose the Create from File tab, browse to the workbook, and leave Link to file unchecked. If you check Link to file, Word creates a linked object instead, so the source file still matters. The command can vary by Office version, and an embedded object may display as an icon if you select that option.

Double-clicking an embedded worksheet in Word can open Excel editing tools for the object. It is useful when a recipient needs more than a static table, but embedding is not a substitute for providing the original workbook when the full workbook’s sheets, formulas, or external connections matter. Also consider document size: embedded content adds data to the Word file.

To preserve a range’s appearance without offering cell-level editing, use Paste Special and choose an image format, or use Excel’s copy-as-picture feature if available in your version. A picture can be resized and positioned like an image, but its values cannot be edited as spreadsheet cells and it will not update when Excel changes. Check that small text remains readable at the size used in the document.

Use Excel data for Word mail merge

If the goal is to create a separate letter, certificate, envelope, or label for each row, copying a table is usually the wrong tool. Word’s mail merge uses an Excel list as a data source and inserts fields, such as a person’s name or address, into a document template. This can create many personalized documents from one spreadsheet.

Prepare the Excel sheet with one clear header row and one record per row. For example, a contact list might have columns named FirstName, LastName, and City. Avoid merged cells in the data area, blank header names, and notes mixed into the list. Save the workbook, then in Word for Windows use Mailings > Start Mail Merge to choose a document type, followed by Mailings > Select Recipients > Use an Existing List to select the workbook. Insert fields through Mailings > Insert Merge Field, preview the results, and use Finish & Merge when they are ready.

Mail merge is different from linking a table: it uses spreadsheet rows to generate personalized output, rather than placing the worksheet range itself in the document. Check the preview for missing or oddly formatted values. Dates, postal codes, and numbers can be affected by how Excel stores or displays data, so confirm the merged output before printing or sending it. Mac versions of Word include mail merge features, but available controls and steps may differ from Windows.

Keep the table readable in the document

Excel worksheets are often wider than a Word page. Before copying, remove columns the reader does not need and check whether the range will fit the page. In Word, select the table and use Table Layout > AutoFit to choose an appropriate fit, if that control is available in your ribbon. You can also change page orientation through Layout > Orientation > Landscape or adjust margins through Layout > Margins.

For a long table, repeat the header row so readers can identify columns on later pages. Select the heading row and use Table Layout > Repeat Header Rows. Page breaks and row splitting can affect the result, so check Print Layout or print preview rather than judging only from the editing view. Avoid shrinking text so far that the table technically fits but becomes difficult to read.

Word and Excel handle formatting differently. Excel number formats may be carried over in some paste choices, but they are not a guarantee that every value will display exactly as expected. Review currency symbols, decimal places, date formats, borders, column widths, and shaded cells after pasting. If the data is still changing, make the final formatting changes after updating the link or pasting the latest version.

Fix common transfer problems

The table is too wide: Remove unnecessary columns, use landscape orientation, or split the information into smaller tables. A picture can be scaled, but scaling a wide image may make its text unreadable.
The formatting looks different: Try a different Paste Options choice, then adjust the table in Word. Excel and Word use different layout rules, so exact visual matching is not guaranteed for an editable table.
The linked values are outdated: Update the link from Word if the command is available, confirm that the source workbook is reachable, and check that the workbook was saved after editing.
The link cannot be found: Restore the workbook to its expected location or relink it if Word offers that option. If recipients do not need an ongoing connection, replace the link with a regular pasted copy.
Values seem missing or changed: Check the copied cell range and inspect formulas, hidden rows, number formats, and blank cells in Excel. Then paste again and compare the result with the source.

When troubleshooting, keep the original workbook unchanged and make a test copy of the Word document. This makes it easier to compare the source and result without accidentally replacing a correct version.

Protect the information you transfer

Copying a range, linking a range, and embedding a workbook can expose different amounts of information. A visible table may include only selected cells, while an embedded workbook may contain additional sheets or data that a recipient can inspect. Before sharing, review the workbook for hidden worksheets, hidden rows or columns, comments, and unrelated material. Do not assume that content outside the visible range has been removed merely because it is not shown in Word.

For sensitive information, share only the data needed for the document and follow your organization’s handling rules. A picture can prevent ordinary cell editing, but it is not a security boundary: people may still read or capture the visible information. Likewise, password protection or access controls should be chosen based on the actual sensitivity and sharing requirements, not simply on the transfer method.

Frequently Asked Questions

How do I convert an Excel table to Word? Select and copy the cells in Excel, then paste them into Word. The result is generally a Word table that you can format and edit independently. Check the pasted range and formatting before using it in a final document.

Will Excel changes update automatically in Word? Not when you use an ordinary paste. Use Paste Special and choose Paste link to create a connection. Updates depend on the source file being available and Word’s link behavior, so verify the document after changes rather than assuming it refreshed.

Can I copy only the displayed Excel data? Select the specific cell range you want before copying. If you need to omit rows or columns, leave them out of the selection or prepare a clean range first. Check the Word result because hidden or filtered data can make selections less obvious.

Can I edit Excel data after putting it in Word? A normal paste can be edited as a Word table, but it is separate from Excel. An embedded Excel object can be edited as spreadsheet content by opening the object. A linked object refers to the source workbook, while a pasted picture is not editable as cells.

Which method is best for sending a report? For a stable report, a Word table is easy to edit in the document; a picture preserves a fixed appearance. Use a link only when recipients can access the source workbook and need updates. If the report contains one personalized page per spreadsheet row, use mail merge instead.

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.