How to Convert a Word Form to Excel

Use Microsoft Excel to convert Word form data.

Microsoft Word provides the ability to create interactive form that users can complete. You might need to extract the form data into a spreadsheet, for instance, if you want to analyze and compare data among multiple form answers. Instead of doing this manually (which could take quite a long time), convert the form using Microsoft Excel's Text Import Wizard.

Things You'll Need

• Microsoft Word
• Microsoft Excel

Instructions

1. Open a completed form in Microsoft Word.

2. Click the "Microsoft Office Button." Click the "Word Options" button.

3. Click the "Advanced" tab. Under "Preserve Fidelity when Sharing this Document," select "Save Data as Delimited Text File." Click "OK."

4. Click the "Microsoft Office Button." Click "Save as." Under "Save as Type," choose "Plain Text." This will save the file as a TXT extension, which Excel will be able to read. Click "Save."

5. Click "OK" on the "File Conversion" dialog box. This confirms that your form formatting will be lost after converting the file.

6. Open a new worksheet in Microsoft Excel.

7. Click the "Data" tab. In the "Get External Data" group, click "From Text."

8. Select the text file you just created. Click "Open." The Text Import Wizard will open.

9. Select "Delimited" under "Original Data Type." Click "Next."

10. Uncheck "Tab." Select "Comma." You can see the text changes below. Click "Next." Click "Finish."

11. Select cell A1 in the top-left corner of the worksheet. Click "OK." The data will be imported into the worksheet, with the headers above row one.

Tips & Warnings

• To convert additional forms, click in the next row to import a new text file of data.

References

• TechRepublic: Transfer Data from Word Forms to an Excel Worksheet