How to Convert Word to Excel 2007
Microsoft Word is the word processing program associated with the Office line of productivity applications, while Excel is the spreadsheet leg of the suite. Word focuses on the layout and editing of text, while Excel is concerned with numbers, data and calculations. Despite these differences, there may be data or information in a Word document that could be used in an Excel spreadsheet. You can convert Word to Excel 2007 by following a few steps.
Things You'll Need
- Microsoft Word
- Microsoft Excel 2007
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.
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.
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.
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.