How to Import a Word Document Into Excel?

Importing a Microsoft Word document into Microsoft Excel is often useful if you want to create a spreadsheet out of a list or form you’ve already made, such as an address book. Fortunately, since Word and Excel are both Microsoft Office programs, they work together well. You just need to make sure the Word document is saved properly, and then use Excel’s Text Import Wizard to complete the conversion.

...
Import a Word document into Microsoft Excel.

Step

Open a Word document you want to import.

Step

Click the “Microsoft Office Button.” Click “Word Options.”

Step

Click the “Advanced” tab. Under “Preserve Fidelity when Sharing this Document, click “Save Data as Delimited Text File.” This feature will allow Excel to read the file you are going to import. Click “OK.”

Step

Click the “Microsoft Office Button.” Choose “Save as.” Under “Save as Type.” Select “Plain Text.” This will save the file as a .txt file. A file conversion window will appear. Click “OK.”

Step

Open Microsoft Excel.

Step

Click the “Data” tab. In the “Get External Data,” click “From Text.”

Step

Select the file you just saved in step 4. Click “Open.” The Text Import Wizard will appear.

Step

Select “Delimited” under “Original Data Type.” Click “Next.”

Step

Select the delimiter you want to use. For instance, check “Comma” instead of “Tab” to see how it affects the conversion. Click “Next.” Click “Finish.”

Step

Click in the first cell (A1) in Excel. Click “OK” to import the data.