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.

i S.H.

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

i S.H.

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

i S.H.

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

i S.H.
i S.H.

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.

i S.H.
i S.H.

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

i S.H.

Select "Load" at the bottom.

i S.H.

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.

i S.H.

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.

×