Understand Word Forms
A Word form contains fill-in blanks that make it easy for people to fill in important information. Usually, these forms are distributed so that many people can fill them out and return them. Collecting all of the information from those forms and transferring them to an Excel spreadsheet is a tedious manual process. Thankfully, it’s very easy to export Word form data to Excel using comma-delimited files.
Use Options to Select Comma-Delimited Format
It only takes a few adjustments in your Word form document to save the form data as a comma-delimited (CSV) file. This file format separates each form record with commas. Use CSV files to import data into Excel. Microsoft Word is smart enough to only save the data from the form into the CSV file. The extra text in the document is not added to the CSV file. With the form document open and filled in with data, select File > Options. At this point, there are two ways to export the data to Excel. Either save the document or export the data.
Use Save As to Export to CSV
To save the document to CSV format: Word extracts the form data that was typed into the form as a .csv file, which can be opened with Excel. Word inserts commas between the fields. Excel uses the commas to separate the data into specific cells.
Use Export to Save to CSV
To export the data to a CSV file:
Import Form Data Into Excel
After the Word form data is exported to CSV format, the data is ready to import into Microsoft Excel. If you open the file using Excel, you won’t see the file in the folder where you saved it because Excel defaults to showing you only Excel files. Open the CSV file following these steps: The data from your Word form appears in your Excel sheet.
Import Form Data Into Existing Spreadsheet With Excel 2019 and 2016
If you want to bring data from new Microsoft forms into the same spreadsheet, follow these steps: Once the form data is imported, add the new Word form data to your primary worksheet:
Import Form Data Into Existing Spreadsheet With Excel 2013 and 2010
To bring data from new Microsoft forms into Excel 2013 or 2010, follow these steps: This adds the new Word form data to the very next row in your primary worksheet.
