Editor'due south note: In the video, Brandon Vigliarolo walks you through the steps of transferring data from Word forms to an Excel worksheet in Microsoft Office 365.

Word forms provide a convenient manner to assemble information from users or clients so that you can analyze it afterwards. Just bringing the data into Excel can be a big chore. To avert having to manually enter the data into a worksheet, permit Excel'southward Text Import sorcerer bring it in for you. To demonstrate, allow's say y'all've asked employees to complete the form shown in Effigy A.

LEARN More than: Office 365 Consumer pricing and features

Figure A

Follow these steps to relieve the data in each completed form to a text file that can be imported into Excel:

  1. Open up one of the completed forms.
  2. Become to Tools | Options, click the Save tab, and select the Save Data Just For Forms check box. (In Word 2007, click the Office button, click Advanced, scroll to Preserve Fidelity When Sharing This Certificate, and select the Salvage Data As Delimited Text File bank check box.)
  3. Click OK.
  4. Save the file as a .txt file.
  5. When the File Conversion dialog box appears (Figure B), click OK.

Figure B

You can now import the data in the text files into a spreadsheet by following these steps:

  1. Open a blank worksheet in Excel.
  2. Go to Information | Import External Data | Import Data. (In Excel 2007, click the Data tab, click Get External Data, and and then select From Text.)
  3. Click the text file you want to import, then click Import.
  4. Select the Delimited pick (Figure C) then click Next.

Figure C

  1. For this case, clear the Tab bank check box and then select the Comma cheque box (Effigy D).

Effigy D

  1. Click Next and then click Terminate.
  2. Click in cell A1 and so click OK.

Figure E shows the resulting data. Note that headers have been inserted to a higher place the data in row ane.

Effigy Due east

To import the second text file, you lot just open up the same Excel worksheet and click in the second row beneath the concluding row of data; in this case, A4. (The wizard forces yous to skip a row each fourth dimension you add a new row of data. You can delete these blank rows later.)

Meet: Comparison nautical chart: Office suites (Tech Pro Research)

Of import note: If you need to enter more than a handful of forms a day, you should consider using ADO (ActiveX Data Object) to create a code connection to the worksheet that volition automate the data transfer process.