How to Export Data from Word to Excel

Word Document
1. Launch Microsoft Word and open the desired data document by selecting 'Open' under 'File' in the top menu bar (or under the Office 2007 ribbon), selecting the file and clicking the 'Open' button.
2. Check that each unit of data in the Word document is separated by a tab or a comma and that each record is separated by a line break.
3. Convert any tables to text by selecting 'Select' under 'Table' in the top menu bar and choosing 'Table.' Select the function under 'Tools' to 'Convert Table to Text' and choose the option to separate data by either a 'Tab' or a 'Comma' before clicking the 'OK' button in the dialog box.
4. Select 'Save As' under 'File' in the top menu bar and type the name of the document.
5. Select 'Rich Text Format (.rtf)' or 'Text File (.txt)' from the drop-down menu next to 'Format' and click the 'Save' button.
Data from Word Form
6. Launch Microsoft Word and open the form by selecting 'Open' under 'File' in the top menu bar, choosing the desired file and clicking the 'Open' button.
7. Select 'Options' under 'Tools' in the top menu bar and click the 'Save' tab.
8. Check the option, 'Save data only for forms' to check the box and click the 'OK' button.
9. Select 'Save a Copy' under 'File' in the top menu bar.
10. Type the name of the document and select 'Text Format (.txt)' as the file type before clicking the 'Save' button. A File Conversion Wizard will open to accurately map the data.
11. Review the data displayed in the File Conversion Wizard and check that each unit of data is identified in quotes and separated with a comma. Confirm that blank data fields are registered as a blank space between two quotation marks before clicking the 'OK' button.
Import Data into Excel
12. Launch Microsoft Excel and open a blank workbook.
13. Click the first cell in the spreadsheet and select 'Import External Data' under 'Data' in the top menu bar.
14. Select the option to 'Import Data' and launch a Text Import Wizard.
15. Review each step in the Text Import Wizard to make sure that the fields are mapped correctly by selecting the 'Delimited' options and previewing the distribution of data on the spreadsheet in the preview pane at the bottom of the dialog box. Click the 'Next' button to navigate through the Text Import Wizard and click the 'Finish' button to close the wizard and transfer the data.
16. Save the converted data in Excel format by selecting 'Save' under 'File' in the top menu bar, typing the file name, selecting 'Excel Workbook' as the file format and clicking the 'Save' button.