When the File Conversion dialog box appears ( Figure B), click OK.(In Word 2007, click the Office button, click Advanced, scroll to Preserve Fidelity When Sharing This Document, and select the Save Data As Delimited Text File check box.) Go to Tools | Options, click the Save tab, and select the Save Data Only For Forms check box.Microsoft 365: A side-by-side analysisįollow these steps to save the data in each completed form to a text file that can be imported into Excel:

How to return first and last times from timestamps in Microsoft ExcelĬhecklist: Microsoft 365 app and services deployments on Macs Get Microsoft Office Pro and lifetime access to 5 top apps for $59.99 LEARN MORE: Office 365 Consumer pricing and features Figure A More about Software To demonstrate, let’s say you’ve asked employees to complete the form shown in Figure A. To avoid having to manually enter the data into a worksheet, let Excel’s Text Import wizard bring it in for you. But bringing the data into Excel can be a big chore. Word forms provide a convenient way to gather information from users or clients so that you can analyze it later.

Editor’s 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 excel