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.
Things You'll Need
- Microsoft Word
- Microsoft Excel
Open a Word document you want to import.
Click the "Microsoft Office Button." Click "Word Options."
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."
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."
Open Microsoft Excel.
Click the "Data" tab. In the "Get External Data," click "From Text."
Select the file you just saved in step 4. Click "Open." The Text Import Wizard will appear.
Select "Delimited" under "Original Data Type." Click "Next."
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."
Click in the first cell (A1) in Excel. Click "OK" to import the data.
Tips & Warnings
- Select the next row in the spreadsheet to import data from another Word document. This is useful to compare data from various lists or forms.