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
- 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.
- 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.
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.
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
- A dialogue box named “Paste Special” will appear with the Paste option already selected.
- Select “Microsoft Excel Worksheet Object” from the dropdown menu.
- 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.
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
- 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.
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
- You will see a spreadsheet box appear. Copy and Paste cells here to bring data from external Excel files.
Download Practice Workbook
Download the following practice workbook for free.
Insert Spreadsheet into Word.xlsx
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
