How to Export an Excel Table to Word Without Losing Format

How-to basics · Updated November 20, 2026

To export an Excel table to Word, select the table in Excel, copy it, and paste it where you want it in Word. In Microsoft 365 on Windows, choose Keep Source Formatting if you want to retain the Excel table’s appearance, or use Paste Special if you need a linked or embedded Excel object. Save both files before you start if the table is important.

What You’ll Need

  • A workbook containing the table you want to move, with the headings and data arranged as you want them to appear.
  • Microsoft Excel and Microsoft Word. The steps below use the Microsoft 365 desktop apps on Windows; Mac and web differences are noted where they matter.
  • A Word document with enough room for the table. For a wide or long table, consider whether the page should be landscape before pasting.

Decide whether Word should contain a normal editable table, an object that can be opened in Excel, a linked table that can update from the workbook, or a static picture. A regular paste is usually the simplest choice for a report or handout.

Step-by-Step

  1. Prepare the Excel table. Open the workbook and check that the table includes the correct column headings and only the rows you want to share. Remove temporary filters or clear them if you need every record included; copying a filtered table may copy only the visible cells in some workflows. Check number formats, column widths, and any notes that readers will need. If the workbook has sensitive information, make sure you are not copying extra cells outside the table.
  2. Select the full table. Click a cell inside the Excel table, then choose Table Design > Select > Entire Table on the ribbon. Check that the selection includes the header row and all intended data rows. If the range is not formatted as an Excel table, select the required cells manually by dragging from the first cell to the last. You can also click the first cell, hold Shift, and click the last cell to select the range between them.
  3. Copy the selection. Press Ctrl+C on Windows. The moving dashed border around the selection indicates that Excel copied it. On a Mac, press Command+C. Avoid cutting the cells: copying leaves the original table in the workbook.
  4. Set up the Word page. Switch to Word and open the destination document. Click where the top-left corner of the table should go. If the table is too wide for a portrait page, set the page orientation first with Layout > Orientation > Landscape. You can also adjust margins under Layout > Margins. Setting the page first can prevent the pasted table from becoming cramped.
  5. Paste as an editable Word table. Press Ctrl+V. Word normally pastes a copied cell range as a table that you can edit in Word. To choose how its appearance is handled, use the paste-options button that appears beside the pasted content and select Keep Source Formatting to preserve more of Excel’s fonts, fills, and borders. Choose Use Destination Styles when the table should match the Word document’s style. On a Mac, use Command+V; the available paste choices may appear as a small paste-options control or under Word’s Home > Paste menu.
  6. Check the result in Word. Click inside the pasted table and review the headers, row order, numbers, borders, and alignment. A pasted Word table is editable with Word’s table tools, but its cells are not live Excel formula cells. Excel formulas are not transferred as working formulas in a normal Word table; Word receives the displayed results. If any columns are cut off, select the table and use Table Layout > AutoFit to choose an appropriate fit, or adjust the page orientation, margins, or column widths.
  7. Choose a linked or embedded object if needed. If you want readers to open the range in Excel rather than edit it as an ordinary Word table, copy it in Excel and in Word select Home > Paste > Paste Special. In the dialog, choose an Excel worksheet object if offered, then select Paste to embed a copy in the document. To keep a connection to the workbook, select Paste link instead, then choose a suitable available format. Options vary by Office version and by what is on the clipboard. A linked item depends on the source workbook remaining accessible, so use it only when the document and workbook can be kept together.
  8. Use a picture for a fixed appearance, if appropriate. To prevent the table’s layout from changing, copy the selection and use Home > Paste > Paste Special, then choose a picture format if one is listed. A picture preserves the appearance as a snapshot, but its cell text is not editable as table content and it will not update when the workbook changes. This is useful for a small finished table where appearance matters more than editing or accessibility.
  9. Save and confirm the files. Save the Word document. If you used a linked object, save the Excel workbook in its intended location as well and avoid renaming or moving it without updating the link. Reopen the document, if practical, to confirm that the pasted content remains visible and that a linked range can still find its source.

In Excel for the web, select the range and use the copy and paste commands as usual; the exact paste choices depend on the browser and the clipboard. Some object and Paste Special options available in the desktop apps may not be available in the web apps. On a Mac, the general copy-and-paste process is the same, but use Command shortcuts and expect the available Paste Special formats to differ slightly.

Common Mistakes

  • Copying only the data rows. If the headings are outside the selected range, Word will not include them. Confirm the selection includes the header row before copying.
  • Expecting formulas to keep calculating. A normal pasted Word table contains the displayed cell values, not a working Excel calculation grid. Keep the workbook as the calculation source, or use a linked or embedded object when that behavior is needed.
  • Choosing a link without planning for the source file. A linked range can stop updating if the workbook is moved, renamed, or unavailable to the person opening the document. Store related files in a stable shared location and check the link after moving them.
  • Pasting a very wide table onto a portrait page. This can make columns narrow or push part of the table beyond the page. Change orientation, reduce margins, or simplify the columns before resorting to very small text.
  • Assuming Excel filters or interactive features transfer. A normal Word table does not retain Excel’s filter buttons, formulas, slicers, or workbook behavior. It is a copy of the content and much of its formatting, not a second Excel worksheet.
  • Using a picture when the content needs editing. A screenshot or pasted picture is difficult to edit and may be less accessible. Choose an editable Word table unless a fixed visual snapshot is the actual goal.

Tips

  • Choose the paste option based on the audience. Keep Source Formatting is useful when the Excel colors and emphasis carry meaning. Use Destination Styles when consistency with a formal Word report matters more than matching the workbook.
  • Make a large table easier to read. In Word, select the table and look for Table Layout > Repeat Header Rows so column headings appear on continued pages. This helps readers follow a table that spans multiple pages. Check the print layout because page breaks can affect how a table displays.
  • Keep source values understandable. Apply the desired number formats in Excel before copying. Dates, percentages, and currency are easier to review when their formats are consistent, although Word may adjust some formatting during paste.
  • Use a linked paste only when updates are useful. Linking can help with a report that changes regularly, but it introduces a dependency on the workbook. For a document that will be emailed or archived on its own, an ordinary Word table or a static snapshot is usually more portable.
  • Keep a clean workbook copy. If you need to paste just a portion of a larger table, select the intended range carefully rather than copying the whole worksheet. This also reduces the chance of sharing hidden or unrelated data.
  • Check accessibility and readability. Use clear header labels, sufficient contrast, and a font size that remains readable after fitting the table to the page. Avoid relying on color alone to explain the meaning of a cell.

Troubleshooting

The table pastes as plain text or loses its formatting. Undo the paste with Ctrl+Z on Windows or Command+Z on Mac, copy the range again, and use Word’s paste-options button or Home > Paste to choose a table-friendly option such as Keep Source Formatting. If the table came through as text, select it and check whether Word offers Insert > Table > Convert Text to Table; this works best when the text has clear tab or other consistent separators.

Only part of the table appears. Return to Excel, reselect the range, and verify the selection outline covers the intended headers and rows. If rows are filtered or hidden, decide whether you want only visible records or the full dataset, then adjust the filter and copy again. Also check that the Word page is not clipping the right edge.

The table is too wide, too small, or split awkwardly. Try Layout > Orientation > Landscape and adjust margins. In Word, click in the table and use Table Layout > AutoFit, then inspect each column for unwanted wrapping. For a very large dataset, consider splitting it into smaller purposeful tables rather than shrinking the text until it is hard to read.

A linked table does not update. Check that the workbook still exists at the same location and that Word can access it. Open the workbook, save it, and reopen the Word file. If Word displays a prompt about updating links, allow the update only when you trust the source. If the source path has changed, relink or recreate the linked paste; if updates are no longer needed, replace it with a normal paste.

The Paste Special choices are different or missing. The available formats depend on the operating system, Office build, and clipboard content. Try copying the cells again from the desktop Excel app and opening Word’s Home > Paste > Paste Special immediately afterward. If the option you need is unavailable, use a regular paste as an editable table or paste a picture for a fixed snapshot.

Frequently Asked Questions

Can I export an Excel table to Word without copying and pasting?
For most purposes, copying the cells and pasting them into Word is the direct method. Excel does not provide a general one-click command that exports a selected table into an existing Word document with every Excel feature intact.

Can I edit an Excel table after pasting it into Word?
Yes, if you pasted it as a Word table, you can edit the text, rows, columns, and much of the formatting in Word. Those edits do not change the original Excel workbook. An embedded Excel object can be opened for spreadsheet-style editing, while a picture is not editable cell by cell.

Will changes in Excel appear automatically in Word?
Not with a normal paste. A linked paste can reflect workbook changes when the link is available and updated, but it relies on the source file and may require Word to refresh the link. An embedded copy and a picture do not automatically stay synchronized with the original workbook.

How do I fit an Excel table onto one Word page?
First try landscape orientation, narrower margins, and Word’s AutoFit options. If it is still too wide, consider removing nonessential columns or dividing the content into smaller tables. Shrinking the font excessively can make the result unreadable, and a long table may need more than one page.

Can I copy only visible rows from a filtered Excel table?
Copying a filtered range may include only visible cells, but the result can depend on how the range is selected. Review the pasted Word table to verify that it contains exactly the records you intended. If it does not, adjust the selection in Excel and copy again rather than assuming hidden rows were handled as expected.

Which method is best for a document I will send to someone else?
A normal editable Word table is usually the most portable choice because it does not depend on a separate workbook. Use a linked object only when continued updates are important and the recipient can access the source file. Use a picture when the appearance should remain fixed and editing is not required.

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.