The simplest way to embed a spreadsheet

You can place an Excel file into a Word document in three ways, depending on whether you want the spreadsheet to stay connected to the original file or exist only inside Word. The fastest method is copy and paste — select the cells you need in Excel, paste them into Word, and you're done. If you need the data to update automatically when the Excel file changes, use the Link option. If you want a snapshot that won't change, use Embed.

Most people use copy and paste because it's when ready and requires no extra steps. The other two methods take a few more clicks but give you more control over what happens if the original Excel file is edited later.

Key Takeaways

  • Copy and paste is the fastest method and works for most situations where you need a spreadsheet to appear in a Word document.
  • Linking keeps the data live — changes to the Excel file automatically show up in Word, but the original file must stay in the same location.
  • Embedding creates a static copy inside Word that won't change if the Excel file is edited, and the original file can be moved or deleted.
  • On Windows, use the Insert menu and Object option to link or embed; on Mac, the process is similar but located under the Insert tab.

Copy and paste for a quick table in Word

Open both Excel and Word on your screen. In Excel, click on the cell where your data starts, then drag to select all the cells you want to copy. You can also click the first cell, hold Shift, and click the last cell to select a range.

Right-click the selected cells and choose Copy, or press Ctrl+C on Windows or Command+C on Mac. Switch to your Word document, click where you want the table to appear, right-click, and choose Paste. The spreadsheet data will appear as a table in Word.

This method creates a table that you can edit directly in Word, but it won't stay connected to the original Excel file. If someone changes the numbers in Excel later, the Word document won't update automatically.

Link an Excel file so it updates automatically

Linking is useful when you're sharing a document with others and want everyone to see the most current numbers from Excel. Open Word and click where you want the spreadsheet to appear. On Windows, go to the Insert menu, then click Object (you may need to click the dropdown arrow next to it). On Mac, click Insert, then Object.

A dialog box will open. Click the Create from File tab. Click Browse, find your Excel file on your computer, and select it. Before you click OK, check the box that says Link to file. This is the crucial step — without it, you're embedding instead of linking. Click OK, and the spreadsheet will appear in your Word document.

Now, whenever someone opens the Excel file and makes changes, those changes will appear in the Word document the next time it's opened. The Excel file must stay in the same folder with the same name, or Word won't be able to find it and the link will break.

Embed an Excel file for a permanent snapshot

Embedding is the right choice when you want the spreadsheet to be part of the Word document permanently, without any connection to the original file. The process is almost identical to linking, except you skip the Link to file checkbox.

Open Word and click where you want the spreadsheet. Go to Insert, then Object, then Create from File. Click Browse, select your Excel file, and click OK. This time, leave the Link to file box unchecked. The spreadsheet will be embedded inside the Word document as a static image or table.

Once embedded, the original Excel file can be moved, renamed, or deleted without affecting the Word document. The downside is that if the data in Excel changes, the Word document won't reflect those changes — you'd have to re-embed the file to update it.

Paste special for more control over formatting

If you want to paste data from Excel but control exactly how it looks in Word, use Paste Special instead of regular paste. Copy your cells from Excel as usual. In Word, right-click where you want the data and choose Paste Special.

A menu will appear with several options. Paste as Formatted Table keeps the Excel formatting and makes it editable in Word. Paste as Unformatted Text removes all colors and borders and gives you plain text. Paste as Picture creates an image that you can't edit but that looks exactly like the Excel spreadsheet. Choose whichever matches what you need, then click OK.

Paste Special is slower than regular paste, but it's worth the extra step if the default paste doesn't look right or if you need the data in a specific format.

What to do if the link breaks

If you linked an Excel file and later moved it to a different folder or renamed it, Word will show an error message or a blank space where the spreadsheet should be. The link has broken because Word can't find the file anymore.

To fix it, right-click the broken link in Word and choose Edit Link (on Windows) or Update Link (on Mac). Click Change Source, browse to the new location of your Excel file, and click OK. The spreadsheet will reappear. To prevent this problem, keep the Excel file in a stable location and tell anyone you share the Word document with not to move the Excel file.

Frequently Asked Questions

Can I edit the spreadsheet after I paste it into Word?

Yes, if you use copy and paste or Paste Special as Formatted Table, the data appears as a table in Word that you can edit directly. However, those edits won't affect the original Excel file. If you embedded the file, you can double-click it to open Excel and edit it, but those changes won't show in Word unless you re-embed.

What's the difference between embedding and linking?

Linking keeps the spreadsheet connected to the original Excel file, so changes in Excel automatically appear in Word. Embedding creates a copy inside Word that's completely separate — the original file can be deleted and the Word document won't be affected. Use linking for shared documents that need current data; use embedding for final reports or documents you're sending to others.

Why does my linked spreadsheet show a blank space instead of data?

The link has broken, usually because the Excel file was moved or renamed. Right-click the blank space, choose Edit Link or Update Link, and browse to the new location of your Excel file. If you can't find the file, you'll need to re-embed or re-paste the data.

Can I insert an entire Excel workbook with multiple sheets into Word?

You can embed or link an entire workbook, but Word will only display the first sheet by default. If you need specific sheets to appear, copy and paste only the data from those sheets instead. This gives you more control over what the reader sees.

Does the file size of my Word document increase when I embed an Excel file?

Yes, embedding adds the size of the Excel file to the Word document. If the spreadsheet is large, the Word file will be noticeably bigger. Linking doesn't increase the file size because Word only stores a reference to the external file, not a copy of the data.