Others

How to Automatically Convert Microsoft Forms Responses to Word Documents

Huma Ashraf ChHuma Ashraf Ch Nov 3, 2026 872 views

Question details

The user wants to automatically generate and save a completed Word document for every new submission received via Microsoft Forms.

How to Automatically Convert Microsoft Forms Responses to Word Documents
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.
Before you start

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.

Solution 1Recommended

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.

1
Prepare the Word Template

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.

2
Create the Power Automate Trigger

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.

3
Retrieve Response Details

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.

4
Populate the Word Template

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.

5
Save the Generated Document

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.

Use Power Automate to Populate a Word Template
Premium Connector Required: The 'Populate a Microsoft Word template' action requires a Power Automate Premium license or a qualifying enterprise plan. Ensure your Microsoft 365 subscription supports premium connectors.
Free Microsoft Office alternative

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. 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. 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. 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. 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.
High compatibility with Microsoft Excel (.xlsx) and Word (.docx) file formats.Built-in Mail Merge feature allows batch creation of documents directly from spreadsheet data.No coding, premium cloud subscriptions, or complex automation workflows required.Free to use with a lightweight, user-friendly interface that feels familiar immediately.
microsoft office alternative - wps office

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.