How to Insert an Excel Spreadsheet into Word (4 Easy 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.


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

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.

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

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

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

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

  • Alternatively, right-click on the mouse to open the window.
  • Go to Paste Options.
  • 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: 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


Method 2 – Insert the Table as an Embedded Object

Steps: 

  • Copy the selected cells in the Excel spreadsheet that you want to insert by using Ctrl+C.
  • Go to the Word document and place the cursor in the location where you will insert the table.
  • Head to the Top Ribbon and select the following:  Home > Paste > Paste Special

Making The Excel Worksheet An Embedded Object To Insert Into Word

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

Making The Excel Worksheet An Embedded Object To Insert Into Word

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

Making The Excel Worksheet An Embedded Object To Insert Into Word

Read More: How to Export Data from Excel to Word


Method 3 – Insert as a Linked Object

Steps: 

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

Making The Excel Worksheet A Linked Object To Insert Into Word

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

Making The Excel Worksheet A Linked Object To Insert Into Word

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


Method 4 – Insert Using the Table Option

Steps: 

  • Open a Word document and select the location where you want to insert the table.
  • From the Top Ribbon, press the Insert option and go through these steps:

         Insert > Table > Excel spreadsheet

Insert Excel Spreadsheet Into a Word Document Using The Table Option

  • You will see a spreadsheet box appear. 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

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

Get FREE Advanced Excel Exercises with Solutions!
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