Export Excel to Word: Copy Tables Without Losing Format

How-to basics · Updated November 20, 2026

To export Excel data to Word, select the cells in Excel, copy them, and paste them into your Word document. Choose a paste option such as Keep Source Formatting for a familiar table, or Paste as Picture for a fixed layout. Excel does not have a direct Save As command that turns a workbook into an editable Word document, so the best method depends on whether you need an editable table, a live link, or a snapshot.

What You’ll Need

  • Microsoft Excel and Word for Microsoft 365 on Windows, or access to Excel and Word for Mac if you are using a Mac.
  • The workbook containing the data, and a Word document where you want the content to appear. Save both files before you begin.
  • A decision about how the content should behave: an editable Word table, a linked Excel range that can update, an embedded workbook object, or a picture.

Step-by-Step

  1. Prepare the worksheet range. Open the workbook in Excel and go to the worksheet with the content. Select only the cells you want in Word, including headers if they should appear in the document. Avoid copying entire rows or columns unless you really need them; large selections can create unwieldy Word tables. Check that dates, number formats, column headings, and formulas display as intended. Word generally receives the displayed cell values and formatting, not a fully functioning copy of your worksheet.
  2. Make the range easy to read. Adjust column widths and row heights in Excel before copying. Remove unnecessary blank rows and columns inside the range, apply clear heading formatting, and set number formats such as currency or percentages. If you want only the visible results and not formulas, check the displayed results in Excel. Copying a cell range usually brings values and formatting, but calculations will not behave like a complete Excel model once pasted as a Word table.
  3. Copy the selection. With the range selected, press Ctrl+C on Windows. On Mac, press Command+C. You can also use Home > Copy in Excel. A moving border around the selection indicates that it is ready to paste. If the selection is not right, click another cell or press Esc, select the intended range again, and copy it once more.
  4. Choose where it belongs in Word. Open the document and click where the table or other content should start. If the Word file is new, position the insertion point in the document body. If it is an existing document, consider adding a paragraph before and after the pasted content so the table does not run into nearby text. Save the Word document before making larger layout changes.
  5. Paste an editable table. In Word for Windows, use Home > Paste and choose Keep Source Formatting to retain much of Excel’s appearance, or Use Destination Styles to make the table match the Word document’s style. You can also right-click at the insertion point and choose a paste option. The pasted cells become a Word table that you can edit in Word, although Excel-only features and formulas do not transfer as working spreadsheet features. If the paste options are hidden, use the Paste dropdown on the Home tab.
  6. Fit the table to the page. Click in the pasted table and check whether every column is visible. If it is too wide, select the table and use Table Layout > AutoFit > AutoFit to Window in Word for Windows. You can also select the table and use Layout > Orientation > Landscape for the page containing it; in a document with multiple sections, insert section breaks around that page if only that page should be landscape. Reduce excess font size or adjust cell margins only after checking that the text remains comfortable to read.
  7. Paste a fixed snapshot instead. If the exact appearance matters more than editing individual cells, return to Excel, copy the range, and use Word’s Home > Paste dropdown to choose a picture option, if shown. In Word for Windows, Paste Special also provides picture formats in many Microsoft 365 installations. A picture preserves the look of the selected range but its cell text is not edited like a Word table; you may be able to resize or crop the image. Choose a picture for a compact report, not when readers need to change data.
  8. Link the range if it should update. On Windows, copy the Excel range, then in Word choose Home > Paste dropdown > Paste Special. Select Paste link, choose Microsoft Excel Worksheet Object if it is available, and confirm with OK. The document now refers to the source workbook, so changes can be reflected when the link updates. Keep the workbook in a stable location and do not rename or move it casually. A linked object may appear as a spreadsheet object rather than a standard Word table, and recipients need access to the source file for reliable updates.
  9. Save and check the result. Save the Word file as a .docx using File > Save As, then reopen it or use Print Preview to check page breaks, clipping, and readability. If you pasted a linked object, test that it opens or updates while the source workbook is available. For a document you will share, consider whether the linked file path will work for recipients; if not, replace the link with a normal table or picture before sending.

Alternative: insert the workbook as an object. If you need readers to open an Excel sheet from Word rather than see a copied table, Word for Windows offers Insert > Object > Object > Create from File. Browse to the workbook and insert it. Selecting Link to file creates a link; leaving that option clear embeds a copy of the workbook in the document. An embedded workbook can increase the Word file size, and an icon-style object may not show the data on the page. This is different from pasting a range as a table.

Common Mistakes

  • Expecting a one-click conversion. A workbook and a Word document are different file types. Saving an .xlsx file as .docx is not a supported way to preserve a workbook as an editable Word table. Copy and paste the relevant range, or insert an object if the workbook itself needs to be accessible.
  • Copying more cells than necessary. Including whole columns, rows, or large blank areas can produce pages of empty table cells or make the Word file difficult to navigate. Select the precise used range and check its boundaries before copying.
  • Assuming formulas will keep calculating. A Word table is not an Excel worksheet. A pasted value may show the result of a formula, but it will not automatically recalculate when other table cells change. Keep calculations in Excel or use a linked or embedded workbook when spreadsheet behavior is required.
  • Choosing a link without planning for the source file. A linked range can stop updating if the workbook is moved, renamed, deleted, or unavailable to the person opening Word. Use a normal paste if the document must stand alone.
  • Ignoring page width and print layout. A table that looks acceptable on screen can be cut off in a printed page or PDF. Check the Word page orientation, margins, and print preview before sharing.

Tips

  • For a report people will edit, paste as a Word table and use Word’s table styles to make it consistent with the rest of the document.
  • For a report that must look exactly like the worksheet, use a picture, then check that it is large enough to read at normal page size. Very large ranges may be clearer across several pages than as one tiny image.
  • For data that changes often, keep the authoritative figures in Excel and use a link only when the Word file and workbook will remain available together. Otherwise, paste a dated snapshot and note when the figures were current.
  • To show a chart, select the chart in Excel and copy it separately. Paste it into Word as a picture for a stable visual, or use a linked paste option when you need chart updates and can maintain the source workbook link.
  • When the table is too wide, consider splitting it into two smaller tables or removing columns that are not needed in the document. Shrinking all text excessively can make the result hard to read.
  • Word for Mac has similar copy-and-paste choices, but the labels and availability of Paste Special and linked paste options can differ by version. Use the Paste options shown after pasting or the Edit menu’s paste commands. If you cannot create a reliable link on your Mac, paste a table or picture instead.

Troubleshooting

The table is wider than the page: In Word for Windows, click in the table and choose Table Layout > AutoFit > AutoFit to Window. If the type becomes too small, switch the relevant page to landscape, reduce the number of columns, or split the content. Check the page in Print Preview because screen view alone may not reveal a clipped edge.

The pasted content loses its colors or fonts: Undo the paste, copy the range again, and select Keep Source Formatting from the Paste dropdown. If that option is missing or the result still changes, paste as a picture to preserve the visual layout, or use Word table styles and apply the formatting there. Office versions and document settings can affect which paste choices appear.

The link does not update: First make sure the source workbook still exists at the same location and that you can open it. In Word for Windows, right-click the linked object and look for an update or link-related command. If the workbook has moved, recreate the link from the new location. For a document that must work on other computers, replace the link with an unlinked copy or image.

Only part of the range appears: Return to Excel and verify the selected cells before copying. Look for hidden rows or columns, merged cells, and blank areas that might affect what you selected. Copy a smaller test range into Word; if that works, paste the full range in sections.

The picture looks blurry: Copying a very large range into a small space can make its text difficult to read, and resizing can reduce clarity. Use an editable table for text-heavy content, increase the picture’s display size, or export a chart or report view at a more suitable scale. Do not enlarge a low-resolution image and expect its detail to improve.

Word freezes or the file becomes very large: A huge range or embedded workbook can add substantial content. Undo the insertion if Word is responsive, then copy only the necessary cells or use a smaller picture. If you chose to embed a workbook, remember that Word stores a copy of it inside the document.

Frequently Asked Questions

Can I export an entire Excel workbook directly to Word?
Not as a standard editable Word document with a single Save As command. Copy selected worksheet ranges into Word, or insert the workbook as an object if readers need to open the spreadsheet from the document.

Will the Word table update when I change Excel?
A regular pasted table will not update from the workbook. Use Paste Special with Paste link on Windows if you need a linked range, and keep the source workbook available. A picture is also a static snapshot.

Can I convert Excel formulas into working Word formulas?
Not by ordinary copy and paste. Word tables can perform some simple calculations, but they are not substitutes for Excel formulas or a full workbook. Keep calculation-heavy data in Excel and paste the results or link the range.

Can I do this in Excel and Word for Mac?
Yes. Select and copy the cells in Excel, then paste them into Word using the available paste options. Menus and linked Paste Special choices vary by Mac version, so if a link option is unavailable, use a regular table or picture.

How do I put an Excel chart in Word?
Select the chart in Excel and copy it, then paste it at the desired location in Word. Use a picture for a fixed chart, or a linked paste option when updates matter and the source workbook will remain accessible.

What is the best format for sending the result?
Use a normal Word table when recipients need to edit the cells, a picture when appearance is the priority, and a linked or embedded workbook when spreadsheet features matter. If recipients only need to read a final report, save or share the finished Word document as a PDF after checking its layout.

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.