How to Import a Word Doc Into an Excel Spreadsheet

By Contributor

Updated May 09, 2020

Excel is a spreadsheet program developed by Microsoft. You can use it to organize and analyze data. One of Excel's features allows you to insert objects into a spreadsheet. This is useful if you want to display data or information in different ways, such as inserting a graph or a large block of text. You can even import an entire Word document into Excel. It is easy to do this and saves you time as you put together your project.

Editing and Saving Your Word Document

Open up the Word document you want to import into Excel.

Click the "Advanced" tab on the left-hand side. Under "Preserve Fidelity When Sharing This Document", check the box next to "Save Data as Delimited Text File." This feature will allow Excel to read the file you are going to import. Click "OK."

Selecting

Click the "Advanced" tab on the left. Under "Preserve Fidelity When Sharing This Document," check the box next to "Save Data as Delimited Text File." This feature will allow Excel to read the file you are going to import. Click "OK."

Saving Word document as delimited text file.

Click "File" and under "Save as Type," select "Plain Text." This will save the file as a .txt file. A file conversion window will then appear. Click "OK."

Saving Word document as .txt file.
Saving Word document as .txt file.

Importing Into Excel

Open Microsoft Excel. Click the "Data" tab. Hover your cursor over "From Text/CSV." You can also hover your cursor over "Get Data" and then select "From Text/CSV" from the drop-down list of options for the same end results.

Importing Word document into Excel.
Selecting from Text/CSV to import Word doc into Excel.

Select the Word document you just saved as a .txt file. Click "Open." The Text Import Wizard will appear.

Selecting Word .txt file to import into Excel.

Select "Load" at the bottom.

Loading imported .txt file from Word into Excel.

The Word document data will now appear in your Excel spreadsheet in the first column. Click on the newly created object to move it to the desired position in the spreadsheet.

Imported Word document into Excel.

Tips

You can edit the Word document you imported into Excel by double-clicking anywhere on the document. However, it might be easier to just copy and paste from Word into Excel.

×