To convert an Excel spreadsheet to Word, select the cells you want in Excel, copy them, then paste them into a Word document. Choose whether to keep the Excel formatting, match Word’s styles, link the table so it can update, or paste it as a picture. There is no single command that turns an entire workbook into a fully editable Word document, so decide whether you need a table, a live-linked range, or a visual snapshot before you begin.
What You’ll Need
- Microsoft Excel and Word for Microsoft 365 on a Windows computer for the ribbon paths below. The same basic copy-and-paste method works on Mac, though some Paste Special and object options differ.
- The workbook saved in a place you can access, and a Word document where you want the information to appear.
- A clear idea of which worksheet cells, charts, or other content you need. A large workbook may be better represented by selected ranges or a chart rather than every sheet.
- If you want a linked table, keep the workbook in a stable location and retain access to it. Word needs the source workbook to refresh linked information.
Step-by-Step
- Choose what to bring into Word. Open the workbook in Excel and review the sheets. For a table, select only the relevant cells, including headings if they should appear in the document. If the data is a formatted Excel table, click inside it and use the table’s resize handles or select the required cell range. To select a contiguous range, click its first cell, hold Shift, and click the last cell. To select separate ranges, hold Ctrl while selecting each range, but note that non-adjacent selections may not paste as one neat table. For a chart, click its outer edge so the chart itself is selected.
- Prepare the range for a readable page. In Excel, check that column headings are clear, unnecessary columns are removed from the selection, and number formats look as intended. Adjust column widths if values are cut off. You can use Home > Format > AutoFit Column Width, or double-click a column boundary. Consider whether the table will fit on a portrait page; wide tables often work better on a landscape page in Word. Avoid selecting entire columns or rows unless you truly need them, since a huge selection can create an unwieldy document.
- Copy the selection. With the cells or chart selected, choose Home > Copy or press Ctrl+C on Windows. The Mac shortcut is Command+C. A moving dashed outline around copied cells indicates that the selection is on the clipboard. If you need a specific chart size, you can first resize it in Excel; Word may still allow you to resize the pasted version later.
- Open the Word document and set up the page. Place the insertion point where the spreadsheet content should go. For a wide table, choose Layout > Orientation > Landscape before pasting. You can also use Layout > Margins to choose narrower margins if that improves readability, while leaving enough space for printing or binding. Add a heading or explanatory sentence if readers need context, such as the reporting period or the units used in the figures.
- Paste an editable table with the original appearance. In Word, choose Home > Paste, then select Keep Source Formatting if it is offered. This usually preserves Excel’s cell colors, borders, and font choices while placing the data in a Word table. You can also press Ctrl+V on Windows or Command+V on Mac, then use the Paste Options button that appears beside the pasted content to select a format. The exact options shown can depend on the content and Office version.
- Choose a Word-friendly appearance if needed. If the pasted table looks crowded or clashes with the document, use Home > Paste and choose Use Destination Styles, or paste normally and adjust the table in Word. Click inside it to show the Table Design and Layout tabs. These options let you change borders, shading, alignment, and column widths. Word’s layout is separate from the worksheet, so changing the Word table will not change the original Excel cells.
- Use Paste Special for more control. In Word for Windows, choose Home > Paste arrow > Paste Special. In the dialog, select a format such as Formatted Text (RTF) or HTML Format for a table that remains editable, or Picture (Enhanced Metafile) for a sharp, fixed image. Choose Microsoft Excel Worksheet Object when you want the pasted content to behave like an embedded spreadsheet that can be opened for editing. The available names can vary slightly by Office version and what you copied. On Mac, use Edit > Paste Special if available, or use the paste options shown after Command+V.
- Link the table if it should reflect later Excel changes. In Word for Windows, open Home > Paste arrow > Paste Special, select Paste link, and choose an appropriate format, such as Formatted Text (RTF) for a table or a picture format for a visual snapshot. Confirm with OK. A linked range can update when the workbook changes, but the link depends on the source file remaining accessible. This option may not be present in Word for the web and can behave differently on Mac, so use an ordinary paste if the link choice is unavailable.
- Insert the workbook as an object when you need the spreadsheet itself. In desktop Word for Windows, choose Insert > Object > Object, then open the Create from File tab and browse to the workbook. Select Display as icon if you want a clickable workbook icon instead of a visible sheet preview. Select Link to file if Word should refer to the workbook at its saved location; leave it unchecked to embed a copy in the document. An embedded workbook can increase document size, while a linked workbook can break if it is moved or renamed. Object options vary by platform; copy and paste is generally the simpler route on Mac or Word for the web.
- Fit and check the result. Click the pasted table and inspect the columns, row breaks, and text size. In Word, use Table Layout > AutoFit to Contents to size columns around their contents, or AutoFit to Window to fit the table to the page width. If the table remains too wide, change the page to landscape, reduce margins, or split the information into smaller tables. Use File > Print or Ctrl+P on Windows (Command+P on Mac) to preview page breaks before sharing or printing.
- Save the Word file and verify any links. Choose File > Save As and save the document as a Word Document (.docx). If you pasted a link, save the Excel workbook in its intended location too. Close and reopen the Word file, then check that the table or object still appears. If Word asks whether to update links, update only when you trust the source workbook and want its current values. Keep the Excel file as the authoritative data source if the Word copy is only for reporting.
Common Mistakes
Copying too much. Selecting a whole worksheet can put thousands of blank-looking rows or columns into Word, slow editing, or create many pages. Select the used range or only the required table. Before copying, scroll to the edges of the selection and confirm that it ends where expected.
Assuming a pasted table stays connected. A regular paste creates a separate Word copy. Later edits in Excel will not automatically change it. Use Paste Special with Paste link when updating matters, and confirm that the source workbook remains available. Conversely, do not create a link if the document must be self-contained and portable.
Expecting formulas to work like Excel formulas. A Word table is mainly for presenting information. Pasted formula cells generally show their displayed results, rather than becoming a working Excel calculation model. If readers need to change inputs or inspect formulas, embed the sheet or provide the workbook alongside the document.
Ignoring page width and print layout. A table that looks fine on screen may be clipped or split awkwardly when printed. Check print preview, and do not shrink text until it is difficult to read. A landscape page, smaller margins, or a deliberate split into sections is usually clearer.
Moving a linked workbook after pasting. Links can point to a specific file path. Renaming or moving the workbook may leave Word unable to find it. Put both files in their final folder before creating links, or embed the content instead.
Tips
For an ordinary report, an editable Word table is usually the most practical choice: readers can select, edit, and format its text without opening Excel. For a dashboard or a range whose exact colors and proportions matter, use a picture paste. It will preserve the appearance but will not let readers edit individual cell values as a Word table.
Use an embedded Excel object when readers need spreadsheet features such as formulas or multiple sheets inside the document. Double-clicking the object opens its spreadsheet content for editing, but the visible preview may show only part of the worksheet. An icon can keep the page uncluttered, though readers may not realize the file is attached unless you label it clearly.
For linked content, keep the Word document and workbook in the same shared folder when possible, and avoid changing either file’s name after setting up the link. If a document is sent to someone else, test it from the location and account they will use. A link that works on your computer may not work for a recipient who cannot access your drive or network folder.
When copying a chart, decide whether it needs to update with Excel data. A normal chart paste is a static copy; a linked paste can reflect source changes if the link remains intact. If you only need a clean graphic, a picture is often more predictable. Add a caption or source note in Word so the chart’s meaning is clear even when viewed outside the workbook.
Finally, preserve the Excel workbook as a separate source file and compare key totals after pasting. Check that dates, currency, percentages, footnotes, and negative values display correctly. A quick visual review is especially important when a table spans pages or uses merged cells.
Troubleshooting
The table loses its formatting: Undo the paste with Ctrl+Z on Windows or Command+Z on Mac, then paste again using Home > Paste or Paste Special and choose Keep Source Formatting, Formatted Text (RTF), or HTML Format. If you prefer Word’s look, choose Use Destination Styles and apply a consistent table style afterward.
The pasted table is too wide or text is cut off: In Word, select the table and use Table Layout > AutoFit > AutoFit to Window. If that makes the text too small, switch the page to Layout > Orientation > Landscape, adjust margins, or split the range. Also check the original Excel column widths and remove columns that are not needed.
The table appears as a picture and cannot be edited: The content was likely pasted using a picture format. Undo and paste again as a Word table or Formatted Text (RTF). If you actually need to edit the cells in Excel, paste as a Microsoft Excel Worksheet Object or insert the workbook through Insert > Object.
A linked table does not update: Confirm that the Excel source file has been saved, is still in its original location, and is accessible. In Word for Windows, check File > Info for document links when link-management options are available, or right-click the linked content and look for an update option. If the source cannot be found, recreate the link from the workbook’s new location or replace it with a static paste.
The workbook icon or object is missing: Check that you inserted it in desktop Word rather than Word for the web, which does not support every object feature. Reopen the document in desktop Word and try Insert > Object > Object again. If the recipient needs access to a linked file, send or share that workbook too; an icon does not necessarily contain the workbook when Link to file was selected.
Frequently Asked Questions
Can I convert an entire Excel workbook to Word in one step?
Not as a fully editable, multi-sheet Word document with a single conversion command. Copy the required ranges and charts into Word, or insert the workbook as an object if readers need the spreadsheet itself. For a long workbook, consider whether a PDF or shared workbook is more suitable than reproducing every sheet in Word.
Will formulas and calculations still work after I paste a table?
Usually not as Excel calculations. A standard pasted table shows the cell contents and typically preserves formula results as displayed values. To retain a working spreadsheet, embed the workbook or include the original Excel file.
Can I make the Word table update when Excel changes?
Yes, in desktop Word for Windows you can use Home > Paste > Paste Special, select Paste link, and choose a table or picture format. Updates depend on Word being able to locate the workbook. This feature’s availability and controls can differ in Word for Mac and Word for the web.
How do I convert an Excel chart to Word?
Select the chart in Excel, copy it, and paste it into Word. Choose a picture format for a fixed visual, or use Paste Special with Paste link if the chart should follow changes in the workbook. Check the chart in print preview because its size and page placement can change after pasting.
Can I do this without desktop Word?
You can copy cells from Excel for the web and paste them into Word for the web in many cases, then format the resulting table. Web apps may not offer desktop features such as embedding an Excel object or managing every link type. If you need those options, open the files in the desktop Microsoft 365 apps.
Related
- Excel Subscript: How to Change Text to Subscript
- How to Change Strikethrough Color in Excel Cells Easily
- How to Change Note Color in Excel for Easier Scanning
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- FIND in Excel: Syntax, Examples, and Common ErrorsWith the text to search in cell A2, enter =FIND("n",A2) to return the position of the first lowercase…
- Check Box in Word Header: Clickable or PrintableTo put a checkbox in a Word header, open the header by double-clicking the top of a page,…
- Excel Dependent Drop-Down Lists Based on Cell ValuesYes. In Microsoft Excel for Microsoft 365 on Windows, you can make a data validation list depend on…
- Excel: Turn Off Page Break Preview and Restore Normal ViewTo turn off Page Break Preview in Excel for Microsoft 365 on Windows, select View > Workbook Views…
- Excel Vertical Text: How to Rotate Text in CellsTo make text vertical in Excel for Microsoft 365 on Windows, select the cell or range, then choose…
- How to Delete a Blank Last Page in Microsoft Word QuicklyTo delete a blank last page in Word, show formatting marks with Home > Paragraph > Show/Hide ¶,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.