How to Insert Excel Into Word: Step-by-Step Guide

PDF download Download Article
Pull data from Excel to Word
PDF download Download Article

Need to reference an Excel chart, table, or data set in your Word document? You can easily add a quick link to any Excel file in a Word document, or even embed the file within the document to avoid the possibility of broken links. This wikiHow article will teach you how to link an Excel file to a Word document using your Windows or Mac computer.

Quick Steps

  1. Click Insert .
  2. Click Object > Object .
  3. Click Create from File .
  4. Click Browse and select your file.
  5. Check Link to file .
  6. Click OK .
Method 1
Method 1 of 3:

How to Link an Excel File

PDF download Download Article
  1. You can either open it from Word by going to File > Open or you can double-click the file.
  2. It's in the editing ribbon above your document. [1]
    • On Mac, this tab is along the top of your screen instead.
    Advertisement
  3. It's in the Text grouping and will open an Object Dialog Box. [2]
  4. It's at the top of the window. [3]
  5. Your file manager ( File Explorer for Windows and Finder for Mac) will open so you can look for your Excel file. [4]
  6. Alternatively, you can single-click the file to select it, then click Open , OK , or Insert to choose it.
  7. This will create a link to your file that others can click to view the Excel data. Clicking the link will open the Excel data at its original location. [5]
    • If you'd rather embed the Excel file within your Word document, check the box next to "Display as an icon" and click OK .
    8. Advertisement
Method 2
Method 2 of 3:

How to Copy and Paste an Excel Chart

PDF download Download Article
  1. If you want to embed an Excel chart into Microsoft Word, you can copy and paste it into your Word document.
  2. Click and drag one corner of the chart to the other corner to highlight it.
  3. Alternatively, right-click or control-click the chart and select Copy .
  4. You can either open it from Word by going to File > Open or you can double-click the file.
  5. This will place the cursor at that location.
  6. Alternatively, right-click or control-click where you want the chart and select Paste .
    • For more paste options, click the Home tab and click the arrow underneath the Paste icon. You can select: Keep Source Formatting, Use Destination Styles, Link & Keep Source Formatting, Link & Use Destination Styles, Picture, or Keep Text Only.
  7. If you change the data in Excel, you'll just need to refresh the chart in Word to see the new changes. Do the following:
    • Select the chart.
    • Click the Chart Design or Chart Tools Design tab.
    • Click Data .
    • Click Refresh Data .
  8. If you want to edit the data or change its layout elements, styles, and filters, do the following:
    • Select the chart.
    • Click the Chart Design or Chart Tools Design tab.
    • Click Data .
    • Click Edit Data .
    • Select a modification option.
    9. Advertisement
Method 3
Method 3 of 3:

Embedding a Blank Excel Table

PDF download Download Article
  1. If you don't want to link or copy/paste Excel data, you can embed a blank Excel table that can be filled and updated at any time. The data within Microsoft Word will be updated in the created Excel file.
  2. This will place the cursor at that location.
  3. It's in the editing ribbon above your document.
  4. This is in the Tables section. A drop-down menu will open.
  5. This is towards the bottom of the menu.
    • A new table will be added to your document.
  6. The table works the same as any other Excel document. You can add rows , columns, and more.
    • To resize the table, click and drag a corner of the table.
    • When you're finished editing your table, click anywhere outside the table to close the Excel view.
    • To return to editing mode, double-click the table.
    7. Advertisement

Community Q&A

Search
Add New Question
  • Question
    How do I dynamically embed an XLSX table in a DOCX file?
    wikiHow Staff Editor
    Staff Answer
    This answer was written by one of our trained team of researchers who validated it for accuracy and comprehensiveness.
    wikiHow Staff Editor
    Staff Answer
    You can copy your chart in Excel then paste it in Word. To update it in Word, select your chart, then go to "Chart Design" or "Chart Tools Design" and click Data > Refresh.
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 6 Helpful 2
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
      Advertisement

      Tips

      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Name
      Please provide your name and last initial
      Submit
      Thanks for submitting a tip for review!

      You Might Also Like

      How to
      Unhide All Rows and Columns in Microsoft Excel
      How to
      Merge Cells in Microsoft Excel: A Quick Guide
      How to
      Unprotect an Excel Sheet
      How to
      Use If‐Else in Microsoft Excel: Step-by-Step Tutorial
      The Best Ways to Make & Format Lists in Excel
      How to
      Create a Mortgage Calculator With Microsoft Excel
      How to
      Make a Spreadsheet in Excel
      How to
      Create a Chart in Microsoft Excel: Step-by-Step Guide
      How to
      Show Hidden Columns in Microsoft Excel & Unhide Column A
      How to
      Fix Ethernet Doesn't Have a Valid IP Configuration on Windows
      How to
      Insert Pictures in Excel That Automatically Size to Fit Cells
      How to
      Change a Comma to Dot in Excel
      How to
      Use Macros in Excel
      How to
      Create an Inventory List in Microsoft Excel: Step-by-Step Guide
      Advertisement

      References

      1. ↑ https://support.microsoft.com/en-us/office/video-embed-and-link-to-files-c32bd7c7-55e2-430e-99f0-18482a11e388
      2. ↑ https://support.microsoft.com/en-us/office/video-embed-and-link-to-files-c32bd7c7-55e2-430e-99f0-18482a11e388
      3. ↑ https://support.microsoft.com/en-us/office/video-embed-and-link-to-files-c32bd7c7-55e2-430e-99f0-18482a11e388
      4. ↑ https://support.microsoft.com/en-us/office/video-embed-and-link-to-files-c32bd7c7-55e2-430e-99f0-18482a11e388
      5. ↑ https://support.microsoft.com/en-us/office/video-embed-and-link-to-files-c32bd7c7-55e2-430e-99f0-18482a11e388

      About This Article

      Article Summary X

      1. Open your Word document.
      2. Click the Insert tab.
      3. Click Object and Object .
      4. Click the Create from File tab.
      5. Click Browse .
      6. Double-click to select your Excel file.
      7. Click to check the box next to "Link to file" and click OK .

      Did this summary help you?
      Thanks to all authors for creating a page that has been read 141,563 times.

      Is this article up to date?

      Advertisement