How to Copy an Excel File to Word

To copy Excel content into Word, select the cells in Excel, press Ctrl+C, switch to Word, and press Ctrl+V. That creates a Word table in most cases. To keep the content editable in Excel, use Paste Special to embed or link an Excel worksheet object instead. Choose the method based on whether you need a clean document, a picture, or a connection to the original workbook.

Word does not turn an entire Excel workbook into a fully functional Word document. You can copy a range, place a worksheet object in the document, or insert the workbook as an attached object. A table is usually easiest to read and print; an object is better when readers may need to open or edit spreadsheet content.

What You’ll Need

A Windows computer with Excel and Word for Microsoft 365 installed for the full set of options below. Basic copying and pasting also works in the web apps, but embedding and linking objects require the desktop apps.
The Excel workbook you want to copy, saved if you plan to link it to Word. Keep the workbook in a location that will remain accessible, such as a shared folder your document recipients can reach.
A Word document with enough page space for the selected range. If the range is wide, consider setting the relevant Word page to landscape or reducing the number of columns.

Step-by-Step

Choose what you want to transfer. Open the workbook in Excel and decide whether you need a small range, a whole visible worksheet area, or an Excel workbook object. For a report or letter, a selected range is usually best. For a large sheet that readers must inspect or edit in Excel, an object may be more suitable. Copying the used cells does not automatically copy every sheet as separate Word pages.
Select the cells in Excel. Drag across the range you need, including the headings. To select a contiguous block, click its first cell, hold Shift, and click the last cell. You can also click the Name Box to the left of the formula bar, type a range such as A1:F18, and press Enter. Then press Ctrl+C on Windows. On a Mac, use Command+C. A moving dashed outline around the selection indicates that it is on the clipboard.
Paste the selection as a Word table. Click where the table should start in Word and press Ctrl+V on Windows or Command+V on Mac. The usual result is an editable Word table containing the copied values and much of the source formatting. If Word displays paste choices, choose Keep Source Formatting to retain Excel’s appearance, or Use Destination Styles to make the table match the Word document. The exact labels and available choices can vary by app version.
Adjust the table for the page. Click inside the pasted table and check whether all columns fit. Use Word’s table layout controls to adjust column widths, or select the page orientation from Layout > Orientation if a wide table needs more room. If the table runs across pages, make sure the heading row is repeated where useful: select the row, then use Table Layout > Repeat Header Rows when that command is available. Review the print layout, not just the editing view, before sharing.
Paste a picture when appearance matters more than editing. Copy the range in Excel, click the destination in Word, and use Home > Paste ▼ > Picture if that option appears. A picture preserves the visible layout as a single graphic, but its cell contents cannot be edited as a Word table. You can resize it in Word; enlarging it too much may make text blurry. This is a practical choice for a compact chart or a carefully formatted summary that should not change.
Embed an editable Excel object from copied cells. Copy the cells in Excel. In Word, choose Home > Paste ▼ > Paste Special. In the dialog, select Microsoft Excel Worksheet Object and choose Paste, then select OK. The copied range appears as an Excel object rather than an ordinary Word table. Double-click it in Word to edit it with Excel tools. This embeds a copy of the selected content; later changes to the original workbook will not automatically update the embedded copy.
Link copied cells to the source workbook if updates matter. Repeat the copy and Paste Special steps, but choose Paste link rather than Paste. Select Microsoft Excel Worksheet Object if you want the linked range to behave like an Excel object, then confirm. Word refers to the source workbook, so changes can be reflected when the link updates. Save both files and avoid moving or renaming the workbook after linking. If Word asks whether to update links when opening the document, confirm only when you trust the source file and want its current data.
Insert the workbook as an object when you need to attach the file. In Word, select Insert > Object > Object, open the Create from File tab, and choose Browse to locate the workbook. Select Link to file if Word should refer to the original file; leave it unchecked to embed a copy in the document. Select Display as icon if you want a clickable workbook icon rather than a visible preview, then choose OK. An embedded workbook can make the Word file much larger. This method attaches an Excel file object; it does not lay every worksheet out as readable Word pages.
Save and verify the result. Save the Word document, then close and reopen it if you used an embedded or linked object. Check that the table, picture, or object is present and that it displays as intended. For a linked object, check that the source workbook is still available at its saved location. If someone else will receive the document, test it from the location and account they are likely to use, especially when a link depends on a local or restricted network path.

Common Mistakes

Copying more cells than intended: A full-column or full-sheet selection can create a huge table or object. Select only the range needed, and check the row and column boundaries before copying.

Expecting a Word table to keep Excel formulas: A normal paste is meant to transfer the displayed spreadsheet content and formatting, not create a live Excel calculation inside Word. If readers need to change values and recalculate, use an embedded Excel object or include the workbook separately.

Confusing an embedded object with a linked one: An embedded copy travels inside the Word document but does not stay synchronized with the workbook. A link can reflect source changes, but it depends on the source file remaining reachable. Pick deliberately in Paste Special or the Create from File tab.

Assuming every worksheet will be visible: Inserting a workbook object does not convert all workbook tabs into a sequence of Word tables. Readers may need to double-click the object and use Excel to see other sheets. If each sheet must be readable in the document, copy its relevant range separately.

Ignoring page width and print layout: A pasted table may extend beyond the page or split awkwardly. Check the complete table in Word’s print layout and adjust its widths, page orientation, or margins before distributing the file.

Moving a linked workbook after creating the link: Word may not find the source file if its name or location changes. Store linked files together in a stable shared location, and check links again after moving a folder or sending the document.

Tips

For a polished report, copy only the useful rows and columns, include a clear heading row, and remove blank rows from the selection. Shorter tables are easier to fit on a page and easier to read on screen.

Choose the paste format before you begin. Use a Word table when colleagues need to edit text in Word, a picture when an exact static appearance is the priority, an embedded object when readers need spreadsheet editing without a live connection, and a linked object when the Word document should reflect a source workbook that remains available.

When pasting as a table, compare Keep Source Formatting with Use Destination Styles. The first is more likely to retain fills, borders, and number display; the second can make the table feel consistent with the document. Neither choice guarantees that a wide Excel layout will fit a portrait page, so inspect the result.

For charts, select the chart itself in Excel before copying rather than selecting the cells behind it. In Word, a pasted chart can often be resized as a graphic; if you need to change the underlying data, use an Excel chart object or retain the source workbook.

If you use a link, save the workbook before creating or updating the link. Keep a backup copy, especially before changing file locations or sharing a document externally. A recipient may not be able to follow a link to a file stored only on your computer.

On a Mac, use Command+C and Command+V for copying and pasting. The desktop versions offer object and Paste Special workflows, though dialog wording and ribbon layout may differ slightly from Windows. Excel for the web and Word for the web are suitable for ordinary range copying, but use the desktop apps for the object options described above.

Troubleshooting

The paste lands as plain text or looks different: Undo with Ctrl+Z on Windows or Command+Z on Mac, copy the range again, and use the paste menu to choose a table-friendly option such as Keep Source Formatting. Check that you copied cells in Excel rather than text from the formula bar. If the table still looks crowded, reduce the selected range or adjust its widths in Word.

The table is cut off at the page edge: Select the page containing the table and try Layout > Orientation > Landscape. You can also make the table narrower by resizing columns, removing unnecessary columns, or using a smaller font for the table. Do not shrink it so far that the text becomes difficult to read.

The Excel object will not open when double-clicked: Confirm that desktop Excel is installed and that the object was inserted as an Excel Worksheet Object rather than pasted as a picture. If the object is linked, confirm that the source workbook has not been moved, renamed, deleted, or blocked by access permissions.

The linked content is out of date: Save the source workbook, then return to Word and use the link update prompt if one appears. You can also right-click the linked object and look for an update or linked-object option; labels vary by version. If the source path is broken, restore the workbook to its original location or create the link again from the correct file.

The document becomes unexpectedly large: An embedded workbook stores a copy of spreadsheet content inside the Word file. If size is a problem, paste a compact range as a Word table or picture, or use a link when recipients can access the workbook. Remember that a link is not a substitute for sharing the source file.

The object appears as an icon instead of spreadsheet content: When inserting through Insert > Object, Display as icon intentionally shows an icon. Reinsert the object without that option if you want a visible preview. If you need a readable table on the page, copy and paste the cell range instead.

Frequently Asked Questions

Can I copy an entire Excel workbook into Word?

You can embed the workbook as an object through Insert > Object > Object > Create from File. This attaches the workbook, but it does not convert all sheets into readable Word pages. Copy each sheet’s relevant range separately if the contents need to appear in the document.

Will changes in Excel update automatically in Word?

Only a linked object can refer back to the source workbook. An embedded copy or ordinary Word table is separate from the original. Linked updates also depend on Word being able to find the source file and on the link being updated.

Can I edit the pasted spreadsheet in Word?

A normal pasted range is a Word table, so you can edit its cells as table content, but it does not work like Excel formulas and worksheets. Double-click an embedded Excel object to edit spreadsheet content with Excel tools.

How do I copy an Excel table without losing its formatting?

Select the range in Excel, copy it, and in Word choose Keep Source Formatting from the paste choices if available. Check the result in print layout because column widths and page size can still change how the table appears.

Can I copy Excel data into Word online?

You can usually copy and paste a cell range between Excel for the web and Word for the web. For Paste Special links, embedded workbook objects, or inserting a workbook from a file, use the desktop versions of Excel and Word.

What is the best format for a table that must not change?

Use a picture for a fixed visual snapshot, especially when matching the visible Excel layout matters most. It is not editable as a table, so keep the workbook separately if readers may need to inspect or revise the data.

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.