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.
Step 1
Open a Word document you want to import.
Video of the Day
Step 2
Click the "Microsoft Office Button." Click "Word Options."
Step 3
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 4
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 5
Open Microsoft Excel.
Step 6
Click the "Data" tab. In the "Get External Data," click "From Text."
Step 7
Select the file you just saved in step 4. Click "Open." The Text Import Wizard will appear.
Step 8
Select "Delimited" under "Original Data Type." Click "Next."
Step 9
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 10
Click in the first cell (A1) in Excel. Click "OK" to import the data.
Video of the Day