How to Import an Excel Spreadsheet Into a Word Document

How-to basics · Updated November 20, 2026

To bring an Excel spreadsheet into Word, either copy a cell range in Excel and paste it into Word, or use Word’s Insert > Object > Object > Create from File command to embed or link an entire workbook. Copy and paste is usually best for a table that should appear in the document; embedding or linking is better when readers need access to the workbook itself. Before you start, decide whether the Word content should update when the Excel file changes.

What You’ll Need

  • A spreadsheet saved in Excel format, such as .xlsx, if you plan to embed or link the workbook. For a copied table, the workbook just needs to be open in Excel.
  • Microsoft Word and Excel for Microsoft 365 on Windows for the full set of options below. The desktop Word app is needed for inserting an OLE object; Word for the web has fewer options.
  • A saved location for the source workbook if you intend to create a link. Keep the workbook in that location so Word can find it later.
  • A little page space for the table. Wide or long ranges may need a landscape page, smaller text, or multiple pages to remain legible.

Step-by-Step

  1. Choose how the spreadsheet should behave. For a neat table in the body of a report, copy and paste a selected range. For a workbook that readers can open and edit from Word, embed it. For a document that should reflect later changes to a separate workbook, link it. A link depends on access to the source file and its location; an embedded workbook is stored inside the Word document and can make that document larger.
  2. Prepare the range in Excel. Open the workbook, check that the worksheet contains only the rows and columns you want to bring over, and make sure the relevant formulas show the intended results. Select the cells, including any header row. Press Ctrl+C on Windows. On Mac, use Command+C. If the range is large, copy a smaller, purposeful section rather than an entire worksheet; Word is designed for document layout, not browsing a huge data grid.
  3. Paste the range as a table in Word. Click where the table should begin in the Word document and press Ctrl+V on Windows or Command+V on Mac. Word normally inserts the cells as a formatted table. Click the Paste Options button that appears beside the pasted content, if available, to choose a formatting option. Keep Source Formatting retains much of Excel’s appearance; Use Destination Styles adapts it to the Word document’s styles. Names can differ slightly by app version or paste context.
  4. Choose whether the pasted range should update. A normal paste makes a separate copy: later edits in Excel do not automatically change the Word table. To create a linked range in Word for Windows, copy the Excel cells, then in Word choose Home > Paste > Paste Special. Select Paste link, choose Microsoft Excel Worksheet Object in the list, and select OK. Depending on the Office build and copied content, the available format choices can differ. The linked content can update from the source workbook, but the link may stop working if the workbook is moved, renamed, or unavailable.
  5. Embed an entire workbook when readers need the file. In Word for Windows, select Insert > Object > Object, then open the Create from File tab. Select Browse, choose the saved Excel workbook, and select Insert. Leave Link to file unchecked to store an embedded copy in the Word document. Select Display as icon if you want a clickable workbook icon instead of a visible preview. Select OK. Double-clicking an embedded object opens it for editing; the exact editing experience depends on the Office apps installed.
  6. Link an entire workbook instead of embedding it. Follow the same Insert > Object > Object > Create from File path, browse to the workbook, and select it. Check Link to file before selecting OK. Word then refers to the source workbook rather than storing an independent copy of its contents. Use Display as icon if you prefer an icon over a preview. Save both files, and avoid changing the workbook’s name or folder after linking unless you are prepared to update the link.
  7. Insert a new, blank Excel worksheet in the document. If you do not need to import existing data, click where it should go in Word and choose Insert > Table > Excel Spreadsheet. Word places an editable worksheet area in the document. Type or paste the data into it, then click outside the worksheet to return to normal Word editing. This creates a new worksheet object; it does not import the contents of an existing workbook.
  8. Check the layout and save. Review the table or object in Print Layout. If the table is too wide, try selecting it and using Table Layout > AutoFit > AutoFit to Window, or change the page to landscape through Layout > Orientation > Landscape. Check that text is readable and no important columns are clipped. Save the Word file, then reopen it to confirm that the content remains in place. If you created a link, make sure the source workbook is also saved.

On Mac, copying and pasting a range uses Command+C and Command+V; the paste choices may appear in a small pop-up or under Edit > Paste Special, depending on the current Word version. Word for Mac’s Insert > Object options and labels can vary by release. If you cannot find a file-link option, use a normal pasted table or open the document in Word for Windows to create the link. Word for the web can handle ordinary pasted tables, but it does not provide all the desktop app’s object-embedding controls.

Common Mistakes

  • Expecting a regular paste to stay synchronized. A pasted table is generally a snapshot, not a live connection. If updates matter, use Paste Special with Paste link or link the workbook through Insert > Object. Verify the result after saving.
  • Moving or renaming a linked workbook. Word may no longer locate the source. Keep linked files together in a stable folder, and consider storing them in a shared location that the document’s readers can access.
  • Embedding when a link was intended, or the reverse. An embedded workbook travels with the Word file but does not automatically reflect changes made to the original Excel file. A linked workbook can reflect source changes, but it depends on the source being available. Confirm which option is selected before you finish.
  • Copying more cells than the document needs. A very wide or lengthy range can shrink to unreadable text, spill beyond page margins, or make Word cumbersome. Select only the useful rows and columns, or split a large table into sections with clear headings.
  • Assuming formulas behave like visible values after every paste method. A pasted table can display calculated results without behaving like a full Excel worksheet. If readers need to inspect or change formulas, embed the workbook or provide it separately rather than relying on a static table.
  • Overlooking confidential or hidden data. An embedded workbook may retain worksheets, formulas, or other workbook content beyond the visible preview. Check the workbook before embedding it, and share only information that belongs in the document.

Tips

  • Use a table for reading and an object for working. A Word table is easier to style, caption, and keep aligned with surrounding text. An embedded workbook is more suitable when someone needs to open spreadsheet content from the document.
  • Make wide data easier to read. Before reducing font size, remove unnecessary columns or shorten headings. You can also set just the relevant section to landscape by inserting section breaks before and after it, then changing that section’s orientation.
  • Keep headings with the data. Include a header row when copying a range. For a table that continues onto another page, select its header row and use Table Layout > Repeat Header Rows so the headings appear on subsequent pages.
  • Use a clear file name and location for linked workbooks. A folder shared with the document’s intended readers is more reliable than a personal Downloads folder. If you send the Word file by email, send the linked workbook too or choose embedding instead.
  • Use an icon for a cleaner page. When embedding or linking an entire workbook, Display as icon avoids placing a cramped worksheet preview in the middle of a report. Add nearby text explaining what the icon opens.
  • Check the finished document on the page. A table can look fine while editing but be cut off in print or PDF. Review margins, page breaks, and readability in Print Layout, and export a test PDF if the document will be distributed that way.

Troubleshooting

The spreadsheet appears as plain text or loses its formatting. Undo the paste, copy the range again, and use the Paste Options button to select a table-friendly choice such as Keep Source Formatting or Use Destination Styles. If you need a precise visual match and do not need editable cells, paste the range as a picture using Paste Special when that option is available. A picture will not update from Excel and its text will not be editable as a table.

The table is cut off or too small. Select the table and try Table Layout > AutoFit > AutoFit to Window. If it still does not fit, reduce the number of columns, use landscape orientation, or split the data across pages. Avoid shrinking the text until it is difficult to read. For a very wide sheet, an icon-linked or embedded workbook may work better than displaying every column in Word.

The linked content does not update. Open and save the source workbook first. In Word, right-click the linked object or table and look for an update or link-management command; the wording can vary by object type and Office version. Check that the source file still exists at the same path and that you have permission to access it. If the file was moved, relink it through the object’s link settings or insert a new link.

The workbook opens as an icon, or double-clicking does nothing. An icon is expected if Display as icon was selected. Double-click it to open the embedded or linked workbook. If it does not open, confirm that Excel is installed and that the object is not blocked by a security setting. You can also right-click the object and check for an Open or Worksheet Object command.

You cannot find Insert > Object. Confirm you are using the Word desktop application rather than Word for the web, and check the Insert tab’s available commands. On Mac, the location or availability can differ by version. As a practical fallback, copy the range from Excel and paste it into Word as a table, or insert a picture if preserving the exact appearance matters more than editing.

Frequently Asked Questions

Can I import an Excel spreadsheet into Word without Excel installed?
A normal table copied from an Excel file can be viewed and edited in Word, but creating or editing a fully functional embedded workbook usually relies on Excel or compatible Office components. If you only need to show the data, paste it as a Word table or picture.

Will a Word table update when I change the Excel file?
Not if you used an ordinary paste. That creates a separate copy. Use Paste Special > Paste link for a selected range, or link the workbook through Insert > Object, if you want Word to refer to the source file.

What is the difference between linking and embedding?
Embedding stores a copy of the workbook inside the Word document, making the document more self-contained but potentially larger. Linking keeps the workbook separate and can reflect source changes, but Word needs access to the file at its saved location.

Can I import only one sheet from a workbook?
Yes. To display its data, select and copy the cells you need from that worksheet and paste them into Word. To embed a workbook, Word generally inserts the file as an object; if you need to share just one sheet, save a separate copy containing only that sheet before embedding.

Can I edit an Excel spreadsheet after inserting it into Word?
A pasted Word table can be edited as a table, but it is not a complete Excel workbook. Double-click an embedded workbook object to edit its spreadsheet content. A linked object opens or refers to the separate source file, so changes affect that file rather than creating an independent embedded copy.

Which method should I use for a report that will be shared as a PDF?
Use a Word table for information readers need to see in the report, and check its page layout before exporting. Embedded workbook icons and links may not be useful in a PDF, especially if readers cannot access the linked file, so include the key data in the document itself.

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.