To import Excel data into Word, select and copy the cells in Excel, then paste them into Word; choose a paste option to make a regular Word table, keep Excel formatting, or link the data to the workbook. If you need to include a whole workbook instead of a cell range, insert it as an embedded or linked object. The right method depends on whether readers should edit the data in Word, update it from Excel, or simply view it.
The steps below are for Microsoft 365 Word and Excel on Windows. Keep both files saved before you begin, especially if you plan to link them. A linked object depends on the Excel workbook staying available at the same file path.
What You’ll Need
- A Word document and an Excel workbook, preferably saved as .docx and .xlsx files.
- Microsoft Word and Excel for Microsoft 365 on Windows for the ribbon paths below. On Mac, the main copy-and-paste approach is similar, but some Paste Special and object options appear in different menus.
- A decision about the result you want: a Word table, a picture, an embedded workbook, or a link that can reflect later Excel changes.
- If you are linking the files, a stable location for the Excel workbook. Avoid moving or renaming it after you create the link.
Step-by-Step
- Choose the Excel content to bring over. Open the workbook and go to the worksheet with the data. For a table in Word, select the exact cell range, including column headings if you want them included. Avoid selecting entire unused rows or columns, since that can create a large, awkward table. If the content spans several areas, copy and paste each section separately or arrange it as one continuous range first. Save the workbook before copying so the source data is current.
- Copy the selected cells. Press Ctrl+C in Excel on Windows. On a Mac, press Command+C. You can also use Home > Copy. A moving dotted outline around the selection indicates that it is on the clipboard. Do not close Excel before pasting if you have copied a large or specially formatted range; keeping the workbook open can help preserve available paste choices.
- Paste the range into Word as a table. Click in the document where the table should begin, then use Home > Paste or press Ctrl+V. Word normally creates a table that you can edit as Word content. This is usually the best option for a report whose table needs to match the document and be edited alongside its text. On a Mac, use Command+V. After pasting, look for the Paste Options button near the table; its choices may include retaining source formatting or matching the destination formatting.
- Select a paste style that suits the document. If the default table does not look right, undo it with Ctrl+Z, copy the range again, and use Word’s Home > Paste menu to inspect the available options. Keep Source Formatting aims to preserve Excel’s appearance. Use Destination Styles adapts the table to Word’s theme. The exact labels and icons can vary by Office build and selection. When available, choose a picture option if you only need a fixed visual and do not need to edit individual cells. A picture may be harder to read if it is reduced to fit the page.
- Use Paste Special for more control. With the Excel cells copied, click the insertion point in Word and choose Home > Paste > Paste Special. In the dialog, choose an available format such as a Microsoft Excel Worksheet Object or a picture, then select Paste and confirm with OK. Choose Paste Link instead of Paste when you want the inserted content to refer to the source workbook. The choices depend on what is on the clipboard and the installed Office version. On Mac, look under Edit > Paste Special; the list of formats can differ.
- Embed a workbook when you want the Excel file inside the document. In Word, choose Insert > Object > Object, then open the Create from File tab. Select Browse, locate the workbook, and select Insert. Leave Link to file cleared to embed a copy in the Word document. If you want a clickable icon instead of a worksheet preview, select Display as icon before confirming with OK. An embedded workbook can be opened for editing, but it is a separate copy: changes to the original Excel file do not automatically update it. On Mac, look for Object under the Insert menu; the available options may vary by Word version.
- Link a workbook or copied range when updates matter. To link a file as an object, repeat Insert > Object > Object > Create from File, browse to the workbook, and select Link to file before choosing OK. For a copied cell range, use Paste Special and select Paste Link if that choice is offered. A link can reflect changes made in Excel, but it relies on Word being able to find the source file. Keep the workbook in a shared, stable folder and test the link after moving or sharing the document. If Word asks whether to update links when opening the file, update only when you trust the source and want its latest data.
- Fit and check the result. Review the pasted content in Print Layout. For a Word table, use Table Layout options to adjust column widths, or select the table and choose AutoFit options if shown. If the table is too wide, consider reducing its columns, using a landscape page for that section, or splitting the information into smaller tables. Check that headings, number formats, borders, and footnotes remain clear. Save the document, close it, and reopen it to make sure an embedded object or link still behaves as expected.
Common Mistakes
- Expecting every paste to stay connected to Excel. A normal paste creates Word content, not a live link. If updates should follow Excel changes, use Paste Link or insert the workbook with Link to file selected.
- Confusing an embedded workbook with a linked workbook. Embedding stores a copy inside Word and increases the document size. Linking points to an external file and can break if that file is moved, renamed, or unavailable.
- Copying too much worksheet area. Selecting blank cells around the data can produce a huge table or object. Select only the cells readers need, including relevant headings and totals.
- Choosing a picture when the data needs editing. A picture may preserve the appearance but its cell contents are not editable as a table. Choose a Word table or Excel object if readers need to change values.
- Assuming Excel formatting will fit a Word page. Wide sheets may extend beyond the margins or shrink until the text is unreadable. Check page width and readability rather than relying on the initial paste preview.
- Moving a linked workbook after inserting it. Word may no longer find the source. Store the document and workbook together in a stable folder, and verify links when sharing with another person.
Tips
- Use a Word table when the data is small, needs to flow naturally with the document, or must be edited as part of the report.
- Use an embedded Excel object when readers may need to open the workbook content from Word but you do not need changes in the original file to flow through.
- Use a linked object or Paste Link when Excel remains the source of truth and Word should display its current data. Keep a backup, because a linked document may show different content after the source is updated.
- Use a picture for a finished chart or table that should not change. Make sure it is large enough to read at normal page size, and add alternative text if accessibility is important.
- For long tables, repeat the header row on later pages using the table layout controls in Word. Consider adding a caption or a sentence that explains what the figures represent.
- Before sharing, test the document on the device or account that will receive it. A link that works on your computer may not work for someone who cannot access the workbook’s folder.
Troubleshooting
The pasted table is too wide or runs off the page: In Word, select the table and reduce unnecessary column widths. You can also change the page orientation from Layout > Orientation > Landscape, use narrower margins, or split the table. Avoid shrinking text so far that the values become difficult to read.
The formatting looks different from Excel: Undo the paste and try another Paste Options choice, such as Keep Source Formatting or Use Destination Styles. Some Excel features do not translate exactly into a Word table. Conditional formatting, formulas, filters, and interactive controls may not behave as they do in Excel. If appearance is the priority, paste as a picture; if Excel behavior matters, insert or embed the workbook.
The object appears as an icon or will not open: If you selected Display as icon, double-click the icon to open the embedded or linked workbook. If it does not open, confirm that Excel is installed and that the Word file is not in Protected View or blocked by an organizational security setting. Try opening the workbook directly in Excel to check that it is valid.
The link does not update or Word cannot find the source: Confirm that the original workbook still exists in the same location and that you have permission to access it. If it was moved, restore it to its former path or create the link again from its new location. To inspect links in Word for Windows, use File > Info and look for Edit Links to Files when that command is available. If you do not need future updates, replace the link with a pasted or embedded copy.
The Excel cells paste as plain text or with missing parts: Copy the range again and check that the entire selection is outlined before switching to Word. Use Paste Special to choose an available Excel object or picture format. For a very large range, try copying a smaller section at a time. If the source contains merged cells or complex formatting, simplify the range in Excel before copying.
Frequently Asked Questions
Can I import an entire Excel workbook into Word?
You can insert the workbook as an embedded or linked object using Insert > Object > Object > Create from File. This does not turn every worksheet into a series of ordinary Word tables. Readers can open the object in Excel, or you can show it as an icon. To display worksheet data directly on the page, copy and paste the relevant cell ranges separately.
How do I keep the Excel data editable in Word?
Paste the cells as a Word table if you want to edit the values and layout directly in Word. The pasted table is separate from Excel, so edits made in Word do not update the original workbook. To edit in Excel instead, insert an embedded workbook object or link to the source file.
Will changes in Excel automatically appear in Word?
Only if you created a link, and even then Word may ask before updating linked content. A standard paste and an embedded copy do not stay synchronized with the original workbook. Keep the source file accessible and use Word’s link update prompt when you want the latest data.
What is the difference between linking and embedding?
An embedded workbook is stored inside the Word document, so it travels with that document but can make the file larger. A linked workbook remains a separate file, and Word refers to its location. Links can update from the source but can fail when the file is moved or unavailable.
Can I import an Excel chart into Word?
Yes. Select the chart in Excel, copy it, then paste it into Word. Choose a picture option for a fixed image, or an Excel object or linked option if you need to preserve a connection or edit the chart in Excel. Check the chart’s size and labels in the final page layout.
Related
- How to Find Blank Rows in Excel
- How to Find the Center of a Page in Excel for Printing
- How to Find the Average Percentage in Excel Correctly
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Lock an Excel Page and Protect Its Cells SafelyTo lock an Excel page, protect the worksheet: in Excel for Microsoft 365 on Windows, open the sheet,…
- Duplicate Filter in Google Sheets: Find Repeated RowsTo filter duplicates in Google Sheets, add a helper column with a COUNTIF formula, then filter that column…
- Change Google Sheets Date Format to AustraliaTo use Australian dates in Google Sheets, open the spreadsheet in a browser and choose File > Settings.…
- How to Insert a Line in a Word Document: 5 MethodsTo insert a line in a Word document, use a quick hyphen shortcut, add a paragraph border, draw…
- Excel Audit Spreadsheet Examples and How to Build ThemUseful Excel audit spreadsheet examples include an expense review log, a bank reconciliation, an inventory count comparison, and…
- Sort Highest to Lowest in Google Sheets: A Clear GuideTo sort values from highest to lowest in Google Sheets, select the full data range, choose Data >…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.