How to Automatically Convert Microsoft Forms Responses to Word Documents
Question details
The user wants to automatically generate and save a completed Word document for every new submission received via Microsoft Forms.

- Product
- Microsoft Forms, Power Automate, Word
- Device & OS
- not provided
- Scenario
- Collecting online form responses and needing to populate standard Word document templates automatically upon submission.
- Observed behavior
- Microsoft Forms currently stores responses in Excel by default, requiring a separate workflow to merge this incoming data into a customized Word document format.
Ensure you have a Microsoft 365 account with access to Microsoft Forms, Power Automate, and OneDrive or SharePoint. You will also need to prepare a Word document template featuring plain text content controls where the form data will be inserted.
Use Power Automate to Populate a Word Template
Create an automated cloud workflow in Power Automate that triggers whenever a new form response is submitted, extracting the data to populate a pre-formatted Word template seamlessly.
While Microsoft Forms does not have a native 'Export to Word' button for individual responses, you can build an automated pipeline using Power Automate. By utilizing the 'Populate a Microsoft Word template' premium connector, you can map form fields directly into a Word file and save it automatically to your cloud storage.
Open a blank Word document. Enable the Developer tab via File > Options > Customize Ribbon. Insert 'Plain Text Content Controls' in the document where you want the Form answers to appear, then save this template to your OneDrive or SharePoint.
Log in to Power Automate, click 'Create', and select 'Automated cloud flow'. Choose 'When a new response is submitted' under Microsoft Forms as your trigger and select your specific form from the dropdown list.
Click 'New step' and search for Microsoft Forms. Add the 'Get response details' action. Link it to the same form and insert the dynamic 'Response ID' from the previous step into the Response Id field.
Add a new action called 'Populate a Microsoft Word template'. Browse to the location of your saved template in OneDrive or SharePoint. Once selected, Power Automate will display your content controls; map the dynamic form fields into these respective slots.
Add a 'Create file' action for OneDrive for Business or SharePoint. Choose your desired output folder path, assign a dynamic file name (e.g., combining the responder's name and the date), and map the 'File Content' to the Microsoft Word document output generated in the previous step.

Batch Convert Excel Form Responses to Word Documents using WPS Mail Merge
If you don't have a Premium Power Automate license, you can simply export your Microsoft Forms responses to Excel and use the built-in Mail Merge feature in WPS Writer to batch-generate individual Word documents completely free.
- 1. Export Form Responses: Open Microsoft Forms online, navigate to the 'Responses' tab, and click 'Open in Excel' to download your collected responses as a local .xlsx file.
- 2. Prepare your WPS Template: Open WPS Writer and draft your standard document template. Navigate to the 'References' tab and click on the 'Mail Merge' button.
- 3. Import Excel Data: Click 'Open Data Source' and select your downloaded Excel file. Place your cursor in the document where the data should go, and click 'Insert Merge Field' to add the corresponding form data.
- 4. Merge to New Documents: Once your fields are mapped, click 'Merge to Different New Document'. WPS Writer will automatically generate and save individual Word documents for every form response in the spreadsheet.

Frequently Asked Questions
Can Microsoft Forms directly export to a Word document without Power Automate?
No, Microsoft Forms natively stores response data in Excel only. To create a customized Word document for each response automatically, you must use an automation tool like Power Automate to map the Excel data into a Word template.
How do I add content controls to my Microsoft Word template?
You must first enable the Developer tab in Word by going to File > Options > Customize Ribbon and checking 'Developer'. Then, select the text area in your document, go to the Developer tab, and click the 'Plain Text Content Control' icon to insert placeholders for your form data.
Where are the automatically generated Word documents saved?
During the Power Automate flow setup, you must configure a 'Create file' action at the end of the workflow. This allows you to choose exactly where the output files are saved, typically in your OneDrive for Business or a specific SharePoint site document library.




