Saving Word Form Data for Use in Excel
By James Marshall, About.com
For some reason, Microsoft doesn’t make it easy for users to extract their form data for use in Excel. While they should give you the option of simply saving the form data as an Excel spreadsheet, they make users go through a few extra steps to transfer the data. Although this is a bit of a hassle, it is easy enough to do.
With the form document open, select Options from the Tools menu:
Prev
- Select Options
- Select Save data only for forms
- Open the Save As Dialog Box
- Name Your File
- Save Your File
Working With Word and Excel
Opening Mail Merge Data Files With ExcelInserting Excel Data into a Word DocumentExcel and mail merge
Learn About Charts and Tables in Word
Inserting a Chart in a Word 2008 DocumentWorking With Tables in Microsoft WordCreating a Basic Chart in Word 2007
Explore Word Processing
Must Reads
About.com Special Features
Build Your Own Website
Step-by-step advice on how to do everything from choosing a Web host to promoting your content. More >
Connect Your Home Computers
Easy ways to connect two computers for networking purposes. More >
©2009 About.com, a part of The New York Times Company.
All rights reserved.