Extracting information that is in a Word Document to Excel is done by exporting form data from one program to another. This will allow you to add data without having to retype identical information into two different programs. To do this, you will need to first export the data from the Word document and then import it into the Excel document. Transferring data using this method will ensure that the transfer of data is accurate from one program to another.
- Skill level:
- Moderately Easy
Other People Are Reading
Open the document that has the data that you want to extract to Excel. Select the "Tools" drop-down menu and click "Options" from the menu.
Go to the "Save" tab and put a check in the box for "Save data only for forms." Click the "OK" button to close the Options dialogue box.
Click the "File" drop-down menu and select the "Save" option. Select "Text" for the file format. You will see a File Conversion dialogue box appear on the screen. Click the "OK" button to save the file.
Export from Word
Double-click the icon for Excel to open the program. Click the "File" drop-down menu and select "New" to create a new document.
Select the "Data" drop-down menu and click the option for "Import External Data." Click the "Import Data" option. Locate the text file on your system that you saved earlier.
Select the "Delimited" option that is under Original Data Type. View the Preview window below to see how the text is separated.
Click the "Finish" button to import the text into Excel.
Import into Excel
Tips and warnings
- If the Data option is greyed out after importing the first row, just skip row 2 and go to row 3.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for