How to extract word to excel

Written by cameron easey
  • Share
  • Tweet
  • Share
  • Email

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


    Export from Word

  1. 1

    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.

  2. 2

    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.

  3. 3

    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.

    Import into Excel

  1. 1

    Double-click the icon for Excel to open the program. Click the "File" drop-down menu and select "New" to create a new document.

  2. 2

    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.

  3. 3

    Select the "Delimited" option that is under Original Data Type. View the Preview window below to see how the text is separated.

  4. 4

    Click the "Finish" button to import the text 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.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.