The fastest way to get Excel data into Word

You can insert an Excel file into Word in three ways: embed the entire spreadsheet so it stays editable inside Word, link to the file so changes in Excel show up automatically, or paste just the data you need. Which method you choose depends on whether you want the spreadsheet to update on its own, whether you need it to look polished, and how much of the Excel file you actually want in your document.

The simplest route for most people is copying the table from Excel and pasting it as a formatted table in Word. If you need the full spreadsheet to stay interactive, embedding works better. Linking is best when the Excel file changes regularly and you want Word to reflect those changes without manual updates.

Key Takeaways

  • Copy and paste from Excel creates a static table in Word that you can format like any other Word table, and takes 30 seconds.
  • Embedding the entire Excel file lets you edit the spreadsheet inside Word without opening Excel separately, but increases file size.
  • Linking to an Excel file means changes you make in Excel show up automatically in Word, but breaks if you move or rename the Excel file.
  • Pasting special gives you control over formatting — you can paste as a picture, as unformatted text, or as a linked object depending on what you need.

Copy and paste a table from Excel to Word

Open both Excel and Word on your screen. In Excel, click the cell in the top-left corner of the data you want to copy, then drag to the bottom-right corner to select the entire range. You can also click the first cell, hold Shift, and click the last cell. Right-click the selection and choose Copy, or press Ctrl+C.

Switch to Word and click where you want the table to appear. Right-click and choose Paste, or press Ctrl+V. Word will paste the data as a formatted table. A small icon appears next to the table — click it to see options like Keep Source Formatting (keeps Excel's colors and fonts), Use Destination Styles (matches Word's formatting), or Paste Special (gives you more control). Choose whichever matches how you want the table to look.

This method works best when you only need part of the Excel file and you don't expect the data to change. The table in Word is completely separate from the Excel file — changes to one don't affect the other.

Embed an entire Excel file inside Word

Embedding puts the whole Excel file into your Word document so you can open and edit it without leaving Word. Click in Word where you want the spreadsheet to go. Go to the Insert tab at the top, then click Object (you may need to click a dropdown arrow to find it). A dialog box opens.

Click the Create from File tab. Click Browse, find your Excel file, and click Open. You'll see the file path in the dialog. Check the box for Display as Icon if you want just an icon that opens the spreadsheet when clicked, or leave it unchecked to show a preview of the spreadsheet in the document. Click OK.

The spreadsheet now appears in your Word document. Double-click it to edit — Excel opens inside Word, and you can make changes without switching programs. When you're done editing, click outside the spreadsheet to return to Word. The embedded file adds to your Word document's file size, sometimes significantly if the Excel file is large.

Link to an Excel file so changes update automatically

Linking means Word displays data from your Excel file, and when you update the Excel file, Word shows the new data automatically. This works best when you have a spreadsheet that changes regularly and you want your Word document to always show the current numbers.

In Excel, select and copy the data you want to link to. Switch to Word and click where you want it. Go to Home or Edit (depending on your Word version), click the dropdown arrow next to Paste, and choose Paste Special. In the dialog that opens, select Paste Link and choose Microsoft Excel Worksheet Object. Click OK.

The data appears in Word. Now whenever you open the Excel file and make changes, those changes show up in Word the next time you open the Word document (Word will ask if you want to update links). If you move or rename the Excel file, the link breaks and Word can't find the data anymore. Keep both files in the same folder and don't rename them if you're using links.

Paste as a picture when formatting matters most

If you want the spreadsheet to look exactly as it does in Excel and you don't need it to be editable, paste it as a picture. This locks the formatting and prevents accidental changes, but you can't edit the data inside Word.

Copy the data from Excel. In Word, go to Home or Edit, click the dropdown next to Paste, and choose Paste Special. Select Picture and click OK. The spreadsheet appears as an image. You can resize it by dragging the corners, but you can't change the data without going back to Excel and copying it again.

Troubleshooting common problems

If the table looks wrong after pasting, the formatting didn't transfer correctly. Right-click the table and choose Table Design or Table Styles to reformat it. If you pasted a linked object and it's not updating, open the Excel file, make sure you save it, then go back to Word and right-click the linked data. Choose Update Link or Edit Link to refresh it.

If your Word file is too large after embedding, you've probably embedded a huge spreadsheet. Consider pasting just the data you need instead, or linking to the file rather than embedding it. If a linked object shows an error message, the Excel file has been moved or deleted. You'll need to re-link it by going to File > Info > Edit Links to Files (or similar, depending on your Word version) and updating the file path.

When copying from Excel to Word, merged cells sometimes cause problems. Unmerge them in Excel before copying if the table looks jumbled in Word. If you're pasting a very large spreadsheet and Word slows down, paste only the rows and columns you actually need instead of the entire sheet.

Choosing the right method for your situation

Use copy and paste when you need a simple table that won't change, you want it to look good in Word, and file size matters. Use embedding when you need to edit the spreadsheet sometimes but don't want to switch to Excel, and you don't mind a larger file. Use linking when the Excel data changes regularly and you want Word to always show the current version. Use paste as picture when the exact look of the spreadsheet is critical and you don't need to edit it.

If you're sharing the Word document with others, remember that linked files only work if everyone has access to the Excel file in the same location. Embedded files are safer for sharing because everything is in one document. Pasted tables are the most portable — they work anywhere without needing the original Excel file.

Frequently Asked Questions

Can I edit the data after pasting it into Word?

Yes, if you pasted it as a table. Click inside any cell and type to change the data. If you pasted it as a picture, you can't edit it in Word — you'd need to go back to Excel, change it there, and paste it again. Embedded spreadsheets can be edited by double-clicking them.

What happens to the link if I move the Excel file to a different folder?

The link breaks and Word can't find the data. You'll see an error message. You can fix it by going to File > Info > Edit Links to Files, selecting the broken link, and updating the file path to the new location. To avoid this, keep the Excel file and Word document in the same folder.

Why is my Word file so large after embedding an Excel spreadsheet?

Embedded files add their full size to the Word document. If your Excel file is 5 MB, your Word document will be at least 5 MB larger. If file size is a problem, paste only the data you need as a table instead, or link to the Excel file rather than embedding it.

Can I embed an Excel file and still edit it in Excel?

Yes. Double-click the embedded spreadsheet in Word to edit it, and the changes save to the embedded copy. But if you also have the original Excel file open, changes in one don't automatically show in the other — they're separate copies now. If you need them to stay in sync, use linking instead of embedding.

What's the difference between linking and embedding?

Linking keeps the data in the Excel file and displays it in Word — changes to Excel show up in Word automatically. Embedding copies the data into Word — it's no longer connected to the Excel file. Linking keeps file size down but requires the Excel file to stay accessible. Embedding makes the document self-contained but larger.