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

Get FREE Advanced Excel Exercises with Solutions!

After working in Excel spreadsheets, it is usual to make a report which is in a Word file. So, you may need to insert the Excel Spreadsheets into Word. Often people find it difficult to drag the Excel data, charts, tables, etc into a Word file. In this article, you will find 4 easy methods to insert an Excel Spreadsheet into Word.


How to Insert an Excel Spreadsheet into Word: 4 Methods

This dataset includes the data of bank account openings which includes 7 columns and 8 rows.  And this data will be inserted into a Word file.


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

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

Steps: 

  • First, open the Excel file and select the data that you want to insert into the document by dragging the mousing pressing. And press Ctrl+C on the keyboard. Then you will see a dashed rectangle surrounding the selected cells.

Use Ctrl+C and Ctrl+V to Copy and Paste an Excel Spreadsheet into Word

  • After that, without using Ctrl+C, You can press the right button on the mouse after selecting the cells. Now, there opens a window, and select the Copy option. Thus the selected cells will be copied.

Use Ctrl+C and Ctrl+V to Copy and Paste an Excel Spreadsheet into Word

  • Then, go to the Word file, place the cursor into the file, and press Ctrl+V on the keyboard. You will see the selected and copied cells from the Excel file have appeared in the same formatting.

  • In another way, you can right-click on the mouse and there opens a window. Under the Paste Options, you can select one to paste the selected cells here. Then, You should select the first one ‘Keep Source formatting’ to keep the formatting the same as the Excel file.

Use Ctrl+C and Ctrl+V to Copy and Paste an Excel Spreadsheet into Word

Notes: By this method, the Excel file cells are converted to a data table. And in the Word file, you can’t use any formula or do any calculations if needed. This method is useful if you want to make just a report which will 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 file. This method is the solution of it. Making an embedded object will allow using these things in a Word file just like in an Excel file.

Steps: 

  • First, Copy the selected cells in the Excel File that you want to insert by using Ctrl+C.
  • Then,  go to the Word file, 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

Making The Excel Worksheet An Embedded Object To Insert Into Word

  • Doing that, a dialog box named ‘Paste Special’ will appear. Now, you will see Paste option is already selected. And then select the ‘Microsoft Excel Worksheet Object’  from the dropdown menu.

Making The Excel Worksheet An Embedded Object To Insert Into Word

  • And then, press the OK button.

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

Making The Excel Worksheet An Embedded Object To Insert Into Word

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 file, 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

Making The Excel Worksheet A Linked Object To Insert Into Word

  • After that, select the ‘Paste link’ option. And select ‘Microsoft Excel Worksheet Object’ in the drop-down menu. And Press OK.

Making The Excel Worksheet A Linked Object To Insert Into Word

  • Then, 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: 

  • At first, open the Word And press on the location where you want to insert the table.
  • Then, from the top Ribbon, Press on the Insert option and go through these steps:

         Insert > Table > Excel spreadsheet

Insert Excel Spreadsheet Into a Word Document Using The Table Option

  • 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.


Conclusion

Inserting an Excel file into a Word file is a matter of regular use. But often we get troubled to do this. So, I have made this article for you to insert Excel files in Word by 4 easy methods. Here, the 1st method is very simple and easy but it gives less flexibility in changing data in the future and the 2nd and 3rd method gives you the option to change formulated data easily. I hope you found this article helpful. Please, drop comments, suggestions, or queries if you have any in the comment section below.


Related Articles

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

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Osman Goni Ridwan
Osman Goni Ridwan

OSMAN GONI RIDWAN is a marine engineer who loves exploring Excel and VBA programming. Programming, to him, is a time-saving tool for efficiently managing data, files, and internet tasks. He is proficient in Rhino3D, Maxsurf, C++, MS Office, AutoCAD, Excel, and VBA and goes beyond the basics. Armed with a B.Sc in Naval Architecture & Marine Engineering from BUET, OSMAN has transitioned into the role of a content developer. Specializing in creating technical content exclusively centered around Excel... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo