Browse » Home
Thursday, December 12, 2013
How to Convert Word to Excel 2007
1. Launch Microsoft Word and open the document that you want to convert to Excel. Click once on the Microsoft Office button and select the 'Open' option. Locate the folder in which the document is saved in the 'Look in' section of the 'Navigation Pane.' Double click on the file name to open it. If you do not have either program, a free trial may be downloaded from the Microsoft site.
2. Save the Word document as a text (TXT) file. Click once on the Microsoft Office button and select the 'Save As' option. Select a folder in which to save the text file using the 'Save in' menu. Use the 'Save as type' menu to select the 'Text (TXT)' option. Type a name for the text file in the 'File name' field and click once on the 'Save' button.
3. Launch Microsoft Excel 2007 and import the text file. Click once on the 'Data' tab and locate the 'Get External Data' section. Click once on the 'From Text' option. Use the 'Look in' menu to locate the folder in which the text file is saved. Double click on the file name to open it.
4. Use the 'Text Import Wizard' to convert the information from the Word document to Excel. Select the 'Delimited text files (.txt)' option. Click once on the 'Next' button. Depending on the type of data that was in the Word document, select the appropriate separator, for example commas or tabs, to separate the text into Excel fields. Click once on the 'Finish' button to complete the process of converting the Word document to Excel 2007. Remember to save the Excel 2007 file by clicking once on the Microsoft Office button and once on the 'Save As' option.