Are you looking to export your Microsoft Forms data to Microsoft Word for further analysis, reporting, or record-keeping? While Microsoft Forms doesn't have a built-in export feature to Word, there are several workarounds to help you achieve this. Let's explore some methods to export your Microsoft Forms data to Word.
Before we dive into the methods, ensure you have the necessary permissions to access and export data from Microsoft Forms. Also, make sure you're using a compatible version of Microsoft Word, as the steps may vary depending on the version.
Exporting Microsoft Forms Data to Excel and then to Word
Microsoft Forms allows you to export data to Excel, which can then be converted to Word. Here's how to do it:
1. Open your form in Microsoft Forms and click on 'Respondents' at the top of the page.
Exporting to Excel
1. Click on the three dots (⋮) at the top right corner of the responses table.
2. Select 'Export responses' from the dropdown menu.
3. Choose 'Excel' as the format and click 'Export'.
Converting Excel to Word
1. Open the exported Excel file in Microsoft Excel.
2. Select the data you want to convert, then click on the 'Home' tab in the ribbon.
3. Click on 'Copy' (or press Ctrl + C).
4. Open a new or existing Word document in Microsoft Word.
5. Place your cursor where you want to paste the data, then click on the 'Home' tab in the ribbon.
6. Click on 'Paste' (or press Ctrl + V). The data will now be pasted into your Word document.
Using Power Automate to Export Microsoft Forms Data to Word
Power Automate is a cloud-based service provided by Microsoft that allows you to create automated workflows between apps and services without writing code. Here's how to use it to export Microsoft Forms data to Word:
1. Sign in to the Power Automate portal (
Creating a New Flow
1. Click on 'Create' from the top menu, then select 'Automated flow'.
2. Choose 'When an item is created or modified' as the trigger for your flow.
Adding Actions
1. Click on the '+' icon to add an action. Search for and select 'Get responses' from Microsoft Forms.
2. Click on the '+' icon again to add another action. Search for and select 'Apply to each' from the Dynamics 365 connector.
3. Click on the '+' icon inside the 'Apply to each' action. Search for and select 'Create file' from OneDrive.
4. Configure the 'Create file' action to save the response data in the desired format (e.g., .txt or .csv) to your OneDrive account.
5. Click on the '+' icon again to add another action. Search for and select 'Copy file' from OneDrive.
6. Configure the 'Copy file' action to copy the created file to your desired Word document location.
Testing and Turning On Your Flow
1. Click on 'Test' to run a test of your flow using sample data.
2. Once you're satisfied with the results, click on 'Save' to give your flow a name, then click 'Turn on'.
3. Your flow is now active and will automatically export new Microsoft Forms responses to Word whenever they're submitted.
By using these methods, you can efficiently export your Microsoft Forms data to Word for further processing and analysis. Whether you choose to manually export data from Excel or use Power Automate for automated exports, both methods can help streamline your workflow and save you time. Happy exporting!