Excel: Import Excel Data Into a Word Table

This help page will show you how to import data from Excel into a Microsoft Word table.

To Import Data: 

  1. Open a new or existing document in Microsoft Word.
  2. Click the "Insert" tab > Locate the "Tables" group. 
  3. Select the "Table" icon > Choose the "Insert Table..." option.
  4. Set the "Number of columns," "Number of rows," and "AutoFit behavior" to your desired specifications > Click [OK].
  5. Open the Excel file and use your mouse to select the data you wish to import. 
  6. Right-click on the range of cells you have highlighted and select "Copy."
  7. Switch back to Word and highlight the table cells where you want to import the Excel data.
  8. Right-click on the Word table and click the option you want under "Paste Options."

Note: If you select the table in Word, the "Table Tools" tab will appear at the top of the page. Use this tab to format the "Design" and "Layout" of the table to meet your preferences. 

Was this helpful?
0 reviews

Details

Article ID: 47887
Created
Tue 2/6/18 2:38 PM
Modified
Tue 2/21/23 3:52 PM