How to Insert Excel Tables into Microsoft Word (PC & Mac)

This tutorial shows how to insert Excel tables into Microsoft Word documents. We will also look at how to update linked Excel tables in Word.

Table of Contents

• How to Insert Excel Tables into Microsoft Word
• How to Update Linked Excel Tables in Microsoft Word

Watch all the steps shown here in real time!

Explore more than 250 writing-related software tutorials on my YouTube channel.

The images below are from Word for Microsoft 365. These steps also apply to Word for Microsoft 365 for Mac (a.k.a., Word for Mac), Word 2021, Word 2019, Word 2016, and Word 2013 (PC only).

How to Insert Excel Tables into Microsoft Word

1. Select the table or part of the table in Excel.
2. Select the Home tab.
3. Select the Copy button.

Alternatively, you can use the keyboard shortcut Ctrl + C (PC) or Command + C (Mac) to copy the table.

1. Place your cursor in the Word document where you want to insert the table.
2. Select the Home tab.
3. Select the Paste menu arrow.
4. Select a pasting option from the drop-down menu:

• • Keep Source Formatting inserts the table with Excel formatting.
  • Use Destination Styles inserts the table with Word formatting.
  • Link & Keep Source Formatting inserts the table with Excel formatting. The new table is linked to the original file. If you change the data in Excel, the data will update in the Word document.
  • Link & Keep Destination Styles inserts the table with Word formatting. The new table is linked to the original file. If you change the data in Excel, the data will update in the Word document.
  • Picture inserts the table as an image.
  • Keep Text Only inserts the table data as text.

The Excel table should be inserted into your Word document.

If you chose any of the options above other than Picture or Keep Text Only, you can now select the table, select the Table Design tab, and adjust the formatting as you would a table created in Word.

How to Update Linked Excel Tables in Microsoft Word

If you used the Link & Keep Source Formatting or Link & Keep Destination Styles options discussed above, the Word table should update to match edited data in the Excel file.

Normally, the update will happen automatically when the files are saved. However, you can manually update linked tables whenever necessary.

1. Right-click (PC) or Control-click (Mac) inside the table.
2. Select Update Link from the shortcut menu.