Usually, these forms are distributed so that many people can fill them out and return them.
Thankfully, it’s very easy to export Word form data to Excel using comma-delimited files.
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, selectFile>Options.
SelectAdvancedin the panel to the left of the Options dialog box.
PressOKto end the Word Options dialog box.
At this point, there are two ways to export the data to Excel.
Either save the document or export the data.
The Save As dialog box opens with theTXTfile format already selected.
Name the file, and selectOK.
A dialog box appears with a preview of the data you’re exporting from the form into CSV format.
PressOKto export the data.
Word inserts commas between the fields.
Excel uses the commas to separate the data into specific cells.
SelectChange File punch in.
Under Document File Types, selectPlain Text (*.txt).
SelectSave Asto pop crack open the Save As dialog box.
launch the CSV file following these steps:
Open a blank Excel document.
In the file throw in drop-down list, chooseAll Files (.).
Browse to the folder where the exported Word form data is located, and grab the CSV text file.
Excel opens the Text Import Wizard.
ChooseDelimited, and selectNext.
Deselect theTabcheckbox, and select theCommacheck box.
The data from your Word form appears in your Excel sheet.
Create a new sheet by pressing the+symbol at the bottom of the existing sheet.
opt for new text file with the form data, and selectImport.
In the Wizard, selectLoad>Load To.
Under Where do you want to put the data, selectExisting worksheet, and make sureA1is selected.
Right-click, and selectCopy.
In Excel, select your main worksheet.
Highlight the cell just below the last record in the sheet.
Right-click, and selectPaste.
SelectData>From Text.
In the Wizard, chooseDelimited, and pressNext.
Deselect theTabcheckbox, select theCommacheck box, and selectNext.
UnderWhere do you want to put the data, selectExisting worksheet.
verify the cell where you want the new row to go is selected.
This adds the new Word form data to the very next row in your primary worksheet.
