How to Import an Excel Sheet Into Word: 3 Simple Methods

How-to basics · Updated November 20, 2026

To import Excel content into Word, select and copy the cells in Excel, then paste them into your Word document. For a table that updates when the workbook changes, use Paste Special and choose a linked Excel object; to include a whole workbook, insert it as an object. Before you start, decide whether readers should be able to edit the content in Word, update it from Excel, or open the original workbook separately.

The steps below are for Microsoft 365 on Windows. Word and Excel for Mac offer similar copy-and-paste options, though some Paste Special and object choices may appear in different menus or vary by version. Keep the source workbook saved and accessible if you plan to link to it.

What You’ll Need

  • Microsoft Excel and Word, with the workbook you want to use.
  • A saved copy of the workbook. This is essential for a reliable link and helpful if you need to redo the import.
  • Access to the folder where the workbook is saved, especially if you will insert or link the file as an object.

Step-by-Step

  1. Choose what you want to bring into Word. Open the workbook in Excel and identify whether you need a few cells, a formatted report table, a chart, or the whole workbook. For a table, select just the relevant cell range rather than the entire worksheet. Copying a full sheet can include blank rows and columns, making the result unwieldy. If you need the full used area, click the worksheet’s Select All button—the triangle at the top-left corner between the row numbers and column letters—then check that you are not including unnecessary content. Save the workbook before continuing.
  2. Copy the selected Excel cells. With the range selected, choose Home > Copy, or press Ctrl+C on Windows. On a Mac, press Command+C. A moving dashed border usually appears around the copied cells. If you are copying a chart, click its outer edge first so the chart itself is selected, then copy it; selecting cells underneath the chart may copy the data instead.
  3. Paste a normal, editable Word table. Click in Word where the table should begin. Use Home > Paste, or press Ctrl+V on Windows (Command+V on Mac). Word generally pastes a cell range as a Word table. The table’s contents can then be edited in Word, but edits to it do not change the Excel workbook. After pasting, use the small Paste Options button near the table, if it appears, to choose an option such as Keep Source Formatting or Use Destination Styles. The first tends to preserve Excel’s colors, borders, and fonts; the second adapts the table to the Word document’s styles. The exact options depend on the selected content and Word version.
  4. Adjust the table to fit the page. Click inside the pasted table. If it is too wide, select it and use Table Layout > AutoFit > AutoFit Window. You can also drag column borders, reduce font size, switch the page to landscape with Layout > Orientation > Landscape, or use Layout > Margins to choose narrower margins. Check the printed or PDF page layout as well as the on-screen view; a table that looks acceptable at high zoom may still wrap badly on a page.
  5. Paste an Excel range as an embedded object or a live link. Return to Excel and copy the desired cells again. In Word, click the destination, then choose Home > Paste arrow > Paste Special. In the dialog, choose Microsoft Excel Worksheet Object. Select Paste to embed a separate copy, or select Paste link to connect the Word content to the source workbook, then choose OK. The linked option is useful when the Excel range changes regularly; the embedded option keeps a copy in the Word file but does not track later workbook edits. In some Word builds, the Paste Special command is also available from the Edit menu. On a Mac, check Edit > Paste Special; the available object and link choices depend on the Office version.
  6. Verify how an embedded or linked range behaves. An Excel object may appear as a compact worksheet-like area rather than a standard Word table. Double-clicking an embedded object normally opens its Excel editing surface inside Word; a linked object refers to the source file. Make a small, harmless change to the source workbook, save it, and check whether the linked range updates. If the range does not update automatically, right-click it in Word and look for Update Link. Do not assume a pasted object is linked just because it looks like Excel—confirm the Paste Special choice you made.
  7. Insert a workbook as an object when readers need the file. In Word for Windows, choose Insert > Object > Object, open the Create from File tab, and select Browse to locate the workbook. Choose Insert. Leave Link to file unchecked to store an embedded copy in the Word document, or check it to link to the workbook on your computer or network. Select Display as icon if you want a clickable file icon instead of a visible worksheet preview, then choose OK. Double-clicking an embedded icon opens the stored workbook copy; double-clicking a linked icon opens the linked file. The Create from File option inserts the workbook as a file object; it is not the best way to display a large sheet as a readable Word table.
  8. Save and test the document. Save the Word file, then close and reopen it if the document will be shared. Confirm that tables remain readable, links still point to the intended workbook, and embedded objects open as expected. A link may work on your computer but fail for another person if the source file is stored in a local folder they cannot access. If recipients need the data without a separate workbook, use an ordinary pasted table or embed a copy rather than relying on a private file path.

Common Mistakes

Copying the whole worksheet by accident: A sheet has far more rows and columns than most reports need. Selecting all can make Word create a huge object or table with extensive blank space. Select the actual data range, including only the headings and totals you want to show.

Expecting a regular paste to stay connected to Excel: A normal Ctrl+V paste usually creates a Word table or a static copy. It does not automatically reflect later edits in the workbook. Use Paste Special and explicitly select Paste link when ongoing updates matter.

Moving or renaming the linked workbook: A link depends on Word finding the source file. Moving it, changing its name, or sending the Word document alone can break the connection. Keep linked files in a shared location that recipients can access, or embed a copy when portability matters more than live updates.

Importing more formatting than the document can handle: Excel may have custom widths, colors, merged cells, or number formats that look crowded in Word. Choose destination styles or simplify the range in Excel before copying. Inspect page breaks and print layout rather than assuming the screen view is enough.

Using a workbook object when a readable table is needed: An icon or embedded workbook is useful for providing a file to open, but it may not show the data clearly on the page. Paste the required cells as a Word table when the information needs to be read directly in the document.

Tips

Make a clean copy of the range in Excel before importing it. Remove blank rows and columns, make headings clear, set sensible number formats, and use consistent fonts. This reduces reformatting in Word and helps prevent long labels from forcing columns too wide. If the spreadsheet includes formulas, decide whether the Word reader needs the calculated values or the ability to inspect the underlying workbook; a normal table shows the displayed results, while an object can retain spreadsheet functionality.

For reports that need occasional updates, a linked range can save time, but refresh it before distributing the document and keep the source file in a stable shared folder. For a document that must remain self-contained, paste a static table or embed the workbook. An embedded copy increases the Word file size, so avoid embedding a large workbook when a small table or shared link will do.

To preserve a chart, copy the chart object in Excel and paste it into Word. If you need the chart to update with the workbook, use Paste Special and check whether a link option is available for that chart in your version. If the chart must match the Word document’s appearance exactly and does not need editing, a picture can be more predictable, but it will not behave like a spreadsheet.

Troubleshooting

The table is cut off at the right margin: Click in the table and try Table Layout > AutoFit > AutoFit Window. If it remains too wide, remove unnecessary columns, use landscape orientation, or reduce cell margins and font size. Avoid shrinking text until it is difficult to read.

The pasted content looks different from Excel: Use the Paste Options button to try Keep Source Formatting or Use Destination Styles. For fine control, return to Excel and simplify cell fills, borders, and merged cells before copying. Word’s page width and available fonts can affect the result even when source formatting is retained.

The link does not update: First save changes in Excel. In Word, right-click the linked range or object and choose Update Link if that command is available. Check that the workbook has not been moved or renamed and that Word is allowed to access its location. When sending the document, provide access to the linked workbook or replace the link with a static copy.

The recipient sees an error or cannot open the object: A link to a local drive or private network folder may not be available to them. Share the workbook in a location both people can access and check the file permissions, or embed the workbook instead. If the object is essential, send a test copy to another device or account before relying on it.

Paste Special does not show an Excel option: Copy a cell range again in Excel, not a screenshot or text from another program, and reopen Paste Special in Word. If the option is still missing, use a regular paste as a Word table or use Insert > Object > Object to add the workbook file. Office options differ by platform and version, so the simpler table paste is the most dependable fallback.

Frequently Asked Questions

Can I import an entire Excel worksheet into Word?
Yes. You can select the used cells and paste them as a Word table, or insert the workbook as an object. A full worksheet can be too large for a page, so a selected range or an icon-linked workbook is often more practical.

Will a Word table update when I change the Excel file?
Not if you use an ordinary paste. To connect a copied range to Excel, use Home > Paste arrow > Paste Special and choose Paste link with Microsoft Excel Worksheet Object. Keep the source file available so Word can refresh the link.

What is the difference between embedding and linking?
An embedded object stores a copy inside the Word document and remains available if the original file is moved, but edits do not automatically follow the original. A linked object refers to the source workbook and can reflect updates, but it can break if the file is moved or inaccessible.

Can I edit the imported Excel data in Word?
A range pasted as a Word table can be edited as a table, but those edits do not change Excel. To work with spreadsheet cells, double-click an embedded Excel object. A linked object may also open the source data, depending on the object and your Office version.

Can I do this in Word for Mac?
Yes. Copy cells in Excel with Command+C and paste in Word with Command+V to create a table or static copy. For a link or embedded object, check Edit > Paste Special and the Insert menu; options vary by Mac version. If you cannot find the needed object option, use a normal pasted table or share the workbook separately.

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.