Hi,
Yes you can do this.
Firstly you need to export the completed form as a TXT file but first you need to go into File > Options. Select the Advanced section and scroll down till you see the Preserve Fidelity when sharing this document section. Tick the box for Save form data as delimited text file then click OK.
Open a copy of the completed form in Word. Select Save As and choose the file format as .txt. Now open Excel and select the Data tab and click the From Text button within the Get External Data group. Locate the TXT file you just saved, click Import, go through the Text Import Wizard and select Delimited as the file type, select the comma option as the delimiter you are using and complete the wizard and the data will be bought straight into Excel. You just repeat for each completed form.
Once you are finished the process and no longer need forms to save the data only I'd untick the option in the File > Options in Word.
There may be a slight difference in the sequence in Word 2013 but the option is certainly available as I'm using 2010 at present.
|