Excel Guides

How to Import Word Documents as Objects in Excel

There are a few different ways that you can import Word documents into Excel as objects. One way is to use the Insert Object tool. To do this, open the Word document that you want to insert into Excel and select the entire document by pressing Ctrl+A. Then, open the Excel workbook into which you want to insert the document and click on the cell where you want to insert it. On the Insert tab, in the Text group, click Object. In the Insert Object dialog box, select Create from File, and then click Browse to locate the file that you want to insert. Select Link to File and click OK.

Another way to import a Word document into Excel is to use the Copy and Paste method. To do this, open the Word document that you want to insert into Excel and select the entire document by pressing Ctrl+A. Then, open the Excel workbook into which you want to insert the document and click on the cell where you want to insert it. On the Home tab, in the Clipboard group, click Copy. Next, go back to your Excel workbook and press Ctrl+V.

You can also use Microsoft Query to import data from a Word document into an Excel spreadsheet. To do this, open Microsoft Query by going to Start > All Programs > Accessories > Office Tools > Microsoft Query. In Microsoft Query, choose Data Source from the File menu and then select ODBC DSNs from the list of data sources. Select your DSN name from the list of DSNs and click OK.

In Microsoft Query, select Get Data from the File menu. In the Get Data dialog box, select Files of type: All Files (*.*). Locate your Word document and click Open.

Your data should now appear in Microsoft Query. To return to Excel, go to File > Return Data To Microsoft Office Excel.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.