Convert Excel to Word: Tables, Links, and Formatting

How-to basics · Updated November 20, 2026

To convert Excel content into Word, select the cells you need in Excel, copy them, and paste them into your Word document. Choose a paste option to keep the spreadsheet’s appearance, match Word’s styles, or paste a picture. If you need the Word copy to update when the workbook changes, use a linked paste instead. Excel does not have a one-click command that turns an entire workbook into an editable Word document, so choose the method that suits the content and how you plan to use it.

The steps below are for Excel and Word for Microsoft 365 on Windows. The most reliable way to make a readable document is to move only the relevant ranges, then adjust the table in Word. If you need to preserve the workbook itself, embed it or link to its file rather than trying to reproduce every worksheet as a Word table.

What You’ll Need

  • A saved Excel workbook and a Word document. If you plan to link or embed the workbook, save it in a location you can access later.
  • Excel and Word for Microsoft 365 on Windows for the full range of paste and object options. On a Mac, basic copying and pasting works, but link and object choices may differ by version.
  • A decision about the result you want: an editable Word table, a picture that preserves its look, a linked range that can update, or an embedded workbook that travels with the document.

Step-by-Step

  1. Choose what to bring over. Open the workbook in Excel and identify the sheet and cell range that belong in the document. For a report, it is usually clearer to copy a focused range rather than an entire worksheet. Include the column headings and any notes readers need to understand the figures. If the range has hidden rows or columns, check whether they should remain hidden or whether the reader needs that information before copying.

  2. Prepare the worksheet range. Check that the values, labels, number formats, and column widths are readable. Widen columns or wrap long headings in Excel before copying. Remove temporary filters or selections that could make the copied range confusing. If the table is wider than a Word page, consider copying a smaller range, splitting it into sections, or planning to use a landscape page. Save the workbook first, especially if you will create a link or embedded object.

  3. Copy the cells in Excel. Select the cells by dragging across the range or by clicking a cell and using Shift with the arrow keys. Press Ctrl+C on Windows. The moving dashed border indicates that the selection is on the clipboard. On a Mac, use Command+C. Avoid selecting the whole worksheet unless you genuinely need all its rows and columns; large selections can create unwieldy Word tables.

  4. Paste the range into Word. Click where the table should begin and press Ctrl+V on Windows, or Command+V on a Mac. Word normally inserts the selection as a table that you can edit. After pasting, use the Paste Options button that appears beside the content, when available. Choose Keep Source Formatting to retain Excel’s colors and borders, or Use Destination Styles to make the table fit the Word document’s style. The available labels can vary slightly between Word versions.

  5. Choose a picture if the appearance matters more than cell editing. In Word for Windows, copy the range in Excel, then select Home > Paste arrow > Paste Special. Choose a picture format from the list, if offered, and confirm. The exact picture formats shown can depend on the Office version. A pasted picture keeps the layout from Excel but its cells cannot be edited as table cells in Word. This can be useful for a compact dashboard or carefully formatted summary that should not reflow.

  6. Create a linked range when updates matter. In Excel, copy the cells. In Word for Windows, choose Home > Paste arrow > Paste Special. In the dialog, select Paste link, choose a suitable Excel worksheet or formatted-text option if it is listed, and select OK. The link refers to the source workbook, so keep that file in its original location or be ready to repair the link if you move it. Some paste formats preserve more of Excel’s appearance than others. Mac and web versions may not show the same Paste Special choices; if Paste link is unavailable, use Word desktop on Windows or paste a normal table and update it manually.

  7. Embed the workbook when you need the file inside Word. 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 document. Select Display as icon if you want a clickable workbook icon instead of a visible preview, then select OK. Double-clicking an embedded object opens it for editing in Excel. Embedding can increase the Word file size, and edits to the original workbook will not automatically change the embedded copy.

  8. Check the finished document. Click the pasted table and inspect the layout at the page size where it will be read or printed. In Word, use Table Layout options to adjust column widths, or drag a table border where appropriate. If the table is too wide, change the page orientation using Layout > Orientation > Landscape, or reduce the number of columns shown. Save the Word document, close it, and reopen it to confirm the content and any links or embedded objects still behave as expected.

Common Mistakes

Copying too much. Bringing over a full worksheet can add blank-looking pages, tiny text, or unnecessary rows. Select only the cells readers need. If the data spans several distinct sections, make separate tables with clear headings rather than forcing everything into one wide table.

Assuming a pasted table stays connected to Excel. A standard Ctrl+V paste is generally a snapshot in Word: later workbook edits do not automatically update it. Use Paste Special with Paste link when you need a connection, and verify that the link points to the intended workbook.

Choosing an embedded workbook when a table is needed. An embedded object is a workbook stored inside Word, not a regular Word table. Readers may need to double-click it to see or edit its contents. If the information should be visible immediately and easy to read, paste the range as a table instead.

Using a picture for data that needs editing. A picture may look exactly right but cannot be sorted, selected cell by cell, or corrected as a Word table. Use it only when presentation is the priority and the source data is available elsewhere.

Moving a linked workbook without checking the connection. A link can stop working if the source file is renamed, moved, or unavailable to the person opening the document. Keep linked files in a shared, stable location and test the document from the intended environment.

Tips

  • Pick one approach per purpose. Use a Word table for readable, editable content; a picture for fixed visual presentation; a link for content that should reflect source changes; and an embedded object when the workbook itself must be carried in the document.
  • Make the source range tidy first. Consistent number formats, concise headings, and sensible column widths usually make the Word result easier to fix. Do not rely on shrinking the entire table until the text is too small to read.
  • Use Word page layout deliberately. A landscape section can help with a wide table without changing every page. In Word, place the cursor before the table and use Layout > Breaks > Next Page to add a section break; add another after the table, then set that section to landscape with Layout > Orientation > Landscape. Check the section boundaries so following text returns to the intended layout.
  • Keep an editable source copy. Even if you paste a picture or embed a workbook, retain the original Excel file in a known location. It is easier to correct the data in Excel and make a fresh copy than to reconstruct it from a static image.
  • Test a sample before preparing a long report. Copy one representative range and check its font, borders, alignment, and page fit. Once you know which paste option gives the right result, use it for the remaining tables.

Troubleshooting

The table runs off the page. In Word, select the table and use Table Layout to adjust column widths, or reduce unnecessary columns. You can also set that page or section to landscape. If the font becomes too small, split the table into two related tables or move supporting details into a note instead of compressing everything.

The formatting looks different after pasting. Use the Paste Options button to switch between source formatting and destination styles. If you no longer see the button, undo the paste and repeat it, then choose a different option immediately. For a layout that must remain fixed, paste the range as a picture. Excel themes and Word styles do not always map perfectly, so inspect colors, borders, and number formats rather than assuming the preview is exact.

The linked content does not update. First open the source workbook and confirm that it is saved. In Word for Windows, right-click the linked content and look for an option such as Update Link. If the workbook was moved or renamed, Word may ask you to locate the source; browse to the correct file. If the link cannot be repaired or the document will be shared with people who cannot access the source, replace it with a normal pasted table or embed the workbook instead.

The embedded workbook is not visible as a table. If you selected Display as icon, Word will show an icon rather than the worksheet preview; double-click it to open the workbook. To show a visible range, copy and paste that range as a table, or insert the workbook object again without the icon option. An embedded workbook is not designed to display every worksheet as a large, readable Word table automatically.

Paste Special or Object is missing. Confirm that you are using the Word desktop app on Windows and that Excel cells, rather than an image or another object, are on the clipboard. Word for the web and some Mac versions have fewer object and link controls. If the required option is unavailable, use a standard paste, or open the files in the Windows desktop apps for the linked or embedded workflow.

Frequently Asked Questions

Can I convert an entire Excel workbook into a Word document at once?

Not as a clean, editable Word document with one command. Copy the relevant ranges sheet by sheet, or embed the workbook as an object if readers need the original Excel file. For a large workbook, decide which data belongs in the report rather than copying every sheet.

Will formulas still work after I paste an Excel table into Word?

A regular pasted Word table contains the displayed cell contents, not a live Excel calculation model. The formulas remain in the original workbook. A linked range can reflect changes made in Excel, but calculations are still performed by Excel, not by Word table cells.

What is the difference between linking and embedding?

A linked object refers to a separate Excel file and can show changes when the link is updated, but the source file must remain accessible. An embedded object stores a copy of the workbook inside the Word document and does not update when the original changes.

Can I edit the pasted Excel data in Word?

If you pasted cells as a Word table, you can edit its text and cell layout in Word, but it will not behave like a full Excel worksheet. If you pasted a picture, you cannot edit individual cells. Double-click an embedded workbook to edit its contents in Excel.

Can I do this in Word or Excel for the web?

Basic copy and paste between browser-based Excel and Word can work, but paste formatting and object or link features may be limited. For Paste Special links or embedding a workbook, use the desktop apps where those commands are available.

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.