To convert Excel data into a Word document, copy the cells you need in Excel, then paste them into Word as a table, a linked or embedded Excel object, or a picture. Excel does not have a direct Save As Word option, so choose the paste method that suits whether you need to edit the data, keep it updated, or preserve its appearance. The steps below are for Microsoft 365 on Windows.
What You’ll Need
- An Excel workbook and Microsoft Word. The desktop versions of both apps provide the most paste and object options.
- A clear idea of whether you want an editable Word table, an Excel object, a live link to the workbook, or a non-editable image.
- If you plan to link the content, save the Excel workbook in a location that will remain accessible, such as a stable shared folder. Moving or renaming it later can break the link.
You do not need a special converter for a standard cell range. If you only have Excel for the web or Word for the web, copying and pasting a range is usually the simplest route, but some desktop object and link options may not be available.
Step-by-Step
- Decide what should appear in Word. A pasted table is usually best for reports that need editable text and cells. Choose an embedded Excel object if readers may need to open and edit spreadsheet content inside the document. Choose a linked object when Word should reflect changes made to a separate workbook. A picture is useful when layout matters more than editing. These methods do not turn the entire Excel workbook, with all its sheets and formulas, into a native Word document.
- Prepare the Excel range. Open the workbook and go to the worksheet containing the information. Select only the cells you want in Word, including column headings if appropriate. Check that the columns are wide enough to show the important values, remove unnecessary blank rows or columns, and apply number formats such as dates or currency. If formulas show errors or the workbook has not recalculated, resolve that before copying. Save the workbook so the source is current.
- Copy the cells. With the range selected, press Ctrl+C on Windows. On a Mac, press Command+C. You can also use Home > Copy in Excel. A moving border around the selection indicates that the range is on the clipboard. If you want only visible cells from a filtered or hidden-row range, check the selection carefully; copying a range can include hidden cells, depending on how it was selected.
- Paste the range as a Word table. Open the Word document, click where the table should begin, and press Ctrl+V (Windows) or Command+V (Mac). In Word for Microsoft 365 on Windows, use the Paste Options button that appears beside the pasted content, or open Home > Paste to choose an available paste style. Keep Source Formatting retains more of the Excel appearance; Use Destination Styles adapts the table to Word’s document styles. The result is a Word table that you can edit cell by cell, but Excel formulas and spreadsheet behavior do not become Word formulas.
- Adjust the table to fit the page. Click inside the pasted table to display the table tabs. Choose Table Layout > AutoFit > AutoFit Window to fit the table to the page width. If the table has many columns, try Layout > Orientation > Landscape, or reduce margins through Layout > Margins. Use Table Layout > Repeat Header Rows if the table spans multiple pages and its first row contains headings. Review page breaks and cell text after resizing; a table that fits horizontally may still split awkwardly across pages.
- Use Paste Special for a linked or embedded Excel object. In Word for Windows, click the insertion point and choose Home > Paste > Paste Special. Select Microsoft Excel Worksheet Object from the list, then select Paste to embed a copy or Paste link to link to the workbook, if that option is offered. Confirm with OK. An embedded object is stored in the Word file and can usually be opened for editing by double-clicking it. A linked object refers to the original workbook, so changes to that workbook can update the display, subject to Word’s link-update settings and access to the source file. Labels in the dialog can vary slightly between Office builds.
- Insert a workbook as an object when you need more than a copied range. In Word for Windows, choose Insert > Object > Object, then select the Create from File tab and browse to the workbook. Leave Display as icon unchecked to show workbook content, or check it to add an icon readers can open. Select Link to file only if you want Word to refer to the external workbook rather than store a separate copy. An object is not the same as converting every worksheet into Word pages: it is an embedded or linked Excel item that users can open. Check the document on another computer if it depends on a linked file.
- Use a picture for a fixed appearance. Copy the range in Excel, then in Word choose Home > Paste > Paste Special and select a picture option if available. You can also use the Paste Options button and choose a picture format. A picture preserves the visible layout but does not allow readers to edit individual cell values as text. Add alternative text if the document needs to be accessible, and avoid relying on a small image for data readers must inspect closely.
- Save and verify the Word document. Choose File > Save As in Word and save as a Word Document (.docx). Reopen the saved file and check that the table, object, or image remains in place, that text is readable, and that page breaks are acceptable. For a linked workbook, make sure the source file stays in its agreed location and confirm that the link updates as intended before sharing the document.
On Mac, the basic range-copy method is the same: select cells, press Command+C, then paste into Word with Command+V. Paste Special can be opened with Command+Control+V in many Office for Mac versions, or from Word’s Edit or Home paste menus; options vary by version. Windows object and link choices described above are most straightforward in desktop Word. The web apps support ordinary range pasting, but do not assume they offer the same object-embedding or link controls.
Common Mistakes
- Expecting a complete workbook conversion. Pasting cells gives you the selected range, not every worksheet, chart, formula, macro, and workbook feature as editable Word content. Repeat the process for other ranges or insert an object if recipients need to open the spreadsheet itself.
- Choosing a link without keeping the source file available. A linked item may stop updating if someone moves, renames, or cannot access the workbook. Send the source file with the document or use a shared location that recipients can reach. If you need a self-contained file, consider embedding or pasting a table instead.
- Assuming a pasted table keeps Excel functionality. Word tables hold content and formatting, not the workbook’s formula engine, filters, or cell references. If values must be recalculated, keep them in Excel or include an embedded spreadsheet object.
- Copying too much data. A very large range can create an unwieldy Word table or make the document slow to open. Include only useful columns and rows, and consider splitting long data into sections or attaching the workbook separately.
- Ignoring page layout. Wide tables can run off the page, while narrow columns can wrap values into several lines. Check orientation, margins, column widths, and repeated headers before distributing the file.
Tips
- For a report that needs normal Word editing, paste as a table and then apply Word table styles. This makes it easier to match the rest of the document than manually rebuilding the data.
- For content that changes often, a link can reduce repeated copy-and-paste work. However, it introduces a dependency on the source workbook and may prompt recipients to update links. Agree on where the source will live and test the document from the recipient’s access point.
- For a snapshot that should not change, paste a picture or use a regular table and avoid linking it. A table is more accessible and searchable; a picture is more likely to retain exact visual styling.
- Before copying, use Excel’s print preview or adjust the worksheet’s display so values, dates, and headings are easy to interpret. Word will not automatically reproduce every worksheet setting, such as print areas or page layout, when you paste a cell range.
- Keep the original workbook. Pasting data into Word is not a replacement for retaining the spreadsheet, especially if the source contains formulas, charts, or data that may need revision later.
Troubleshooting
The pasted content looks different from Excel: Click the Paste Options button and try Keep Source Formatting. If the table is too wide, use AutoFit Window, switch the page to landscape, or remove columns that are not needed. Excel conditional formatting, fonts, and column widths may not translate exactly.
Paste Special does not show an Excel object: Make sure you copied cells in the desktop Excel app and opened desktop Word, rather than relying on a browser-based app. Try copying the range again, then use Word’s Home > Paste menu. If object options are still unavailable, paste the range as a table or use Insert > Object in desktop Word where supported.
The linked data does not update: Confirm that the workbook still exists at the original path and that you can open it. In Word, right-click the linked item and look for an update or link option; wording can vary. If the source has moved, recreate the link from the workbook’s new location. Do not assume that a recipient can update a link stored on your computer.
The object opens as an icon or shows only part of the sheet: If you inserted the workbook with Display as icon selected, the icon is expected; readers can open it by double-clicking. If you need visible cells in the document, copy and paste the exact range instead. An inserted workbook object is not intended to lay out every worksheet as a sequence of Word pages.
Rows or columns disappear or are hard to read: Return to Excel and verify the copied range, including whether rows were hidden or filtered. Copy a smaller range, check the Word table’s column widths, and compare the result with the source. If you need an exact visual record, paste a picture, but provide an accessible table or the workbook when readers need to search or use the data.
Frequently Asked Questions
Can I convert an Excel file directly to a Word document?
There is no standard Excel Save As option that converts a whole workbook into a native Word document. Copy a selected range into Word, insert an Excel object, or create a PDF if you only need a fixed-view document.
Will Excel formulas still work after I paste cells into Word?
No. A pasted Word table contains the displayed values and formatting, not functioning Excel formulas. To retain spreadsheet behavior, embed an Excel object or keep the workbook as a separate file.
Can I convert multiple worksheets?
Yes, but a simple copy-and-paste operation moves only the range you selected. Repeat it for each sheet or range and add headings in Word so readers can tell the sections apart. Alternatively, attach or embed the workbook for access to all sheets.
Should I paste as a link or embed the workbook?
Use a link when the source workbook will stay accessible and you want updates to flow into Word. Embed when you want a copy stored inside the document, accepting that it can increase file size and will not stay synchronized with the original workbook.
Can I do this in Excel and Word for the web?
You can usually copy a range in Excel for the web and paste it into Word for the web as a table. Desktop-only features such as some Paste Special object and link options may not be available, so use the desktop apps if you need those controls.
What is the best format for a table that must print cleanly?
A Word table is usually preferable because you can adjust its columns, text, and page layout. For an exact snapshot that will not need editing, use a picture, then check its size and legibility in print preview.
Related
- How to Change a Link Name in Excel
- How to Change Every Other Row Color in Excel Automatically
- Indian Number Format in Excel: Apply Lakhs and Crores
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Dependent Drop-Down Lists with Dynamic RangesYes. In Excel for Microsoft 365, make the source data an Excel Table, use a FILTER formula to…
- Excel: How to Paste Only Into Visible RowsTo enter the same value in filtered rows without changing hidden rows, select the destination cells, choose Home…
- How to Make a Color Key in Excel for Clearer SheetsTo make a color key in Excel, set aside a small area of the worksheet, add a labeled…
- How to Double Space in Word Without the Design TabTo double-space text in Microsoft Word, select the text, open Home > Line and Paragraph Spacing, and choose…
- Google Sheets Checkbox Column: Add and Use CheckboxesTo add a checkbox column in Google Sheets, select the cells where the checkboxes should go, then choose…
- Google Sheets Expense Tracking Template: Build One That WorksA Google Sheets expense tracking template is a spreadsheet that records each purchase in a transaction log and…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.