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.

 

 

Insert a Word Document as an Object into Excel

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

 

 

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

 

 

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

 

 

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.

 

 

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).

 

 

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.

 

 

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.