How to Insert an Excel Spreadsheet into Word (4 Easy Methods)

How to Insert an Excel Spreadsheet into Word: 4 Methods

This dataset includes data on bank account openings, which includes 7 columns and 8 rows.  This data will be inserted into a Word file.

1. Insert an Excel Worksheet into Word by Direct Copy and Paste

The simplest and easiest method to insert Excel spreadsheet data into Word is using the Copy and Paste feature of Windows.

Steps: 

• Open the Excel file and select the data you want to insert into the document (drag the mouse while pressing the left button. Press Ctrl+C on the keyboard. You should see a dashed rectangle surrounding the selected cells.

• Press the right button on the mouse after selecting the cells. When the window opens, select the Copy option.

• Then, go to an open Word document, place the cursor into the file, and press Ctrl+V on the keyboard. The selected and copied cells from the Excel file will appear with the same formatting.

• In another option, right-click on the mouse to open the window. Under the Paste Options, you can select one to paste the selected cells. Here, you should select the first one, “Keep Source formatting” to keep the formatting the same as the Excel file.

Notes: This method converts the Excel cells to a data table. In the Word document, you can’t use any formula or do any calculations if needed. This method is useful if you want to add the Excel data to be viewed only.

Read More: How to Copy from Excel to Word Without Losing Formatting

2. Insert as an Embedded Object

With the previous method, you can’t use any functions, formulas, or calculations in the Word document. This method uses an embedded object to allow the spreadsheet to be used in a Word document just like in an Excel spreadsheet.

Steps: 

• Copy the selected cells in the Excel spreadsheet that you want to insert by using Ctrl+C.
• Then,  go to the Word document, and place the cursor in the location where you will insert the table. Now, in the Top Ribbon, go through these steps:  Home > Paste > Paste Special

• A dialogue box named “Paste Special” will appear. Now, you will see Paste option is already selected. Select the “Microsoft Excel Worksheet Object”  from the dropdown menu.

• Then, press the OK button.

• The copied cells have appeared in a box as an object. You can change the dimensions to fit the data. To edit the data, Double-click on the object. Then. inside the object, an entire Excel file will open; you can edit, save, and do anything, but the “spreadsheet” is inside the Word document. The main Excel file will remain unchanged.

Read More: How to Export Data from Excel to Word

3. Insert as a Linked Object

Using an Excel file inside a Word file may become troublesome. You can use the linked object option to link Excel cells to Word for automatic updates.

Steps: 

• First, copy the selected cells in the Excel file that you want to insert by using Ctrl+C.
• Now,  go to the Word document and place the cursor in the location where you will insert the table. From the Top Ribbon, go through these steps:  Home > Paste > Paste Special

• Next, select the “Paste link” option and select “Microsoft Excel Worksheet Object” in the drop-down menu. Press OK.

• You will see the copied cells appear as an object. Double-clicking on the object will open the Excel file from where the cells are copied. When you edit the main Excel file, it will change the Word file automatically.

4. Insert Using the Table Option

Another easy method for inserting Excel data into a Word file is by inserting a spreadsheet into a Word document.

Steps: 

• Open the Word document and select the location where you want to insert the table.
• Then, from the top ribbon, press the Insert option and go through these steps:

         Insert > Table > Excel spreadsheet

• There, you will see a spreadsheet box appear. You can simply Copy and Paste cells here to bring data from external Excel files.

Read More: How to Transfer Data from Excel to Word Automatically

Download Practice Workbook

Download the following practice workbook for free.

Related Articles

• How to Extract Data from Excel to Word
• How to Copy and Paste from Excel to Word Without Cells
• How to Copy a Chart from Excel to Word
• How to Copy Only Text from Excel to Word

<< Go Back to Export Excel to Word | Export Data from Excel | Learn Excel