3 Ways to Insert an Excel Spreadsheet into a Word Document

Maria is a Content Writer with a keen interest in Technology and Productivity Tools. Her articles can be found on sites such as Onlinetivity and Delesign. Outside of work, you can find her mini-blogging about her life on social media.

Afam has been a content writer with Guiding Tech Media since August 2023. However, his experience in tech writing dates back to 2018, when he worked as a freelance writer for Make Tech Easier. Over the years, he has grown a reputation for publishing quality guides, reviews, tips, and explainer articles. His work is featured on top websites, including Technical Ustad, Windows Report, and Next of Windows. He has training as a Microsoft Certified Professional and has covered more Microsoft-related guides on these platforms.

Method 1: Using the Insert Table Option

The Insert tab on the Word Ribbon has different options, including an Insert Table button, which can be used to insert an Excel Spreadsheet into Word. This option would launch a blank Excel spreadsheet in which you can make edits. Here’s how to do so:

Step 1:LaunchMicrosoft Word.

Step 2:Open your desireddocument.

Step 3:On the Word canvas, place your cursor where you want to insert the spreadsheet.

Step 4:On the Word Ribbon, click theInserttab.

Step 5:Within the Tables group, clickTable.

Step 6:ClickExcel spreadsheetto insert a table in Word and launch ablank Excel workbook.

Step 7:In the blank workbook, enter thedatayou want to see in your Word document.

Step 8:ClickSaveon the Excel workbook to see your changes in the Word table.

Note that any edits to the spreadsheet will be shown in table form in your Word document.

Method 2: Using the Insert Object Option

If you do not want to insert the data in the Excel spreadsheet into your Word document, an alternative is to embed the spreadsheet as an object into your document. Embedding the Excel spreadsheet into your Word document is like including a shortcut for individuals to access the spreadsheet. Here’s how to do so:

Step 1:LaunchMicrosoft Word.

Step 2:Open your desireddocument.

Step 3:On the Word canvas, place yourcursorin the location where you want to embed the spreadsheet.

Step 4:On the Word Ribbon, click theInserttab.

Step 5:Within the Text group, click theObjectdropdown.

Step 6:ClickObject. This will launch the Object dialog box.

Step 7:Click theCreate Newtab to create a new spreadsheet or theCreate from Filetab to open an existing spreadsheet.

Step 8:If you select theCreate Newtab, scroll through theObject typelist and selectMicrosoft Excel Worksheet.

Note:If you select theCreate from Filetab, clickBrowseand scroll through your File Library to select the Excel worksheet you want to embed.

Step 9:Tick the box forDisplay as icon. This will ensure the Excel data isn’t presented as a table and only an icon of the spreadsheet is shown in your Word document.

Step 10:Lastly, clickOK.

Method 3: Using the Insert & Link Option

You can copy and paste the data from an Excel spreadsheet into Word. If you are worried about manually updating the data in Word every time you make changes to the Excel spreadsheet, you can work around this, too. Rather than using the simple paste option when transferring the data, you can use the Link & Use Destination Styles or Link & Keep Source Formatting option.

Step 1:Open theWord documentinto which you want to insert the spreadsheet.

Step 2:Open theExcel worksheetwith the data you want to copy to Word.

Step 3:Select and copy thecellsin the Excel worksheet you want to insert into Word.

Step 4:On the Word canvas, place thecursorwhere you want to insert the data.

Step 5:Right-click the Word canvas and selectLink & Use Destination StylesorLink & Keep Source Formattingoptions.

Step 6:When you change the Excel spreadsheet data, right-click on thetransferred tablein Word and selectUpdate Link. This will keep the data up to date.

Was this helpful?

Last updated on 29 August, 2024

Leave a ReplyCancel reply

Your email address will not be published.Required fields are marked*

Name*

Email*

Comment*

Δ

The article above may contain affiliate links which help support Guiding Tech. The content remains unbiased and authentic and will never affect our editorial integrity.

More in Internet and Social

4 Ways to Send Photos as Documents on WhatsApp Using iPhone

How to Delete a Notebook in Microsoft OneNote

JOIN THE NEWSLETTER

Get Guiding Tech articles delivered to your inbox.

© 2024 Guiding Tech Media. All Rights Reserved.