See all How-To Articles

How to Import a Word Document into Excel or Google Sheets

This tutorial demonstrates how to import a Word document into Excel or Google Sheets.

 

insertword intro

 

Insert a Word Document as an Object into Excel

1. With the required Excel document open, in the Ribbon, select Insert > Text > Object.

 

insertword ribbon

 

2. In the Object dialog box, select Create from File and then click Browse.

 

insertword insertobject

 

3. In the Browse dialog box, highlight the file to that needs to be inserted into Excel and then click Insert.

 

insertword selectfile

 

4. Click OK to insert the file into the active worksheet. If you select the object, the formula bar will show a custom formula indicating that the document is embedded into the Excel file.

=EMBED("Document","")

This means that if you right-click on the object, you can either edit or open the object to amend it.

 

insertword rightclick

 

Selecting Edit in the shortcut menu will enable us to edit the object within Excel while selecting Open will open the object in a Word document.

Copy and Paste From a Word Document into Excel

1. Open the required Word document and select the portion of the document that needs to be inserted into Excel.

2. In the Ribbon, select Home > Clipboard > Copy (or press CTRL + C).

 

insertword selectword

 

3. Switch to an open Excel document and then in the Ribbon, select Home > Clipboard > Paste (or press CTRL + V) to paste the selection into Excel.

 

insertword pasteexcel

 

The contents will be pasted in as text enabling us to directly edit the contents in Excel if necessary.

How to Import a Word Document into Google Sheets

1. Open the required Word document and select the portion of the document that needs to be inserted into Excel.

2. In the Ribbon, select Home > Clipboard > Copy (or press CTRL + C).

3. Open the Google sheet required to import the Word document into.

4. Position the cursor where the document is to be pasted and then press CTRL + V to paste the information into the Google sheet.

 

insertword GS paste