How to Convert an Excel Sheet to Word

How-to basics · Updated November 20, 2026

To convert an Excel sheet to Word, select the cells you want in Excel, copy them, then paste them into a Word document. Choose a regular table for editable text, a linked or embedded Excel object to preserve spreadsheet behavior, or a picture for a fixed layout. You will need Excel and Word, plus the workbook and document you want to use.

What You’ll Need

  • Microsoft Excel and Microsoft Word for Microsoft 365 on a Windows computer for the menu paths below. The steps are similar in recent desktop versions.
  • The Excel workbook containing the data, saved in a location you can access.
  • An existing Word document, or a new blank document. For large tables, plan to use landscape orientation or a smaller range so the result fits the page.
  • If you want the Word version to update when the workbook changes, keep the workbook in a stable location. A linked object can stop updating if the file is moved, renamed, or unavailable.

Step-by-Step

  1. Decide what the Word version should do. A pasted Word table is usually best when you want to edit the words and numbers in Word. A linked Excel object is useful when the source data will continue to change and you want to refresh it. An embedded object keeps a copy of the spreadsheet inside the document, while a picture is best when appearance matters more than editing. These choices are not interchangeable: a normal pasted table does not keep Excel formulas or automatically sync with the workbook.
  2. Prepare the worksheet. Open the workbook in Excel and go to the sheet you need. Check that headings are clear, unnecessary columns are hidden or excluded, and number formats look right. If the sheet contains notes or totals that should not appear, decide whether to leave them out. Save the workbook before copying so the source file is up to date. If the data spans several sheets, you will usually need to copy and paste each sheet or range separately.
  3. Select only the cells you want to transfer. Click the first cell and drag across the range, or click the first cell and hold Shift while selecting the last cell. To select a contiguous data block, click inside it and press Ctrl+A on Windows; check the highlighted range before proceeding, because repeated presses can select more of the sheet. On Mac, use Command+A. Avoid selecting entire rows or columns unless you genuinely need them, as that can produce an unwieldy table in Word.
  4. Copy the selection. Press Ctrl+C on Windows, or Command+C on Mac. You can also use Home > Copy in Excel. A moving border around the cells indicates that they have been copied. Do not cut the cells: copying leaves the original worksheet intact. If Excel displays a prompt about a large selection or the clipboard, allow the copy to complete before switching to Word.
  5. Paste a regular editable table into Word. Open the target document and click where the table should begin. Press Ctrl+V on Windows or Command+V on Mac. In Word for Windows, use the Paste Options button that appears beside the pasted content, or open Home > Paste to see available paste choices. Choose Keep Source Formatting to retain much of Excel’s appearance, or Use Destination Styles to make the table better match the Word document. The result is a Word table: you can edit its text and cells in Word, but Excel formulas and spreadsheet features are not carried over as working formulas.
  6. Choose a linked or embedded Excel object when spreadsheet behavior matters. In Word for Windows, click the location for the object, then select Home > Paste arrow > Paste Special. In the dialog, choose Paste link to connect the content to the source workbook, then select a suitable Excel worksheet object or formatted text option if it is listed. A link can reflect later changes to the source, but may prompt you to update links when opening the document. To store a separate copy in the Word file, choose Paste rather than Paste link and select Microsoft Excel Worksheet Object when available. Double-clicking an embedded object opens it for editing in Excel. Options vary with the copied selection and Office version. On Mac, the Paste Special choices differ by version; if the dialog does not offer the object type you need, use the normal paste options or paste the range as a picture instead.
  7. Paste as a picture for a fixed appearance. Copy the cells in Excel, then in Word choose Home > Paste arrow > Paste Special and select a picture format if offered. Some versions also show a Picture option in the Paste Options button after a regular paste. A picture preserves the visible appearance but its cell contents are not editable as a Word table, and it will not update when the spreadsheet changes. You can resize it in Word, but avoid enlarging it beyond its original resolution if the text must remain sharp.
  8. Make a wide or long table fit the page. Click in the pasted table and use Table Layout > AutoFit > AutoFit Window in Word for Windows to fit the table to the available page width. If the columns are still too narrow, choose Layout > Orientation > Landscape, or adjust the margins using Layout > Margins. You can also reduce font size modestly or split a very wide range into two smaller tables. On Mac, the table layout controls are on the Table Layout tab when the table is selected, though the ribbon arrangement may differ.
  9. Check the result and save both files. Review the first and last rows, column headings, decimal places, dates, borders, and any totals. Check that no required data was clipped or omitted. Save the Word file with File > Save As and choose a location and document name. If you created a linked object, do not move or rename the Excel workbook without updating the link. Keep the original workbook as the authoritative source if it contains formulas or data validation.

For a simple, one-time transfer, the regular copy-and-paste method is usually the quickest. For example, to place a monthly sales summary in a report, select the summary cells rather than the whole worksheet, paste them as a Word table, then use AutoFit Window and check that currency values remain readable. If readers need to change the underlying calculations, provide the workbook as well rather than relying on a Word table.

Common Mistakes

  • Copying the whole worksheet by accident. A sheet can contain thousands of rows and columns, including empty formatted cells. Selecting too much may create a huge document or make Word slow. Confirm the highlighted range in Excel and copy just the relevant data.
  • Expecting a Word table to retain Excel formulas. A regular paste transfers displayed content and some formatting, not a working spreadsheet calculation model. Use an embedded or linked Excel object if people need to inspect or edit formulas.
  • Choosing a link without considering file location. A linked object depends on the source workbook remaining accessible. Moving the workbook, changing its name, or sending only the Word file can break the connection. For a self-contained document, embed the object or paste a table or picture instead.
  • Using a picture when the data must be accessible or editable. Pictures do not behave like tables, so readers cannot select individual cell contents or sort the data. Use a Word table for editable text, and consider accessibility and alternative text if a picture is necessary.
  • Ignoring page width and readability. A pasted table may extend beyond the page or shrink to text that is too small. Check the document in Print Layout and adjust orientation, margins, range size, or font size before sharing it.
  • Assuming every Excel feature transfers. Filters, formulas, charts, conditional formatting, data validation, and interactive controls may look different or may not work after a normal paste. Check the specific content in Word rather than assuming the copied result is a complete replacement for the workbook.

Tips

  • Choose the paste method before copying. The intended result determines whether you should use a table, object, or picture. This avoids reformatting a large selection after discovering it is not editable in the way you need.
  • Keep the Word document’s style consistent. Use Use Destination Styles when the table should match existing headings and fonts. Use Keep Source Formatting when Excel’s fills, borders, and number appearance are important. You can still adjust the table after pasting.
  • Use a stable folder for linked files. Store the Word document and its source workbook together in a shared folder that will remain available. When sending the document, send the workbook too if recipients need the link to update.
  • Use a small test range first. If the worksheet has merged cells, unusual number formats, or many columns, copy a few representative rows and check the result before transferring the full range. This helps reveal layout problems early.
  • Keep a source copy for future edits. A Word table is convenient for reports, but Excel remains easier for calculations, filtering, and bulk changes. Retain the workbook and note which sheet or range was copied if the report may need to be refreshed later.
  • Think about page breaks. Long tables can continue onto another page, and Word may split rows across pages depending on table settings. If a heading needs to repeat, select the header row and use Table Layout > Repeat Header Rows in Word for Windows. Check the printed or PDF layout after applying it.

Troubleshooting

  • The table is too wide or some columns are missing. Click inside the table and select Table Layout > AutoFit > AutoFit Window. If that makes the text too small, switch to landscape orientation, reduce the copied range, or split the data into separate tables. Check in Print Layout, because the editing view may not reveal what will be cut off on the page.
  • Formatting changes after pasting. Undo the paste with Ctrl+Z on Windows or Command+Z on Mac, then paste again and select Keep Source Formatting or Use Destination Styles. If those choices do not preserve the needed appearance, try Paste Special and choose a picture for a fixed layout. The available choices depend on the copied material.
  • The linked content does not update. Confirm that the source workbook still exists at the original path and that the link is enabled. In Word for Windows, use File > Info and look for Edit Links to Files when that command is available; select the link and update it. If the workbook was moved or renamed, browse to its new location if prompted, or recreate the linked paste from Excel. Mac versions may expose link management differently.
  • Paste Special does not show an Excel object. The choices depend on what is currently on the clipboard and the Office version. Copy the cell range again, reopen Paste Special, and check the listed formats. If the object option remains unavailable, use an ordinary Word table for editable text or paste a picture for appearance. You can also try the command from Word’s Home tab rather than a context menu.
  • The document becomes very large or slow. A large embedded workbook or high-resolution picture can increase file size. Reduce the copied range, use a regular Word table for static values, or use a link when recipients can access the source workbook. Avoid embedding an entire workbook when only a small summary is needed.
  • Dates or numbers look different. Excel’s display formats do not always carry over identically. Check the source cell’s displayed value and the Word result, then adjust the Word table’s formatting or recopy using a different paste option. If exact appearance is essential, a picture is more predictable, but it is not editable as text.

Frequently Asked Questions

Can I convert an entire Excel workbook directly into a Word document?
Word does not turn an entire workbook into a set of native Word pages with one conversion command. Copy and paste each needed range or sheet, or insert an Excel object if you want the workbook available inside the document. For a report, it is usually clearer to include only the relevant tables.

Will Excel formulas still work after I paste a sheet into Word?
Not in a normal Word table. The pasted cells become Word content and do not recalculate like Excel cells. Embed an Excel worksheet object to retain a separately editable spreadsheet copy, or link an object to the workbook if you need an updateable connection.

Can I make the Word table update automatically when Excel changes?
A linked paste can update from the workbook, but it may require Word to refresh the link and it depends on the source file staying accessible. A normal pasted table and a picture do not update automatically. Check the linked result before distributing the document.

What is the best way to keep the spreadsheet’s formatting?
For an editable table, choose Keep Source Formatting in Word’s Paste Options. For a layout that must look exactly like the copied cells, paste as a picture. The picture is less flexible, while some Excel formatting may change when converted into a Word table.

Can I do this in Excel for the web or Word for the web?
You can copy cells in the browser and paste them into a Word document, but browser clipboard behavior and Paste Special options are more limited than in the desktop apps. If you need an embedded or linked Excel object, use the desktop Word app. For a basic table, try the browser copy-and-paste workflow and check the result carefully.

Is copying and pasting the same as saving Excel as a Word file?
No. Excel does not provide a standard Save As option that turns a workbook into a Word document. Copying and pasting transfers selected content into a document; choosing the paste format determines whether the result is a Word table, an Excel object, or a picture.

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.